Thanks for any ideas. The goal here is to show, within a subreport, YTD Sales figures. I'm struggling to successfully create the formula that will allow me to do this.
The user will input 2 values to the main report:
- Fiscal Period
- Fiscal Year
In the main report, I show sales for the matching fiscal period & fiscal year. That's working fine. But in the subreport, I want to show the sales for the SAME Fiscal year as given in the main report parameter, but for any fiscal period <= the Fiscal Period provided in the main report.
I've attempted to create a parameter in the subreport (YTDSalesFP) and then reference that within the select expert (eg {vSalesTYLY.Fiscal Period} <= {?YTDSalesFP} ) . After I do that, I'm struggling with the "Change Subreport links" dialog on the Main report. After all, I don't want to pass an existing column value to the subreport parameter ?YTDSalesFP} - I just want to use whatever value the user provided, and silently pass it through to the subreport parameter.
Is this possible? What other routes would you try?
