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)