Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Call webforms from data within a reporting services report Expand / Collapse
Posted Wednesday, October 2, 2013 2:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 18, 2013 1:39 PM
Points: 4, Visits: 91
This is my first post here so good day to all.

Let me give you a background on the item I need help with.

Where I am as we speak (as simplified an explanation as I can give):

Webform1 has a textbox1 and button1 control on it.
Upon clicking button1 it that captures the textbox1 data and passes the captured value to Webform2
Upon loading Webform2 the parameter is passed to the reportviewer control where the report displays queried result.

All of the above is already in place.

What I want to know:
Is it possible to have the SSRS report contain links within the results of the report that can be passed back to a Webform so that it can be used to populate textbox controls on a third webpage? Sort of like a drillthrough but not.

Webform with Reportviewer control that has a SSRS report result which returns and ID column.
Each piece of data in the ID column has a link that passes the piece of data as a parameter to Webform3.
Webform3 takes the parameter and passes it to a SQL stored proc which returns the data to load textbox controls on Webform3.

Can this be done?

Clear as mud?

Any and all help is much appreciated!!!
Post #1500922
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse