parameters

Hello,

i am new to ssrs and am trying to generate a report with 4 parameters. 2 of which are dates. The other 2 are drop downlists. Now the report works fine when i enter all 4 parameters. But in some cases i want to leave one of the parameters unentered . It doesnt all me to do that. Gives a error saying i need to enter the parameter. How do u get aroud this issue ?

I have seperate dataset for this parameters list and am using a where clause in my main query.

Can anyone please help me out with this?

Thx

Ashish

the parameters which are not needed all times can be set as

1. under parameter properties check all ow null values option

2. take default value for parameter as null

hope these will solve u r problem

|||

the parameters which are not needed all times can be set as

1. under parameter properties check allow null values option

2. take default value for parameter as null

hope these will solve u r problem

|||

hello rakam,

Thx for the reply.

My problem still continues. i tried ur suggestion but it still prompts me to select that paramater when trying to view report.

Any other options with be appreciated.

Thx

Ashish

|||The only thing you should have to do is define a valid Default value in the parameter setup in Design view of the report. If you still have the problem after saving and redeploying the report, you may want to delete the report from the report server and then deploy it again. Sometimes the subtle updates don't post properly unless you delete first.|||Read this article http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1061210&SiteID=1