Skip to Content
avatar image
Former Member

Pass value to Input Control in Web intelligence

Hello experts,

See if you can help me?

I have two web intelligence reports, one calls the other by a link through a year of parameter to filter the months of the second report.

I also have an input control that filters the region in the first report, I need the filter to make the input control reflected in the second report.

For example, step the year 2016 by prompt to the second report, it is ok.

Must pass the region "xyz" the first report is selected in the input control for the second report.

Someone has been there and can help me?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 28, 2016 at 06:40 AM

    You can pass parameter to a query prompt in the target report, but passing a value from parent report to the input control filter of target report will not be possible.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank Arijit Das,

      I guessed it already, but thought someone had some trick to circumvent this limitation. My user needs the input control in the two reports to choose between the regions, but wanted when define it in the first report the second caught the definition.

  • avatar image
    Former Member
    Oct 24, 2016 at 01:43 PM

    Hi Elton, Have you tested the function "filterreport" or "filterexploration" ? to analyse which filter is valide on your first report ?

    Best regards,

    Gérald.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      
      

      Hi Gérald, thanks for answering. In my case, a report filter does not solve the issue, I need to pass a parameter from one report to another, specifically a value from an input control to another input control in a second report.

  • avatar image
    Former Member
    Oct 24, 2016 at 03:55 PM

    follow below steps

    I guess you have 2 tabs , and input from report 1 has to reflect in report 2(tab2), First create a Summary tab that acts as a cover page and inputcontrol for user inputs

    then Create a variable which captures the selections selectd by user through Input control. use below formual

    =If( Pos(ReportFilterSummary("Summary");"region In List { ") > 0) Then Substr(ReportFilterSummary("Summary");Pos(ReportFilterSummary("Summary");"RegionIn List { ") + Length("region In List { ");999) Else "".

    Once this is done, need to capture the userinputs in form of 1,0

    create a filter

    =If(Match([Selected Region];[Region]+"*") Or Match([Selected Region];"*, "+[Region]+"*") Or [Selected Region]="") Then 1 Else 0

    On each of the report tabs, click on the analysis tab and then on the filter icon.

    Drag the filter object on the panel and filter on values that are 1.

    Now if the user selects any value in input control it reflects in 2nd report

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ghouse Baba Shaik, thanks for answering.

      I do not have two tabs, i have two reports, simulating a drill. I need to pass a parameter from one report to another, specifically a value from an input control to another input control in a second report.

  • Oct 26, 2016 at 09:50 AM

    Try something like this:

    [Variable]=reportfilter([Region])

    Use opendoclink to access the second report and pass the region variable data with it:

    http://../BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=567&sType=wid&sRefresh=Y&lsSRegion=([Variable])

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Kuldeep Ghosh

      Hi Kuldeep Ghosh,

      My client wants this feature, all my data is calculated using ETL and can not use a drill to aggregate the data in the same report. As I said before, I imagine that someone had already gone through it and could have some solution, actually the tool itself does not allow me to do what my client wants, as much researched about it and found nothing.

      Anyway, thank you all for trying to help me.