Skip to Content
avatar image
Former Member

Passing multiple values to detail report


Could you please help me on below scenario..

Report1 has below data and it has “Year” prompt


Report2 has City and Revenue data and it has Year and State prompts

Scenario is: when user click on any state in report1 then report2 should display for that state and whatever ‘Years’ selected in Report1 should also pass to the Report2

Below hyperlink is created on State in report1. It is working as expected, i.e. when user selects 2 years (for ex: 2004;2005) in report1 then same 2 years are passing to report2.


------ Formula for varYear in above link = Userresponse(“Year”)

If I am using the 'Year' object instead of variable (varYear) then data is splitting for each year and displaying like below.



I can’t use userresponse() because My report is on BEx query and as you know we should pass only ‘Key’and not the ‘Text’. And I can’t use ‘if else’ also like below to get the ‘Key’ values, because list is not static and user can select any values from the big list.


Issue is I need to pass multiple selected values in report1 to report2.

Could you please tell me why it is displaying correctly with variable and why it is not displaying correctly when using object ‘Year’ and is there any work around to display the aggregated data like below.


Thank you again,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 04, 2015 at 10:44 AM

    Hi Suri,

    The images as well as hyperlinks seem to be corrupt.

    Can you please fix it?



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2015 at 09:06 PM

    May i know if you have tried using the ReportFilter([Object]) instead of userresponse?

    Add comment
    10|10000 characters needed characters exceeded