Using CRXIr2 w/SQL 2005
I have two reports created with a SQL command with the parameters as part of the command: {?StartDate}, {?EndDate} & {?ClientID}.
I've linked on all three parms. If I populate with a ClientID both reports display results for that ClientID.
But, if I don't populate the ClientID parm and use --Any Value-- for all, the report displays two sets of results where the sub-report isn't necessarily inclusive to the parent report.
How can I force the sub-report results to be ONLY for those clients that display in the parent report exclusively?
LT
I have two reports created with a SQL command with the parameters as part of the command: {?StartDate}, {?EndDate} & {?ClientID}.
I've linked on all three parms. If I populate with a ClientID both reports display results for that ClientID.
But, if I don't populate the ClientID parm and use --Any Value-- for all, the report displays two sets of results where the sub-report isn't necessarily inclusive to the parent report.
How can I force the sub-report results to be ONLY for those clients that display in the parent report exclusively?
LT