BusinessObjects Board

Problem to Include 'ALL' in the List of Values

building semantic layer
#1

Hi folks,

I need ‘ALL’ to be shown in the List of Values when the User press the ‘Show Values’ while running the Report.

I m using the following Syntax:

Object Name : ‘Media Type Prompt’

Select Clause Syntax : TIVO_SOURCE.MEDIA_TYPE

Where Clause Syntax : (@Select(Tivo Source\Media Type) IN @Prompt(‘01. Media’,‘A’,‘Tivo Source\Media Type’,multi,free) ) OR
(‘ALL’ in @Prompt(‘01. Media’,‘A’,‘Tivo Source\Media Type’,multi,free))

Though when the User manually enters ‘ALL’ in the prompt while running the report this is working fine but here ‘ALL’ is supposed to be displayed under the List of values.

Kindly suggest me the solution how to get ‘ALL’ shown under the List of values.

Thanks,
Nag Bhushan

bushan (BOB member since 2005-03-09)

#2

I guess you didn’t check the Designer FAQ, because the answer is there in the second Frequently Asked Question: Now that my LOV lets me use ALL for all values, how do I get the ALL in the list?.

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