June 20, 2011 at 2:34 pm
My report has start date, end date, account number and name as 4 parameter
User might enter start date and end date or account number alone or name alone how do i do this in report.
Please suggest
June 24, 2011 at 3:44 am
You can try with "Allow Null Values" in report parameters.
June 30, 2011 at 5:46 am
I assume that you need help formulating the WHERE clause of your query to allow for NULL conditions?
There are several ways to accomplish this, the best being to write your query as a stored procedure, either containing variable sections, or using dynamic SQL.
There are also ways to build dynamic queries in Reporting Services, but I don't have much experience with this.
Alternatively, you might try something along the line of the following syntax:
WHERE Account_Number = (CASE WHEN @AccountNumber IS NULL
THEN Account_Number
ELSE @AccountNumber END)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply