Hi guys, This is the question
Using CR10 and SQL2K
I have a report which use a SP with parameters
there ia also a SubReport.. well 2 actually, and they both use a SP with a single parameter each.
I have tried various type of linking
such as {subreport.Parameter} = {MainReport.Parameter}
or {Subreport.FieldValue} = {MainReport.Parameter}
or {Subreport.FieldValue} = {MainReport.FiledValue} and
{subreport.parameter} = {Subreport.FieldValue}
where Parameter = SP.Parameter
no matter what I do when I run the report it keeps asking me for the SP.Parameter from the Main report and the 2 Sub Reports.
am I doing something wrong somewhere along the line or it just cannot be done???
Thank you in advance for your help
Mo
Using CR10 and SQL2K
I have a report which use a SP with parameters
there ia also a SubReport.. well 2 actually, and they both use a SP with a single parameter each.
I have tried various type of linking
such as {subreport.Parameter} = {MainReport.Parameter}
or {Subreport.FieldValue} = {MainReport.Parameter}
or {Subreport.FieldValue} = {MainReport.FiledValue} and
{subreport.parameter} = {Subreport.FieldValue}
where Parameter = SP.Parameter
no matter what I do when I run the report it keeps asking me for the SP.Parameter from the Main report and the 2 Sub Reports.
am I doing something wrong somewhere along the line or it just cannot be done???
Thank you in advance for your help
Mo