April 25, 2007 at 6:50 am
Hi
All are reports are with a parameter Called Division.
There the user has to select a parameter.
Now I want also to have the opportunity to select all.
How can i do this ?
The list of divisions is a result of a query. Should I add a union with '*' ?
Thx in advance.
JV
April 25, 2007 at 8:12 am
Please read my post on the same subject.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=360261#bm360292
April 27, 2007 at 8:33 am
Is the parameter a multi-value one ?
If so then a 'Select All' option is included with SQL Server 2005 and SQL Server 2005 SP2, note the missing SP1, it was there, it was gone, now it is back :-))
Cheers,
April 30, 2007 at 11:48 am
Ive gone with UNION ALL in the past ... and it works.. I'd go with a Union All
Moe C
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply