Hi,

Refer this for the answer.

__________________
-Murali..

Hi, I have given the answer in this forum itself

In a Reporting Services, parameters are used to specify the data to use in a report, connect related reports together, and vary report presentation. There are two types of parameters in a report: query parameters and report parameters.
• When you define a dataset query that includes variables, Reporting Services creates corresponding query parameters. Query parameters are used to limit data retrieved from the data source to just the data needed for the report.
• Report parameters appear on the report toolbar and allow report readers to select or enter values that are used when a report is processed. In Report Designer, report parameters are created automatically from query parameters. In Report Builder, report parameters are created when you set a prompt on a filter clause. You can also define report parameters that are not tied to query parameters. In expressions, you can include references to report parameters using the global Parameters collection. Because expressions can be used throughout a report definition to control content or appearance, report parameters provide a powerful way to customize a report.