Thank you for your input.
First let me point that the query is not well structured, if you expect a collection from the parameter (CountryID in (@CountryID)
) the checking for null should handle collection as well - Concat
So indeed this is one possible solution on query level.
We can suggest you to move this filtering on report level, where the expression will look as follows:
"=IIf( Parameters.ContactID.Value is Null,1, Fields.ContactID)"
"=IIf( Parameters.ContactID.Value is Null,1, Parameters.ContactID.Value)"
The expression is created with the help of the the built-in reporting functions
Let us know if you have any further concerns.
the Telerik team
Telerik Reporting Q1 2013 available for download with impressive new visualizations. Download today from your account.