on 01-08-2015 2:42 PM
Hi all,
Is there a way to pass multiple parameter values from main report to subreport? I am able to pass single value but i don't how to pass multiple values. When i try to pass multiple values only the last value is passed.
Thanks for any help.
Best regards,
Martin Zluky
Is this a parameter to the main report that you want to pass to the subreport? Or is it a formula from the main report?
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try this:
1. Delete the existing subreport link.
2. Create a new param in the subreport that is set to multi-value.
3. Create a new subreport link. In the "Subreport parameter field to use" table, select the parameter you just created.
This will ensure that the target param in the subreport is multi-value so it should contain all of the values from the main report.
-Dell
Hi,
it was not working properly. But i guess i figured it out. I did an extra step in the subreport. You need to use interactive filter in the subreport. I selected the result object to be filtered and the parameter i just created and which is getting the values from main report.
Regards,
Martin Zluky
Hi Martin,
1) What kind of a parameter is this - string, number?
2) Are you trying to 'filter' records inside the Subreport based on the values selected in the Main Report's prompt?
3) What is the datasource for the subreport - command sql, tables/views, stored procs?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Martin,
Does the Universe query in the Subreport also have a prompt and are you trying to link the prompt inside Main Report with this prompt? If yes, then unfortunately, there isn't a way to do this currently without getting of that Universe prompt.
You would need a selection formula inside the Subreport which is based a string concatenation formula that is received from the Main Report.
Depending on the number of records returned by the Universe (without this filter), this could tremendously slow the report.
-Abhilash
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.