Skip to Content

How to pass multiple values from mainreport to subreport?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 08, 2015 at 02:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2015 at 02:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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