|
|
You're in the
sql server reporting services
group:value of Globals!ReportServerUrl
sql server reporting services:
I am running RS2005
I have a report that contains a link to another report using Jump to URL. To avoid hard coding, I am using the Globals!ReportServerUrl variable to build up the path to the linked report. When I run the first report from Report Manager, it displays as expected and the URL is something like http://bhhrstest/Reports/Pages/Report.aspx?ItemPath=%2fFolder1%2fFolder2%2fReport1 When I click on the link, the new report displays fine but no longer contained within the Report Manager framework. The URL is something like http://bhhrstest/ReportServer/Pages/ReportViewer.aspx?/Folder1/Folder2/Report2¶m1=xxx¶m2=yyy&rs:Command=Render How is the value of Globals!ReportServerUrl determined ? Thanks Steve
RS ships with a portal (Report Manager). Report Manager itself under the
covers is calling ReportServer which is the asp.net application which is truly Reporting Services. Many people don't even use Report Manager. They have their own front ends. One thing you will find if you hard code the URL to use Reports that it works only if you are not trying to past parameters. No parameters are filled in. If you are wanting to use any of the commands on the URL it has to go to ReportServer. Also, just a note, the default is to render, you can leave it off. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "SteveH" <SteveH@discussions.microsoft.com> wrote in message news:4808DFF9-62D7-435B-B530-912B940BE0CB@microsoft.com... >I am running RS2005 > > I have a report that contains a link to another report using Jump to URL. > > To avoid hard coding, I am using the Globals!ReportServerUrl variable to > build up the path to the linked report. > > When I run the first report from Report Manager, it displays as expected > and > the URL is something like > > http://bhhrstest/Reports/Pages/Report.aspx?ItemPath=%2fFolder1%2fFolder2%2fReport1 > > When I click on the link, the new report displays fine but no longer > contained within the Report Manager framework. The URL is something like > > http://bhhrstest/ReportServer/Pages/ReportViewer.aspx?/Folder1/Folder2/Report2¶m1=xxx¶m2=yyy&rs:Command=Render > > How is the value of Globals!ReportServerUrl determined ? > > Thanks > Steve > >
Thanks for your reply Bruce
Sorry, but I think I may have outsmarted myself and asked the wrong question. Here's the full story (names changed to protect the innocent). I have just migrated from RS2000 to a test RS2005 environment. I have 2 reports, ReportA which contains a hyperlink to ReportB and passes parameters using Jump To Url with the action defined something like this: =Globals!ReportServerUrl & "?/FolderA/FolderB/Report2&p_fy=2007&p_fp=1&p_hospital=BHH&rs:Command=Render&rc:Zoom=100" In RS2000 ReportManager, if I called up ReportA and clicked on the hyperlink, it would display ReportB inside the ReportManager framework. Here are the 2 urls http://ehrsdev01/Reports/Pages/Report.aspx?ItemPath=%2fFolderA%2fFolderB%2fReport1 http://ehrsdev01/Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2fehrsdev01%2fReportServer%3f%2fFolderA%2fFolderB%2fReport2%26p_fy%3d2007%26p_fp%3d1%26p_hospital%3dBHH%26rs%3aCommand%3dRender%26rc%3aZoom%3d100%26rc%253aReplacementRoot%3dhttp%253a%252f%252fehrsdev01%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d In RS2005 ReportManager, if I called up ReportA and clicked on the hyperlink, it would display ReportB but not inside the ReportManager framework. Here are the 2 urls http://bhhrstest/Reports/Pages/Report.aspx?ItemPath=%2fFolderA%2fFolderB%2fReport1 http://bhhrstest/ReportServer/Pages/ReportViewer.aspx?/FolderA/FolderB/Report2&p_fy=2007&p_fp=1&p_hospital=BHH&rs:Command=Render&rc:Zoom=100 I have developed a fairly basic ASP page that displays the reports in an iframe which behaves the same way as the ReportManagers depending on which environment I point to. I initially thought there was a problem with my ASP code that set up the ReplacementRoot, but I am getting the same problem with ReportManager so I have discounted that. Looking at the source of the display of ReportA in the 2 environments, I notice that the ReplacementRoot method is not present in the RS2005 version. RS2000 <a style="text-decoration:none;color:Blue" href="http://ehrsdev01/Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2fehrsdev01%2fReportServer%3f%2fFolderA%2fFolderB%2fReport2%26p_fy%3d2007%26p_fp%3d1%26p_hospital%3dBHH%26rs%3aCommand%3dRender%26rc%3aZoom%3d100%26rc%253aReplacementRoot%3dhttp%253a%252f%252fehrsdev01%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d" TARGET="_top">348</a> R2005 <a href="http://bhhrstest/ReportServer?/FolderA/FolderB/Report2&p_fy=2007&p_fp=1&p_hospital=BHH&rs:Command=Render&rc:Zoom=100" style="text-decoration:none;color:Blue" TARGET="_top">348</a> Is this a configuration issue, or has RS2005 done away with the ReplacementRoot methodology ? Regards Steve [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> RS ships with a portal (Report Manager). Report Manager itself under the > covers is calling ReportServer which is the asp.net application which is > truly Reporting Services. Many people don't even use Report Manager. They > have their own front ends. One thing you will find if you hard code the URL > to use Reports that it works only if you are not trying to past parameters. > No parameters are filled in. If you are wanting to use any of the commands > on the URL it has to go to ReportServer. Also, just a note, the default is > to render, you can leave it off. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > "SteveH" <SteveH@discussions.microsoft.com> wrote in message > news:4808DFF9-62D7-435B-B530-912B940BE0CB@microsoft.com... > >I am running RS2005 > > > > I have a report that contains a link to another report using Jump to URL. > > > > To avoid hard coding, I am using the Globals!ReportServerUrl variable to > > build up the path to the linked report. > > > > When I run the first report from Report Manager, it displays as expected > > and > > the URL is something like > > > > http://bhhrstest/Reports/Pages/Report.aspx?ItemPath=%2fFolder1%2fFolder2%2fReport1 > > > > When I click on the link, the new report displays fine but no longer > > contained within the Report Manager framework. The URL is something like > > > > http://bhhrstest/ReportServer/Pages/ReportViewer.aspx?/Folder1/Folder2/Report2¶m1=xxx¶m2=yyy&rs:Command=Render > > > > How is the value of Globals!ReportServerUrl determined ? > > > > Thanks > > Steve > > > > > >
I'm not sure with regards to your question. I do know that Report Manager
with RS 2005 has gone to using web services to communicate with ReportServer app. It would not surprise me if this resulted in some changes with behavior. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "SteveH" <SteveH@discussions.microsoft.com> wrote in message news:634161E8-C3D2-425F-9299-58BC5FF536FC@microsoft.com... > Thanks for your reply Bruce > > Sorry, but I think I may have outsmarted myself and asked the wrong > question. Here's the full story (names changed to protect the innocent). > > I have just migrated from RS2000 to a test RS2005 environment. > > I have 2 reports, ReportA which contains a hyperlink to ReportB and passes > parameters using Jump To Url with the action defined something like this: > > =Globals!ReportServerUrl & > "?/FolderA/FolderB/Report2&p_fy=2007&p_fp=1&p_hospital=BHH&rs:Command=Render&rc:Zoom=100" > > In RS2000 ReportManager, if I called up ReportA and clicked on the > hyperlink, it would display ReportB inside the ReportManager framework. > > Here are the 2 urls > http://ehrsdev01/Reports/Pages/Report.aspx?ItemPath=%2fFolderA%2fFolderB%2fReport1 > > http://ehrsdev01/Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2fehrsdev01%2fReportServer%3f%2fFolderA%2fFolderB%2fReport2%26p_fy%3d2007%26p_fp%3d1%26p_hospital%3dBHH%26rs%3aCommand%3dRender%26rc%3aZoom%3d100%26rc%253aReplacementRoot%3dhttp%253a%252f%252fehrsdev01%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d > > In RS2005 ReportManager, if I called up ReportA and clicked on the > hyperlink, it would display ReportB but not inside the ReportManager > framework. > > Here are the 2 urls > > http://bhhrstest/Reports/Pages/Report.aspx?ItemPath=%2fFolderA%2fFolderB%2fReport1 > > http://bhhrstest/ReportServer/Pages/ReportViewer.aspx?/FolderA/FolderB/Report2&p_fy=2007&p_fp=1&p_hospital=BHH&rs:Command=Render&rc:Zoom=100 > > > I have developed a fairly basic ASP page that displays the reports in an > iframe which behaves the same way as the ReportManagers depending on which > environment I point to. I initially thought there was a problem with my > ASP > code that set up the ReplacementRoot, but I am getting the same problem > with > ReportManager so I have discounted that. > > Looking at the source of the display of ReportA in the 2 environments, I > notice that the ReplacementRoot method is not present in the RS2005 > version. > > RS2000 > > <a style="text-decoration:none;color:Blue" > href="http://ehrsdev01/Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2fehrsdev01%2fReportServer%3f%2fFolderA%2fFolderB%2fReport2%26p_fy%3d2007%26p_fp%3d1%26p_hospital%3dBHH%26rs%3aCommand%3dRender%26rc%3aZoom%3d100%26rc%253aReplacementRoot%3dhttp%253a%252f%252fehrsdev01%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d" > TARGET="_top">348</a> > > R2005 > > <a > href="http://bhhrstest/ReportServer?/FolderA/FolderB/Report2&p_fy=2007&p_fp=1&p_hospital=BHH&rs:Command=Render&rc:Zoom=100" > style="text-decoration:none;color:Blue" TARGET="_top">348</a> > > Is this a configuration issue, or has RS2005 done away with the > ReplacementRoot methodology ? > > Regards > Steve > > "Bruce L-C [MVP]" wrote: > >> RS ships with a portal (Report Manager). Report Manager itself under the >> covers is calling ReportServer which is the asp.net application which is >> truly Reporting Services. Many people don't even use Report Manager. They >> have their own front ends. One thing you will find if you hard code the >> URL >> to use Reports that it works only if you are not trying to past >> parameters. >> No parameters are filled in. If you are wanting to use any of the >> commands >> on the URL it has to go to ReportServer. Also, just a note, the default >> is >> to render, you can leave it off. >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> >> "SteveH" <SteveH@discussions.microsoft.com> wrote in message >> news:4808DFF9-62D7-435B-B530-912B940BE0CB@microsoft.com... >> >I am running RS2005 >> > >> > I have a report that contains a link to another report using Jump to >> > URL. >> > >> > To avoid hard coding, I am using the Globals!ReportServerUrl variable >> > to >> > build up the path to the linked report. >> > >> > When I run the first report from Report Manager, it displays as >> > expected >> > and >> > the URL is something like >> > >> > http://bhhrstest/Reports/Pages/Report.aspx?ItemPath=%2fFolder1%2fFolder2%2fReport1 >> > >> > When I click on the link, the new report displays fine but no longer >> > contained within the Report Manager framework. The URL is something >> > like >> > >> > http://bhhrstest/ReportServer/Pages/ReportViewer.aspx?/Folder1/Folder2/Report2¶m1=xxx¶m2=yyy&rs:Command=Render >> > >> > How is the value of Globals!ReportServerUrl determined ? >> > >> > Thanks >> > Steve >> > >> > >> >> >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |