|
|
You're in the
sql server reporting services
group:How do I set a set a report parameter value using the webform RVC?
sql server reporting services:
SSRS 2005
We have an ASP.NET application which permits the user to switch between different databases depending on their permissions. As soon as the user chooses a new database, the application shows data from the new database. I am using the Report Viewer Control to allow the users to run remote reports. I need the reports to also switch to accessing the new database once it is selected. I know how I can use a hidden report parameter and a database connection expression to switch the reports to different databases. But, how do I set the report accessed by the RVC to use the new database connection parameter value after the user has switched to a new database? Can I use something like: RVC.ServerReport.ReportServerUrl = ... RVC.ServerReport.ReportPath = reportPath = ... and then use RVC.ServerReport.SetParameters() RVC.ServerReport.Refresh() to set the hidden parameter which will specify the database to connect to? --
Hello Chris,
Yes, you're right, you can use the ReportViewer Control's "ServerReport" property to dynamically customize the report server url and report server path if you want to display different report according to different user inputs or other conditions. And the ServerReport.SetParameters method can help programmtically specify parameter values for the report. Be careful tha the SetParameters methdo accept collection which contains "ReportParameter" class instances. And this class can only contains string value based "name/value" paramter pair. So if you have any complex object parameter(such as Datetime), you need to convert it to string first. For example: ========================== protected void Page_Load(object sender, EventArgs e) { string reportpath = Request.QueryString["rptpath"]; if (!string.IsNullOrEmpty(reportpath)) { ReportViewer1.ServerReport.ReportPath = reportpath; ReportParameter[] pms = new ReportParameter[1]; DateTime date = DateTime.Parse("2005-3-10"); pms[0] = new ReportParameter("Raw_Date_Param", date.ToShortDateString() ); ReportViewer1.ServerReport.SetParameters(pms); ReportViewer1.ServerReport.Refresh(); } } ============================ Hope this helps. Sincerely, Steven Cheng Microsoft MSDN Online Support Lead ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Steven,
When SetParameters() is used, do values have to be provided for all parameters? Or is it possible to just populate certain parameters? -- Chris, SSSI [quoted text, click to view] "Steven Cheng[MSFT]" wrote:
> Hello Chris, > > Yes, you're right, you can use the ReportViewer Control's "ServerReport" > property to dynamically customize the report server url and report server > path if you want to display different report according to different user > inputs or other conditions. > > And the ServerReport.SetParameters method can help programmtically specify > parameter values for the report. Be careful tha the SetParameters methdo > accept collection which contains "ReportParameter" class instances. And > this class can only contains string value based "name/value" paramter pair. > So if you have any complex object parameter(such as Datetime), you need to > convert it to string first. For example: > > ========================== > protected void Page_Load(object sender, EventArgs e) > { > string reportpath = Request.QueryString["rptpath"]; > > if (!string.IsNullOrEmpty(reportpath)) > { > > > ReportViewer1.ServerReport.ReportPath = reportpath; > > ReportParameter[] pms = new ReportParameter[1]; > > DateTime date = DateTime.Parse("2005-3-10"); > pms[0] = new ReportParameter("Raw_Date_Param", > date.ToShortDateString() ); > > > ReportViewer1.ServerReport.SetParameters(pms); > > ReportViewer1.ServerReport.Refresh(); > } > } > ============================ > > Hope this helps. > > Sincerely, > > Steven Cheng > > Microsoft MSDN Online Support Lead > > > > ================================================== > > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > > > > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues > where an initial response from the community or a Microsoft Support > Engineer within 1 business day is acceptable. Please note that each follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach the > most efficient resolution. The offering is not appropriate for situations > that require urgent, real-time or phone-based interactions or complex > project analysis and dump analysis issues. Issues of this nature are best > handled working with a dedicated Microsoft Support Engineer by contacting > Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/subscriptions/support/default.aspx. > > ================================================== > > > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > >
Hi Chris,
As for the "SetParameters" method of ServerReport class, it accept a collection (normally a Array) of ReportParameter class instances. Also, the ReportParameter class contains a name/value string pair, so you do not need to provide values for every parameter of a certain server report. You can just create ReportParameter instances for the certain named parameters you want to supply. And the server report will use a empty value or default value for those non-supplied parameters. Sincerely, Steven Cheng Microsoft MSDN Online Support Lead This posting is provided "AS IS" with no warranties, and confers no rights.
Hello Chris,
How are you doing on this issue. Does Steven's reply and suggestion helps you some? If there is still anything we can help, please feel free to post in the newsgroup. Thank you for using our MSDN Managed Newsgroup Support Service! Sincerely, Luke Zhang Microsoft Online Community Support This posting is provided "AS IS" with no warranties, and confers no rights.
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |