BusinessObjects XI - Prompt for Section Headers

BusinessObjects Web Intelligence reports can’t prompt the end users for section headers on a report using its built-in features. However, this can be achieved by using the advanced report creation technique demonstrated below.

• Dynamically section a report based on Prompt response
• Requires new objects in universe

• Create query, using new objects

• Run the query, selecting a different object for each section

• Create a variable for each section

Section 1 Object:
=If([Section 1]="Lines";[Lines];If([Section 1]="State";[State];[Year])
)
Section 2 Object:
=If([Section 2]="Lines";[Lines];If([Section 2]="State";[State];[Year])
)
Section 3 Object:
=If([Section 3]="Lines";[Lines];If([Section 3]="State";[State];[Year])
)

• Finally, section the report on the 3 new variables