I was hoping someone could help me with the following issue.

I am trying to link to a sub report on multiple fields and user inputted parameters.

What I have is 3 Tables a Terms table, a Storedgrades table, and a standardsgrades table.  I have it set so the user can select Terms.YearID using a parameter by the name of ?TheSchooLYear.

I am trying to link like the following:

?TheSchooLYear (Terms.YeardID Dynamic drop down) --> standardsgrades.yearID

And

terms.id --> storedgrades.TermID

I do not seem to get any data when I link like this.

What I am wondering is if I need to add a parameter for users to select terms.id (which seems kind of redundant) or if I can create some sort of formula to link these.

Why I need to link this way is the year format is different in each table

terms.id looks like 20,21,22 (Could change) etc

terms.YearID looks like 2000,2001,2002 etc

The only link to the year is from terms to each table

On my main report I have Terms linked terms.yearid to standardsgrades.yearID in my sub reports I do not have the terms table as I do not see a need for it and when I add it I cannot link.

As I write this I noticed one thing I will try again and that is adding a second link in my database expert to link storedgrades to my terms table, if I recall I tried this and it crashes crystal reports.

Thank you for taking the time to read this  :)

Thank you for the reply, I did figure out a way to make this work however I am now facing the following problem.  In my sub report I would like to do something like the following in the select statement: (When I try this it is very, very slow)

if isnull({STOREDGRADES.STUDENTID})
then
{STOREDGRADES.TERMID} = {?Pm-TERMS.ID} and
{STUDENTS.ID} = {?Pm-STUDENTS.ID} and
{STOREDGRADES.COURSE_NUMBER} like "*LA*" and
{STOREDGRADES.STORECODE} = {?Pm-?Storecode}
else
{STOREDGRADES.TERMID} = {?Pm-TERMS.ID} and
{STUDENTS.ID} = {?Pm-STUDENTS.ID} and
{STOREDGRADES.COURSE_NUMBER} like "*LA*" and
{STOREDGRADES.STORECODE} = {?Pm-?Storecode}and
{STANDARDSGRADES.YEARID} = 21

The problem I am facing here is one table has to be displayed {STANDARDSGRADES.}  If there is Data in the table.  However I am having trouble getting my head around this as it filters too much.  If I use the following:

{STOREDGRADES.TERMID} = {?Pm-TERMS.ID} and
{STUDENTS.ID} = {?Pm-STUDENTS.ID} and
{STOREDGRADES.COURSE_NUMBER} like "*LA*" and
{STOREDGRADES.STORECODE} = {?Pm-?Storecode}and
{STANDARDSGRADES.YEARID} = 21

The sub report has the Data I want with the Standardsgardes table but does not display the data from IDS that do not have information in the standards table.  If I try the following formula I get the reverse of above.

{STOREDGRADES.TERMID} = {?Pm-TERMS.ID} and
{STUDENTS.ID} = {?Pm-STUDENTS.ID} and
{STOREDGRADES.COURSE_NUMBER} like "*LA*" and
{STOREDGRADES.STORECODE} = {?Pm-?Storecode}

This makes sense to me because I am using "AND"

I am just having trouble with the logic of getting both to display.