Last post Jul 01, 2011 03:39 PM by RptGen
Sep 01, 2010 12:26 AM|Jimbobjr|LINK
I have a situation where I am created a WEB APP that has a submit button on a FORM on the first ASPX page. I have some VB code behind that to generate Header and Lines records in two tables with a HEADER ID as my PK.
I have another ASPX page which has the Report Viewer control on it and prompts me for the HEADER ID and displays the report correctly when I manually enter the HEADER ID.
What I am now trying to achieve is when the user clicks the submit button on the FORM I want it to redirect to the other ASPX page and pass through the Header ID as a Parameter and automatically display the REPORT.
Can somebody please point me in the right direction to achieve this.
Sep 01, 2010 02:08 AMfirstname.lastname@example.org|LINK
It seems like your report need parameter to open. You can pass the parameter like
Sep 01, 2010 02:16 AM|Jimbobjr|LINK
Thanks for that.
That would be perfect, the question is how do I do that. Surely I have to link the URL parameter to the report with VB code or JS code somehow?
Sep 07, 2010 08:06 AM|You-Hu Fu|LINK
From your information, I think Drill-through function is just what you need. A drillthrough report typically contains parameters that are passed to it by the parent report. In the sales summary report example, the drillthrough report contains a parameter
that takes the order as a value. The summary report includes a drillthrough report link for each order number, which opens the target detail report when clicked and passes the order ID to it.
To add a drillthrough report
To supply data for drillthrough reports, your application must handle the Drillthrough event of the
ReportViewer object. One of the arguments passed to the Drillthrough event hander method is
DrillthroughEventArgs. DrillThroughEventArgs has a Report property which represents the drillthrough report. In the event handler, the host application may examine the values of parameters passed to the drill-through report by calling the
GetParameters() method on the drillthrough report. The host application must then supply the data for the drillthrough report using the
DataSources property of the drillthrough report.
For the code sample, please click this link
If you have any question, please feel free to ask.
Jul 01, 2011 03:39 PM|RptGen|LINK
You might take at look at: