Parameter passing

[system]

Can I pass a parameter with All, Single value to a report?

2. The report should display only single value, when single value is passed, and when ‘ALL’ value is passed, it should values in the report For Eg: Region: east,west,north,south,ALL’.

When a region vaue ‘east’ is selected , it sould display east. when ‘ALL’ is selected, it should display east,west,north,south values. Is this possible? then how?

---

jayad (BOB member since 2008-07-11)

[system]

you need to create a filter at universe level to pass to the child report

FAQ: Designer

Now that my LOV lets me use ALL for all values, how do I get the ALL in the list? Author: Dwayne Hoffpauir There are two approaches - overriding the LOV SQL, and creating a universe object. Overriding the LOV SQL Press the SQL button in the query panel of the LOV Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FRO…

---

Bhargava Ram (BOB member since 2005-09-27)

[system]

Hi,

I have done the lov combining ‘All’ as below:
Overriding the LOV SQL

1. Press the SQL button in the query panel of the LOV
2. Added the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database.
3. Click the “Do not generate SQL before running” checkbox.

But the object when I drag in webi does not appear with ‘ALL’ in it.
i.e. the other values except ‘ALL’ appears.

Thanks

---

jayad (BOB member since 2008-07-11)