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))
go
insert into dbo.rpt_MonthName values
('January'),('February'),('March'),('April'),
('May'),('June'),('July'),('August'),
('September'),('October'),('November'),
('December')

Select * from dbo.rpt_MonthName



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



15 comments:

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

    ReplyDelete
  2. 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

    ReplyDelete
  3. Nice to be visiting your blog once more, it has been months for me. Well this article that ive been waited for therefore long. i want this article to finish my assignment within the faculty, and it has same topic together with your article. Thanks, nice share. csgo high tier accounts

    ReplyDelete
  4. An interesting dialogue is price comment. I feel that it is best to write more on this matter, it may not be a taboo topic however usually individuals are not enough to talk on such topics. To the next. Cheers. Valorant Smurf Accounts

    ReplyDelete
  5. Online video games provide good exercise for a child's brain. A huge number of them require abstract and high-level thinking skills to win. pubg mobile accounts

    ReplyDelete
  6. How to deal with job interview if it takes longer than usual?
    I am asking based on my previous experience it went pretty well. But I got frustrated.

    ReplyDelete
  7. The present day, frameless design of this AOC monitor will increase the display area and grants a smooth, appealing appearance.
    Here is the source: monitorsunderbudget

    ReplyDelete
  8. Every person must own a laptop because in todays age every work is shifting from office to remote based. Few suggestion regarding best 17 inch laptops under 1000 are here.
    These are recommendations from top experts.

    ReplyDelete
  9. How you guys can track products by sitting at home using your smart phone, the most accurate results are off LBC Trackers as they defined tracking system.

    ReplyDelete
  10. Shades can protect them from direct sunlight until they grows up enough.

    ReplyDelete
  11. How you guys can track products by sitting at home using your smart phone, the most accurate results are off smart freight LBC Trackers as they defined tracking system.

    ReplyDelete
  12. How you guys can track products by sitting at home using your smart phone, the most accurate results are off Ninja Van TrackersNinja Van Trackers as they defined tracking system.

    ReplyDelete
  13. EssayPro provides round-the-clock support to its customers through its stellar customer service team. The team is available 24/7 to address any queries or concerns related to essay writing services https://essaypro.com/case-study-writing-service. With EssayPro's A-class service, customers never have to worry about being left hanging.

    ReplyDelete
  14. This comment has been removed by the author.

    ReplyDelete
  15. IESCO, short for Islamabad Electric Supply Company, is a prominent electricity distribution company in Pakistan. It serves the capital city, Islamabad, and its adjoining areas, playing a crucial role in ensuring the provision of reliable and efficient electricity to residents and businesses. IESCO is committed to delivering high-quality services, maintaining electrical infrastructure, and implementing innovative solutions to meet the growing energy demands of the region. As a key player in the power sector, IESCO plays a vital role in supporting economic development and improving the overall quality of life for the communities it serves.




    ReplyDelete