how do I link Form Web Part to a Page Viewer web part SharePoint 2007

hello, new to Sharepoint. I have a number of Reporting Services reports on a sharepoint page using Page Viewer web parts, here is an example of my URL on a web page:

http://trs-avante.nat.bt.com/ReportServer?/ProductionForecast/Forecast_Detail+Over+200K&selperc=30&rc:NoHeader=true&rc:Toolbar=false

what I want to do it not hardcode the report parameter 'selperc' to 30, I have a Form Web Part with a text box (textbox1) and would like to use the value from that as the parameter for the reports. Not worries how the user enters the value, if its easier to have a custom ASP page with textbox on could do that. Thanks.
Graham_ForbesAsked:
Who is Participating?
 
zephyr_hex (Megan)Connect With a Mentor DeveloperCommented:
yes, you will need some mechanism to build the url.  i think i've done something along the lines of what you're looking for...  it involves adding a hyperlink to a field, and then passing the field as a variable to the hyperlink.
see here
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_24780905.html#25498908

your situation is a little different, but i think you can use the principle...

you'd configure your Form Field to be a hyperlink, and the value of that field gets passed in as a variable to the url.
0
 
zephyr_hex (Megan)DeveloperCommented:
just wanted to point out that if you put your SSRS in sharepoint integration mode, there is a Report Viewer web part you can use...

0
 
Graham_ForbesAuthor Commented:
Do I need to change anything on the sharepoint server?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
zephyr_hex (Megan)DeveloperCommented:
you configure the integration in SSRS.  then yes, you have a few config steps to do in sharepoint central admin, and install the report viewer web part.

here is an overview with screenshots just to give you an idea of what it offers:
http://blogs.msdn.com/b/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx

but i've found these install steps to be more detailed than the article above (for installation purposes):
http://mosshowto.blogspot.com/2009/03/reporting-services-sharepoint-multiple.html

i'm not sure if you're using SQL 2005 or 2008.... but the steps are pretty much the same for putting SSRS in integration mode.  if it's SQL 2005, you'll need at least SP2.


please note that if you have any reports in SSRS "native mode", you'll lose access to them... so you'll either want to export them, or configure the SSRS integration in a new SQL instance.
0
 
Graham_ForbesAuthor Commented:
i can configure reporting services, but the sharepoint is a corporate wide instance and i cannot make any changes to its configuration.
0
 
zephyr_hex (Megan)DeveloperCommented:
if you dont have access to sharepoint central admin, putting SSRS in integration mode won't do you any good.  you need to be able to config sharepoint, and install the reporting center web part.
0
 
Graham_ForbesAuthor Commented:
I cannot make any changes to the sharepoint, therefore I think the only way to acheieve what I want is to have the part of the string in the URL coming from another web part, something like:

http://trs-avante.nat.bt.com/ReportServer?/ProductionForecast/Forecast_Detail+Over+200K&selperc=<webpartform1.Textbox1.text>&rc:NoHeader=true&rc:Toolbar=false

or maybe build the url up into another string and make that the link?
0
 
GreatGermCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
All Courses

From novice to tech pro — start learning today.