Multi-Value with in SQL Server Repot

Question

Post reply

Multi-Value with in SQL Server Repot

Neer Saini

SSC Rookie

Points: 27
More actions
August 25, 2006 at 3:03 pm

#116475

I have a report which accepts multi value - check box paramter, i remember when i was using SQL 2000 Reporting i use to automatically get the <Select ALL> options in that list on selecting all options gets selected. but when i am using SQL 2005 i dont get that option in the parameter list.

Any Idea how to achieve that in the report. as my drop down list is too big for any uders who wants to select all they have trouble selecting all values one by one

I appreciate your help on this.

Thanks

Neer Saini
August 28, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

GoofyGuy SSCertifiable Points: 6059 More actions · Answer 1

Neer,

In the "Report Parameters" setup, there is a "Prompt" checkbox that says "Multi-value". If you check this box, the report user will see a drop-down with all values; the very first one says "Select All". If the user then checks the "Select All" option, all drop-down options are then automatically selected. I hope this will solve the problem.

Kind regards,

Craig

Neer Saini SSC Rookie Points: 27 More actions · Answer 2

Hi Craig,

Thanks for your help. I have set up the way you told me But in SQL Server 2005 with Server pack 1, it does not give me option for ' Select all'. I have solved the problem by adding 'ALL' field and taking care of that in Stored Procedure.

If you know somw other way, please let me know.

Thanks

Neer Saini