Linking 3 tabs in single webi report

[Former Member]

Hello,

I am working on WEBI 4.0 reports. Can you please help me for the following requirement.

I have to create single webi report with 3 tabs, each tab contains one report and on top i have to create 3 radio buttons. If user selects any radio button according to that it has to display that specific report.

I will tell you with example

I have 3 reports A, B, C. these shoud be in single webi report with tabs

radio button A, radio button  B, radio button C.  If user selcts A it should display A report, if B then B report........

Is there anyway to achieve this requirement?

Please help me SAP gurus

[saurabh_sonawane · Accepted solution]

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 · Accepted solution]

Hello Saurabh,

I think this gonna work.. Thank you so much.. I will try this... and let you know if i get any problem

And I want ask one more question when user selects A report i dont need to run other tabs(B ,C) for performance issue is there any way to do this...

Please let me know

Thank you

[Former Member · Accepted solution]

Hi Rajitha,

your requirement is " If user selcts A it should display A report, if B then B report........" correct?

As suresh sugested create radio variable and then select filter criteria on a single tab embedding all the report components in to that tab set the "Hiding Conditions" because we cannot apply input control options on tabs.

Regards,

Madhu

[Former Member · Accepted solution]

Thanks Saurabh,

One more question, in 3 tabs A,B,C reports I have to give A report for some users and other reports for some other users.. How can I give this.?

Thanks in advance

[saurabh_sonawane · Accepted solution]

sorry it cant be u have to create a other webi  for that user

[Former Member · Accepted solution]

Hello Madhu,

ya as suresh suggested i will try that and will message you if I get any issue...

Thanks for the information

[saurabh_sonawane · Accepted solution]

yes it is right u have to create all the 3 chart in one single report only

[Former Member · Accepted solution]

okay suresh, I will first create radio buttons as u suggested then ll get back to you

thank you so much for quick response

[Former Member · Accepted solution]

Hi Saurabhi,

When I create variable Radio and its giving only one value "A" in the list of values but how to get other "B", "C" into that list?

Thanks

[saurabh_sonawane · Accepted solution]

step to insert value in input control

in above figure there is a red box (Type a value)

in that manually type B

after that click on the green button then you will see value B in the selected values(s)

some steps for C

after you see all the 3 variable ie(A,B,C) in the selected value then click on OK button

[Former Member · Accepted solution]

Hey suresh It worked for me thank you so much......

In Radio button its displaying all values also(including A,B,C), is there any way to not to show all values????

[saurabh_sonawane · Accepted solution]

no it will come

[Former Member · Accepted solution]

okay no problem Thanks for your immediate response....

[saurabh_sonawane · Accepted solution]

you can check this

[saurabh_sonawane · Accepted solution]

yes now we can hide the ALL in INPUT control

plz check the below link

[former_member4998]

Hi

You can link the reports A, B, C using the element linking.

Web Intelligence 4.0: Link report elements using input controls

[Former Member]

Hello Sreenivas,

Thanks for your immediate response. Can you please give me details about element linking?

Thanks in advance

[former_member4998]

Find the below Video...and try to implement in your report. If still have any issues. Then will guide you.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/30fecdce-1c01-3010-328a-dcb7c52d60b9&override...

[Former Member]

okay Srenivas,

I will come to you after watching video

Thank you so much