I have a report where I am using 3 sets of parameters for begin and end dates (report, current, previous). The main report uses report_begin_date and report_end_date in the select statement to grab 2 months worth of data. In the main report where I am displaying monthly data metrics I use formulas and running totals using current being/end dates and previous begin/end dates to show either current month data or previous month data.... Hope that makes sense...
Anywho, I have multiple sub reports in the main report using the SAME parameter field names, and I want to link them so I have only prompted for 3 sets of parameter field entries (report, current, and previous). When I insert one of the sub reports I am prompted for more than 3 sets of parameter field entries when refreshing the report if I want to change a date range somewhere (ranges are duplicated). I tried using the subreport links to link main report param fields to the param fields in the sub report, but that didn't change anything.
Is this not the point of linking the main report fields to the sub-report fields? Or does it not work this way specifically because I am using date type parameter fields?
Thanks!
Anywho, I have multiple sub reports in the main report using the SAME parameter field names, and I want to link them so I have only prompted for 3 sets of parameter field entries (report, current, and previous). When I insert one of the sub reports I am prompted for more than 3 sets of parameter field entries when refreshing the report if I want to change a date range somewhere (ranges are duplicated). I tried using the subreport links to link main report param fields to the param fields in the sub report, but that didn't change anything.
Is this not the point of linking the main report fields to the sub-report fields? Or does it not work this way specifically because I am using date type parameter fields?
Thanks!