SSRS Interview Question - You have created a report, the report has month name as parameter, What is best way to provide values for month name parameter?

As we have fixed set of month names and they don't change. we can add the month names as static values in report for Month Name Parameter.

If the values of parameter does change often, it is good idea to insert them in a table and use Query to extract them for Parameter in report. By doing that we don't have to make changes in report every time if we have to add or remove value. We can simply insert or delete value/s in table those will be extracted by query.

You can use below script to create table for month Names.

Create Table dbo.rpt_MonthName ( MonthName VARCHAR(50))
insert into dbo.rpt_MonthName values

Select * from dbo.rpt_MonthName

Add Month Name Parameter Values in SSRS Report - SQL Server Reporting Services(SSRS) Interview Questions and Answers


  1. Thanks. Is it possible user can enter values of prompts or can select the values from drop down in single prompt?

  2. cheap mcqueen shoes, combining elegant style and cutting-edge technology, a variety of styles of cheap mcqueen tread slick boots, the pointer walks between your exclusive taste style.

  3. Thank you very much for this great post. Question Query

  4. Fantastic blog! Do you have any tips and hints for aspiring writers? I’m planning to start my own website soon but I’m a little lost on everything. Would you propose starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m completely overwhelmed .. Any suggestions? Many thanks! Question Answer