Hello,
I have a main report and a few sub-reports as links. All reports use the same stored procedure. The stored procedure uses start_date and end_date parameters within the stored procedure. what I would like to do is have the user enter the date parameter once for all sub-reports. what I'm seeing is the date parameters for each sub-report. In the subreport links on the lower left side I see ?@Start_Date and ?@End_date. This looks good but on the right hand side I'm not able to select data in subreport based on field. Its greyed out. Is this correct?
I have a main report and a few sub-reports as links. All reports use the same stored procedure. The stored procedure uses start_date and end_date parameters within the stored procedure. what I would like to do is have the user enter the date parameter once for all sub-reports. what I'm seeing is the date parameters for each sub-report. In the subreport links on the lower left side I see ?@Start_Date and ?@End_date. This looks good but on the right hand side I'm not able to select data in subreport based on field. Its greyed out. Is this correct?