June 26, 2012 at 11:00 pm
Guys,I'd like to know ,
What is the difference between query parameter and report parameter(please list out all you know)
June 27, 2012 at 3:48 am
A query parameter is a parameter used in your dataset. This automatically results in the creation of a report parameter. When you run the report, you need to specify values for the report parameter, which in his turn will populate the query parameter.
However, a report parameter doesn't have to be associated with a query parameter. It can for example be populated by system variables.
edit: my original answer talked about filters, not about parameters. I mixed those up.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 28, 2012 at 4:31 pm
There can also be a distinction between where the filtering takes place.
A query parameter is going to filter the dataset before it is returned to the report (in other words at the server) so it is generally considered faster.
A report parameter that is not tied to a query parameter will filter after the result set is returned. Basically, you are making the report do the work instead of the server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply