Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Passing Parameters Between ReportViewers Controls

Author  Topic 

Primaryracer
Starting Member

2 Posts

Posted - 2009-07-28 : 04:09:44
I'm having difficulty in Passing parameters in-between two ReportViewer Control on separate web pages. In simple words, I've created two Reports in Visual Studio (1. Sales Top Level Summary, 2 Sales by Month) where Sales Top level summary report is a RS Matrix Report which show's sales total in each month and by clicking on each financial month manager's can view the sales details in each month. Now this work perfectly fine when I preview these reports in Visual Studio and then deploy and view in Report Manager

In second part I've integrated Sales Top level summary report into Asp.net page using Top-Level ReportViewer control and set the ShowToolBar Property to "False" so i can my own CSS setting, this even works fine here and i can view the sales summary in each month using this page, because I set Navigation as Jump to report and then passing FinYear and FinMonth as parameters to Sales By Month Report.
Here is the snapshop of my sales top level reports


Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
2008/09 64 59 58 73 70 55 80 79 72 61 74 64
2009/10 69 65 59


Now my problem is since i have ShowToolBar Property to "False" the ShowExportControl Property is not visible on the Sales by Month report as I'm using the same ReportViewer control to view this report. To Solve this I've created another Asp.net page with Another ReportViewer control which is linked to the Monthly sales report, but I'm not sure how to pass the FinYear and FinMonth parameters to other ReportViewer control on 2nd Asp page, I did tried Jump to URL "http://localhost/BI/Sales_Monthly_Report.aspx" but that didn’t work either..

Any help in this regard will be highly appreciated...
   

- Advertisement -