Is there a way to provide default values to your parameter in SSRS Report - SSRS Interview Questions
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/
Смотрите видео Is there a way to provide default values to your parameter in SSRS Report - SSRS Interview Questions онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь TechBrothersIT 30 Декабрь 2015, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 8,179 раз и оно понравилось 22 людям.