Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
305 views
in Technique[技术] by (71.8m points)

sql server - What are the rules for using "Internal" parameters in SSRS

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?
See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

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.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...