{STOREDGRADES.COURSE_NUMBER} like "*LA*" and
{STOREDGRADES.STORECODE} = {?My Parameter} and
{STUDENTS.LAST_NAME} = {?LastName} and
{STANDARDS.IDENTIFIER} like "*LA*"

 

However my problem comes in as I need multiple selections of the same data such as the following, so I need LA, Math, Science etc to follow.

 

{STOREDGRADES.COURSE_NUMBER} like "*MA*" and
{STOREDGRADES.STORECODE} = {?TermID} and
{STUDENTS.LAST_NAME} = {?LastName} and
{STANDARDS.IDENTIFIER} like "*MA*"

 

I tried creating a sub report, I might be doing something wrong, I ended up getting 160 records back for each subreport as it parsed the database.  The code alone works only showing the 2 results which is what I want.  However I need multiple instances of the same but different data.

 

My SQL statement is:

 

 SELECT "STUDENTS"."FIRST_NAME", "STUDENTS"."LAST_NAME", "STUDENTS"."GRADE_LEVEL", "STOREDGRADES"."STORECODE", "STOREDGRADES"."TEACHER_NAME", "STOREDGRADES"."COURSE_NUMBER", "STANDARDSGRADES"."TRANSAVERAGESCORE", "STANDARDS"."NAME", "STANDARDS"."IDENTIFIER"
 FROM   (("PS"."STUDENTS" "STUDENTS" LEFT OUTER JOIN "PS"."STOREDGRADES" "STOREDGRADES" ON "STUDENTS"."ID"="STOREDGRADES"."STUDENTID") LEFT OUTER JOIN "PS"."STANDARDSGRADES" "STANDARDSGRADES" ON "STUDENTS"."ID"="STANDARDSGRADES"."STUDENTID") LEFT OUTER JOIN "PS"."STANDARDS" "STANDARDS" ON "STANDARDSGRADES"."STANDARDSID"="STANDARDS"."ID"
 WHERE  "STOREDGRADES"."COURSE_NUMBER" LIKE '%LA%' AND "STOREDGRADES"."STORECODE"='T1' AND "STUDENTS"."LAST_NAME"='SOMELASTNAME' AND "STANDARDS"."IDENTIFIER" LIKE '%LA%'

 

Maybe I am thinking wrong in trying to use sub reports, any direction would be greatly appreciated. 

 

Thank you

Shawn

 

I have a mockup of what the report should look like.  What I find interesting is if I run the sub report seperatly it displays The 2 items I want only 1 time.  When I add it as a subreport it displays the 2 items I want 160 times.  Have been playing with linking trying to figure out if that's where my issue is.  I am using parameters if that makes a diffrence.

 

When you say write a selection to filter the subereport, do you mean in the master, or the sub report itself?  If it's the subreport I am filtering, and that works in a standalone report. 

 

If it's the Master I am unsure how to do that.

 

 

Thank you

Shawn

 

What I want to do with the data which your right is different is pull something like:

 

Term1  Course Name  (such as LA)

Teacher Name

Reading Score

Writing Score

Comments

 

Then repeat for the next subject and so on

 

Comments

 

One of my thoughts is it would be perfect if I could loop through an array that looked at the standards.identifier and storedgrades.course_number tables.

 

Thank you so much for your help I really do appreciate it.

 

{STOREDGRADES.COURSE_NUMBER} like "*LA*" and
{STOREDGRADES.STORECODE} = {?My Parameter} and
{STUDENTS.LAST_NAME} = {?LastName} and
{STANDARDS.IDENTIFIER} like "*LA*"
or
{STOREDGRADES.COURSE_NUMBER} like "*MA*" and
{STOREDGRADES.STORECODE} = {?My Parameter} and
{STUDENTS.LAST_NAME} = {?LastName} and
{STANDARDS.IDENTIFIER} like "*MA*"
or
{STOREDGRADES.COURSE_NUMBER} like "*SS*" and
{STOREDGRADES.STORECODE} = {?My Parameter} and
{STUDENTS.LAST_NAME} = {?LastName} and
{STANDARDS.IDENTIFIER} like "*SS*"

 

Hoping this might give a better idea of how I have to pull the data.