Is there a way to provide default values to your parameter in SSRS Report - SSRS Interview Questions

Published: 30 December 2015
on channel: TechBrothersIT
8,179
22

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

Check out our website for Different Technology tutorials and interview questions
http://www.techbrothersit.com/


Watch video Is there a way to provide default values to your parameter in SSRS Report - SSRS Interview Questions online without registration, duration hours minute second in high quality. This video was added by user TechBrothersIT 30 December 2015, don't forget to share it with your friends and acquaintances, it has been viewed on our site 8,179 once and liked it 22 people.