Using MS Reporting Services, I am developing a report that contains several parameters. I want to give the users an option to leave a parameter blank and have the query run without filtering that field. I have tried the following logic, but it does not function correctly:
Where ProgNum = Case
When @ProgNum = '' Then ProgNum
When @ProgNum <> '' Then @ProgNum
End
Any Suggestions?
Thanks.....Franco
Where ProgNum = Case
When @ProgNum = '' Then ProgNum
When @ProgNum <> '' Then @ProgNum
End
Any Suggestions?
Thanks.....Franco