Multi Valued Report Parameters

Hi

I am new to SSRS and this Qs is basic reporting problem. I have a multi valued param called cycle in my report.
The user can select all ,one or two. But I also want to implement this way.
When the user doesnt select anything all the data should be displayed.
Here is the problem
param : Cycle ID Select ALL
One(1)
Two(2)
In the preview report as soon as i clcik viewreport it asks me to select a cycle id. is there a workaround for this.Please let me know.

Thanks
SQL NEW

[533 byte] By [SQLNew] at [2007-12-21]
# 1

You can do it in two ways.

With a stored procedure and using a CASE statement, check a variable and if that variables is empty make a select * without WHERE,

Control this from your application using the Reporting Services WebService, You will have to construct the interface for the parameters and then execute the webservice, I have a little example of how to do it on my blog.

http://spaces.msn.com/levalenciam

LuisEstebanValenciaMu?oz at 2007-9-10 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified