Want to display seperately for each user..

[system]

Its doable. Provide more information abou the data and the formatting your report needs.

To start with, when a user is selected (in prompt), the report is going to bring only data for that particular user. So, when all users are selected, data for all the users are displayed.

If you wan to know how to introduce all in the list of values, it is very well explained here.

120×120 10.4 KB

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…

---

KhoushikTTT (BOB member since 2005-02-24)