Hi Gurus,
I have a scenario to display the except prompt selection items. For example: i have values in value prompt like,
item 1(Prompt selectd)
item 2(Prompt not selected)
item 3(Prompt Selected)
item 4(Prompt not selected)
I have to display the item 2, item 4 names in report page. Is it possible, how to solve this?
Thanks & Regards,
Chandrasekar.
Hello Chandrasekar,
Do Item 1 through 4 come from a query? If so, create another query for display purposes and set a filter on it saying Item not in <your selections>. Then associate a list/repeater etc to display the values from that query.
If they are static texts you can always "force" it to come from a query using SQL objects that has an SQL like this:
Select distinct 1 from <sometable>
union all
Select distinct 2 from <sometable>
union all
Select distinct 3 from <sometable>
union all
Select distinct 4 from <sometable>