question

rcportillo avatar image
rcportillo asked

SSRS question issues on Year Date parameter trying to select mulitple years in report

Here is the code that I using.

AND (@Parm_Year = DATEPART(YYYY, field))

Using this allows me to pick one year at a time only not multiple years.

Any suggustions.

parameters
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Jon Crawford avatar image
Jon Crawford answered

set the parameter to allow multiple results, use AND DATEPART(YYYY,field) IN (@Parm_Year)

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.