Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help with URL Jump To Report Expand / Collapse
Author
Message
Posted Wednesday, March 6, 2013 11:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:27 AM
Points: 311, Visits: 538
I can not seem to get the URL right for my Jump to Report.

Server = server_name
Folder Path from home = "Safety Stock Review"
Report = "Stock History"
Report Parameters: mrparea, mat
Data: Fields!MRP_Area_CD.Value, Fields!Material_CD.Value

The report will come up but the report parameters are getting loaded into the drill down report.

What I get in IE's path box: http://server_name/Reports/Pages/Report.aspx?ItemPath=/Safety+Stock+Review/Stock+History&rs:Command=Render&mrparea=AN01&mat68786

The code:
="void(window.open('http://server_name/Reports/Pages/Report.aspx?ItemPath=%2fSafety+Stock+Review%2fStock+History&rs:Command=Render&mrparea="+Fields!MRP_Area_CD.Value+"&mat"+Fields!Material_CD.Value
+"','mywindow', 'resizable=yes, scrollbars=yes, toolbar=no, location=yes, directories=no, status=no, menubar=no, titlebar=no, width=900, height=800, top=50, left=900'))"
Post #1427537
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse