BusinessObjects Board

Running a report with LOV value 'ALL'

Hi,

I have modified the LOV of an object to include ‘ALL’ in the list of values. the code is:

SELECT TABLENAME.COLUMNNAME
FROM
TABLE
UNION
SELECT ‘ALL’ FROM DUAL

While running the report, if i select ALL from LOV, there is no data returned. How do i tell BO that when i select ALL from LOV, it should include all the values associated with the object.

Thanks


raovala (BOB member since 2004-11-01)

This item has been asked/discussed a lot. Therefor it ended up in de designer FAQ: https://bobj-board.org/t/15227/2


jobjoris :netherlands: (BOB member since 2004-06-30)