BusinessObjects Board

Cascading Prompts

building reports webintelligence
#1

I have a cascading prompt in the report.The prompt is such that when I select Zone its will display all the State Offices for that Zone.When I Select State Office it will display all Division for that State Office.

Zone---->State office----->Division

Finally its the division which is passed to the Query.

As of now its only division in the filter clause.Is there any way I can have Zone and State office in the filter clause whatever I selected in the cascading prompt??

prateekjain85 (BOB member since 2010-05-11)

User Response in nested prompt
Cascading prompts
#2

In Web Intelligence, no, it doesn’t work that way. Crystal would allow you to capture all three levels. What I have done in the past is concatenate prior selections so the final item uses the entire hierarchy.

So you might select Zone 1, State TX, Division A. The final result would be 1.TX.A and would be compared to a combination of the three columns from the database. This has to be done (created) in the universe, not the report.

Dave Rathbun :us: (BOB member since 2002-06-06)

#3

Thanks Dave.

Is there any way I can capture the all the values entered at each level to display on the report header.

I tried User Response fuction but it displays the value for only the final selection.Is there any way out to capture the value for Zone and State.

prateekjain85 (BOB member since 2010-05-11)

#4

Already answered that:

The earlier prompts are only “in scope” and available to Webi during the LOV process. They are not part of the document in any way.

Dave Rathbun :us: (BOB member since 2002-06-06)