BusinessObjects Board

Excluding promt values in Report

building reports desktopintelligence
#1

Hi All,

I searched on the forum and could not get the exact answer to my problem.

I have 5 prompts. This is my hierarchy

County – Area – District – Town – Ward

When I run the report I get 5 prompts one for each. The user should be able to run the report by any one of them. I have set my LOVs.

If I select any 3 or 4 prompts, the report should exclude the prompts which are not selected. I have seen a code which sets the default values in prompts to all and shows all values in the report.But I want to exclude the promts in the report which are not selected.

Any help is much appreciated.

kanth (BOB member since 2005-09-05)

#2

Hi,
This is not possible . Users need to enter some value in the prompt . Its not possible to skip the prompt.

Regards
Pradeep

pradeep.bm :india: (BOB member since 2004-06-09)

#3

Pradeep is technically correct, but there are techniques you can use to make a prompt optional. Do a search for “optional prompt*” here on BOB and you’ll find those techniques discussed. I would start with the first two postings in the Designer FAQ.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#4

Thanks for the reply.

kanth (BOB member since 2005-09-05)