Skip to Content
0
Former Member
Apr 28, 2014 at 08:16 PM

How to pass Multivalue parameters from main report to the subreport to a database stored procedure

394 Views

I am having a Main Report, where the user selects the parameters, and calls the subreport which in turn calls the stored proc which updates the report parameters table, which will be used by all the other sub reports to filter data on.

It works fine when I pass single values from the Main report to the sub report, and it updates the database, but when I map the formula field to the subreport, the subreport does not even show up, and nothing happens on the database. I am thinking the subreport is not executing. I am using the 'Change Subreport Links' to map the formula fields to the subreport parameters.

Please let me know if there is any other work around or a sample report which solves a similar problem.