selecting report output based on seclection of Input control

[Former Member]

Hi,

I have 3 reports Group currency, Local Currency and Document Currecy reports in single webi report.

I want handle of displaying those reports based on selection of Input controls (Radio Button) in Webi.

Ex: when I select Group Currency Radio button, relevant Group currency report only should display.

Santhosh

[Former Member]

Santosh, try this solution, might this link will help you.

http://blog.davidg.com.au/2011/09/dynamic-measures-in-webi-on-any-data.html

[saurabh_sonawane]

try this work around .

1st = create variable "radio"

2nd = go to input control

create a new input control select a radio variable

3rd = click on custom

new window will come insert the list of value as shown below

     click on ok

create a 3 report(vertical table) which u want to show

select report A and right click on it and select format table

select HIDE WHEN FOLLOWING Formula is true

write the above formula in A table(report)

and some for B

= [radio]<>"B"

and for C

= [radio]<>"C"

[Former Member]

Hi Sujitha,

Thanks for the reply.

when I right click on the report and select format table following screen is appearing.

but the screen is different from the one which you were displaying before.

I don't have options to write formula here.

[saurabh_sonawane]

Hi

sorry please right click on a vertical table. then you will see that screen

create a 3 vertical table in one report

and the select on vertical table and right click on that table and write the formula and do the some step for remaining 2 vertical table

[Former Member]

In the Variable Editor, Right Click on Variable -- Create New --