Hi, i am still learning an i have one question that i could not find answer for. I have report with 4 parameters. If i allow null value in parameters everything works perfectly. I modified query that if parameter is null -> show all values in report. Problem starts when i disable null values and i want to configure report that if parameter is empty string the report shows everything. (no null checkbox next to parameter) ->when i use something like this in query it does not shows report at initialization. (You must click on show report, then works perfectly) (custumer like CASE when Len(@custumer)=0 then custumer else '%'+@custumer+'%' end) I realy want to show all resoults at start of report. ->If i set default values for parameters and set them to "" (empty string) the report shows all data at startup but then - when i change one parameter and hit enter (to apply changes) nothing happens.. if you click on show report it works normaly... This small but realy annoying things drive me nuts.. Please respond if u have any idea how to solve this. To show all data at startup and that parameters works liek this - empty string show all, if not empty filter resoults..

I am using report builder 3.0 and i forgot to tell earlier that in report builder everything works perfectly.. The problems starts when reports are uploaded on report server and opened with explorer... and yes i am up to date with everything.. I also tried a lot of variations of sql statement and realy do not think this is the case.. OK again two scenarios where this happens 1. parameters default values are =""(empty string), always refresh is checked, when i go to report in explorer it loads and shows all data at begining... when i want to insert parameter and press enter - all data dissapears (blank white screen with only parametes). If i press enter n times it is still blank. If on the other hand i press view report button on right the report shows perfectly with applied parameters and everything... Why the enter does not work? 2. parameters default values are disabled, always refresh is checked when i go to report in explorer it does not load data - only blank page with parameters. When i click view report it loads up data and shows it. When i want to insert parameter and press enter it works perfectly. It shows filtered data... So where is the catch with this? any idea is realy apreciated.. thanks:) bb

I'd suggest using an OR condition in your WHERE statement, rather than a CASE: WHERE ... AND (Len(@custumer)=0 OR custumer = @custumer) [assuming a single valued parameter, otherwise use: custumer IN (@custumer) ] I don't think that's causing your problem though. If you want the report to update automatically when you change a parameter value, try this (assuming you are using BIDS, other editors may vary in some details): Right click on the parameter and select 'Parameter Properties'. Go to the 'Advanced' tab. Select the 'Always refresh' radio button. Repeat for other parameters you want to behave in the same way. I hope that's helpful Ray

Please any idea anyone?