Friday, January 18, 2013 6:39 AM
I have heard and worked on Report Parameters and Query parameters.
According to my observation i din't found any difference..
What is the difference between query and Report parameters??
Are there any different types of parameters in ssrs?
Please help me..
Thanks in advance...
Friday, January 18, 2013 7:06 AM
The main purpose of a report parameter is to add interactivity to your reports, letting users change the report behavior based on options they select
and the main purpose of a query parameter is to filter data in the data source.
Just a little bit more about query parameters versus report parameters. RS does automatically create a report parameter when you put in a query parameter. However, you do not have to use it. You can set the query parameter to a different report parameter,you can set it to an expression (which means that if you want you can first have some custom code massage the report parameter first). A very common scenario where there is not a one to one relationship between report and
query parameters is when you have several datasets in a report. Let's say I have several datasets that all use a fromdate and todate. I sure don't want the user to have to put in the same date multiple times. So, I delete the extra report parameters and have all the datasets query parameters point to the same set of report parameters.
Regards Avanish T
Saturday, January 19, 2013 9:52 AM
Thank you Avanish..
Could you please explain in detail
Thursday, January 24, 2013 2:17 AMModerator
The difference between query parameter and report parameter is when to filter report data: before or after report data retrieved from data source.
Query parameters are processed on the data source server and used to limit data retrieved from the data source. When we define dataset query that includes variables, Reporting Services creates corresponding query parameters.
Report parameters are processed by the report server and filter the report data after all data are retrieved from the data source. For example, we can create a parameter on report toolbar and specify the report parameters in filter expression.
For more information, please see: Working with Parameters in Reporting Services
TechNet Community Support