BusinessObjects Board

Displaying all LOVS just by selecting '*ALL' LOVusing promt

building reports desktopintelligence
#1

Hi,

The customer would like us to modify the selection list for all the prompts in the reports .
The selection list should include the value ‘*ALL’, and when the customer selects that value the report should return all possible values for that selection criteria.

This is my problem.I would appreciate if any body reply to this problem.

Thanks

kumar_m01 (BOB member since 2006-07-27)

#2

kumar you had already posted this question.

please continue there. Do not cross post

KhoushikTTT :us: (BOB member since 2005-02-24)

#3

hello Neo,

That is not dealing my task.Hence posted again.
Can any one plz help me for this.

In a prompt if user pick a ALL value from LOVs list then all Lovs have to display.

Thanks

kumar_m01 (BOB member since 2006-07-27)

#4

what is the problem,
you dont see the ‘ALL’ in lovs?
or

when you select ‘ALL’ it doesnt give you the data?

vellachi (BOB member since 2005-07-11)

#5

Hi Neo,

Its working from reporter level.I can pick the values by inserting condition at reporter level.

But i need the solution at designer level.why because
there are 82 reports to reduce.

Waiting for reply,

thanks

kumar_m01 (BOB member since 2006-07-27)

#6

Hi,
Suppose you have a object at the universe level called ‘country’

you can create a condition at the universe level as below

@Select(class name\country) IN @Prompt('Select country','A','class name\country',multi,constraint) OR 'ALL' IN @Prompt('Select country','A','class name\country',multi,constraint)

you can select this condition in all the reports.
the user will be prompted to select the country,it all allows you to select one or ALL lov’s

Thanks
vellachi

vellachi (BOB member since 2005-07-11)

#7

Cross-posting is against our rules.

Be patient. If you don’t get a reply in a day or two, post a follow-up to bump your topic back up. But do not cross-post.

Hence, locking this topic.

Since this is a LOV/Designer question, I had moved your other topic to the Semantic Layer forum, which is where Designer questions are discussed.

Anita Craig :us: (BOB member since 2002-06-17)