Want to display seperately for each user..

[system]

Hi Everyone,
Here we are working with a case in which we have requirement that
we have list of values(1,2,3,4,.,.,.,all,detail).

Here when we select different user codes for example:“1” then it should show for that user and when
we use “all” it should show for each user with for “all” users clubed.

Now when user selects “detail” then it should be displayed seperately for
each user code in the master section and it’s coressponding detail table
seperately
Thanks&Regards
Akki
Note:it’s urgent any feedback will be welcomed and appriciated,we
basically want to know for detail option,other things are working.

---

Akash Rochwani (BOB member since 2006-08-29)

[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.

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…

---

KhoushikTTT (BOB member since 2005-02-24)

[system]

Regarding your “detail” requirement, perhaps you could get clever with hiding tables and having a report-level variable that detects whether the user has selected “detail”.

You could search on BOB here for “hiding tables”.

Good luck
Judy

---

JMulders (BOB member since 2002-06-20)