empty parameter in reporting

lawrence whittemore asked on February 28, 2022 20:22

I'm probably just being blind and missing something, but how would create a parameter that if left empty is just ignored for a report.

Recent Answers

Juraj Ondrus answered on March 1, 2022 08:53

I would use standard SQL syntax. So, it could be like:

IF ( @MyParameter IS NOT NULL) BEGIN...ELSE....

There are manmy other discussion threads on this topic available on Stackoverflow

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.