Hi, Recently I've tried to design a few reports against a model by using BIDS (2008 R2). I'm faced with an issue regarding an optional filtering - in a regular report I could prepare a set of values with an ALL option and then in the dataset query I would add an option to invalid the parameter like so: WHERE field = @param1 or @param1 IS NULL I couldn't find a way to achieve the same functionally for the model based report. Does someone know of a way to do this?

Hi tamirk, Try to enable dataset or data region filters. For example, define a param1, on the dataset/data region(Tablix), new a filter. On the filter page, Operator: = Value Expression: =IIF(Isnothing(@param1),nothing,@param1) Hope this helpfully, thanks, Jerry

Hi Jerry, Thanks for your reply but the expression you wrote doesn't work for me. If @Param1 is blank or null then the dataset returns empty and not full. Furthermore, doesn't this approach move the filtering to the RS process rather than sending it to the datasource (as with sql parameters) ? Thanks