BusinessObjects Board

Dynamic report tabs in Deski Report (BO 6.5 SP4) using macro

Hi All,

Thanks in Advance!!

We have a requirement in our project, to create report tabs based on the Parameter values selected i.e., we have InList operator in the parameter. Different users might select different values based on this, the number of tabs needs to be displayed in the Deski report and currently we are working using BO 6.5 SP4.

Below, I have stated a sample example based on the above requirement:
Year State Revenue
2001 AP 100
2001 TN 200
2002 AP 100
2002 TN 300
2003 MH 500

I have generated a report with prompt on ‘Year’ and displaying State, revenue in report and using InList(to select multiple years) in the parameter. Now, the requirement is to generate the report containing tabs based on the number of values selected i.e., when I select Year = 2001, 2002 then report should display as:
2001 tab:
Year State Revenue
2001 AP 100
2001 TN 200
2002 tab:
Year State Revenue
2002 AP 100
2002 TN 300

If we re-run the report and select the years=2001,2002,2003 then the report should display in 3 tabs as above.

Please let me know whether this functionality is possible in BO 6.5 deski reports or not? Also, provide me any inputs or share the related documents to achieve this functionality if you have implemented in your projects as this is a critical requirement in our project.

Thanks & Regards
Sriram


bouser1 (BOB member since 2008-08-01)

Hi SriRam,

This Topic from BOB Downloads might be useful for your requirement.

-Satish


forgotUN (BOB member since 2006-12-13)