SSRS

• How do I dynamically populate a dropdown list for users to filter a report in SSRS?

  Oct 23, 2018

  I was helping someone who had an interesting data set. Their tables were coming from a vendor and they had to report off of those tables. The problem was that the tables were all named and logically split by MMYYYY. This meant that if they wanted to query data between a date range, they would need to maintain views daily or get creative in SSRS.

  Now this option can be used for many things, you just need to tweak the parameters a little. I’m showing you conceptually how to use the template to execute a dynamic SQL Script that populate a data set from a user selecting drop downs in a report. The parameters are tables that are named to match the date range of data contained within them in this example.

• Parameter validation failed in SSRS

  May 7, 2018

  Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError)

  I saw this error the other day and it took me a minute to recall how I’ve fixed this in the past.

  If you are unfamiliar with SSRS and Visual Studios, it can be a little “unfriendly” with some features. Specifically in this case, taking a parameter that used to be hidden and making it a visual integral part of the report. In my particular circumstance, this report is not testable in visual studio and has to be uploaded to a server in order to validate.