Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
multiple values in where clause
Migrateduser
Hi
In report parameters i want to give options in where clause
for ex.
where Name = 'Abc'
1. I can do it i f i need to give a name in where clause
2. I will not write where clause if i want all names
Now my query is if i want both options in list box of report parameter what i need to do
by both options i mean to say
option 1 particular name
option 2 All
this all contains all name
suppose my list box has three two options
1. All
2. Particular name
1. if i select all then it should display all results where name in(All)
2. If i selecct particular name it should display records wheere name = particular name.
Somebody please help me.
Thanks
Rajat
Find more posts tagged with
Comments
There are no comments yet