What are the rules for using "Internal" parameters in SSRS

sql-server reporting-services ssrs-2008 ssrs-2008-r2
whytheq picture whytheq · Mar 23, 2012 · Viewed 24.1k times · Source

There is an option to create "Internal" parameters in SSRS:

  1. In what context are they used?
  2. What are the general rules for using internal parameters?

Answer

Michael Fredrickson picture Michael Fredrickson · Mar 23, 2012

Internal Parameters in SSRS are parameters that are not configurable by the end-user at run-time.

This varies from a Hidden Parameter, which the user is not prompted to provide, but can still be configured through the URL to the report server.

Please see "Creating Report Parameters" on MSDN for more information.

One possible usage of them is in conjunction with the Report Viewer control. An ASP.Net page can contain the report viewer control, and use internal parameters in the code-behind to provide values to the report that the end-user should not be able to control, such as a UserID.

This can prevent the user from providing a different user's ID in order to see data that they shouldn't be allowed to view.

However, if you use an internal parameter in a report but want it to remain functional outside of the report viewer control, you'll want to specify an appropriate default value. Otherwise the report will be unusable from the Report Manager or Report Server.

Related questions

Pass field from one dataset to another dataset as parameter In SSRS 2008 R2

I have a scenario where one of my data-set returns multiple records. Now I have implemented grouping in my report so as to display each record from this data set on a different page. Now I have an another dataset …

Read More
SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More
SSRS the definition of the report is invalid

How can I resolve the below error message that I receive when I try to deploy my report to our our Reporting Server using BIDS? Message: Error : The definition of the report '/OrderAnalysis' is invalid. Report Element: <Report …

Read More