BusinessObjects Board

Dynamic/Cascading Prompts in Infoview 6.5

building reports desktopintelligence
#1

Hi!

What I’d like to do is the folllowing:

Let’s say I have 3 Levels of location: Country - State - City.

I want my three LOVs to be based off of Text Files or Excel Files.

State and city will contain ID - Name - Parent.

  1. I want to click on Country and select a country.
  2. When I click on State, I want to inject a hook that populates a dynamic LOV (Txt) based on my country.
  3. Same with City.

Please don’t tell me this is impossible. I know it’s possible. This is a must !!!

Please HELP!!!

AcE3001z (BOB member since 2004-11-22)

#2

What you want is also known as Cascading Prompts. Crystal Reports XI supports Cascading Prompts. For previous versions of Business Objects ver 6.x or ver 5.x, please take a look at this Designer FAQ entry for a work around.

Andreas :de: (BOB member since 2002-06-20)

#3

Basically,

In terms of process, when I click on State.

State is an object based on a LOV contained somewhere that is empty.

When clicking Show List of Values, a Hook will see that “State” button had a “Show List of values” clicked. The hook will determine that a certain “Country” was selected and dynamically populate the LOV with the Full State Excel Spreadsheet.

Infoview would continue working properly, getting the States from the dynamically populated LOV.

AcE3001z (BOB member since 2004-11-22)

#4

Another solution would be to create your own entry/prompt form using VBA for Full Client and jsp/asp of Webi SDK for Webi.

Andreas :de: (BOB member since 2002-06-20)

#5

Can you tell me how would go about (in principle) creating the cascading prompts with JSP SDK ?

Thanks!

AcE3001z (BOB member since 2004-11-22)