Is it possible for one report to have different default parameters, based on the user viewing the report, when the report is accessed via the Report Viewer
Thanks.
Report Viewer/Default Parameters
Hot Topic
- MS Access + SQL2005
- Problem with Sleep function in SSIS
- Error while importing Text file using Import Export Wizard
- RSKeyMgmt.exe utility sql rs 2000
- ReportViewer.RefreshReport hangs but only when form is run from ImmediateWindow
- How to change a Full Path property in RS 2005 for a .rdl report?
- Input column collection in script component?
- Sql Server Merge Replication vs. Sql Server Transactional with updatable subscribtion
- Unpublishing an article
- How to Secure transport of file to FTP Server from SSIS...options??
SQL Server
- Importing from Crystal Report 7 to Reporting Services
- SQL 2005 Express and Sharepoint Services 2.0 SP2
- Running a package in C#
- Customer Count
- how to install vs ctp June with SQL Server Express
- Snippets and Datasets
- How to get a handle of my queries
- Examples of Certificates created with Private Key and FROM EXECUTABLE FILE options
- Time Dimension error
- Reusing a Chached Lookup component
Report Viewer/Default Parameters
DaaDa Ng
If you are using the ReportViewer control in ASP.NET, you can set the value of the parameter programatically based on the current user identity:
this.ReportViewer1.ServerReport.ReportPath = "/SampleReports/Employee Sales Summary";
ReportParameter p = new ReportParameter("EmpID", "20");
this.ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { p });
Richard Curley
Assuming you are asking for viewing report through report server: default values can be (1) constant, (2) expression-based, or (3) dataset based.
Regarding (2): you could determine the default value based on the current userid, e.g =iif(User!UserId="abc", "Default1", "Default2")
Regarding (3): you could use the current user information in the query commandtext or as parameter into a stored procedure to dynamically determine the default value.
-- Robert