SSRS Interview Questions - Is there a way to provide default value/s to your parameter in SSRS Report?

Parameters are used to filter data in report. Default value/s can be configured for Parameter/s in SSRS report. By configuring default values in report, the report will run with those parameter values. The viewer/user can choose different values for parameter/s after first execution of report.

To set the default value/s for parameter
Right click on Parameter and choose Parameter Properties
Then click on Default Values Tab
For static Values : You can click on Specify Values radio button and then Add the values as you like ( I would not like to use this, as to add/delete any value , we always have to open report for change and redeploy after saving changes)
The Default Values can also be get from Query. You can use Get Values from query ( I prefer this option, as we can add/remove values in table anytime and we don't have to open report to make change and redeploy.)

Can we provide Default Values to Parameter or Parameters in SSRS Report - SQL Server Reporting Services(SSRS) Interview Question sand Answers


2 comments:

  1. I really enjoy reading of your article. I wanted to inform you that you have people like me who appreciate your work. sms bomber apk editor no wifi games

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

    ReplyDelete