Failing to "Jump to report" from hyperlink

Hot Topic

Execute stored proc on a named instance
Transfer SQL Server Objects Task - Warning: Stored procedure already exists at destination.
Partitioned view & computed column..
SSIS error message when trying to open MSDB in management studio
Master-detail on the same dataset
Unable to display image of unconventional url in Subreport
server problem occurred during deployment of vb.net application with MSSQL db
I don't understand why
best way to clean up temp files
Is there a way to set a variable in a data flow from a SQL statement (like in control flow)

SQL Server

Management Studio Express CTP update now available
Changing Column and Row Heading in MDX
reportviewer control
I want make table 4 like this one in SQL server 2005
Balance Forwarding
"certificate not found" for second receiver
The SQL Server Service Broker Challange
Capture Referrer URL within a report.
SSIS Package OLE DB Connection Issue
SQL Server Service Broker Examples

Failing to "Jump to report" from hyperlink

I am designing a report and have a text box containing a hyperlink that should navigate to another report when clicked. 

In the "advanced textbox properties", on the naviagtion tab, I have clicked "Jump to report" and selected the report I want to jump to from the drop-down.  (The target report is in the same folder)

When I preview this from the IDE, all is OK but when deploying to the Report server, clicking the link just brings up a blank page which fails to show the 3 parameters for the target report.  Changing the target report's defaults has no impact also setting the Parameters from the Navigation tab in the textbox's advanced props doesn't help.

The rpt it's trying to open is TestStrategist ProjectMetrics Deltas  (This report name also appears at the top of the blank report)

Here's the target URL:

http://<machine name>/Reports/Pages/Report.aspx ServerUrl=http%3a%2f%2f<machine name>%2fReportServer%3f%252fTS_Reporting%252fTestStrategist%2bProjectMetrics%2bDeltas%26TS_ProjectId%3d2%26rs%253aParameterLanguage%3d%26rc%253aParameters%3dCollapsed%26rc%253aReplacementRoot%3dhttp%253a%252f%252f<machine name>%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d

 

 

 

 

Answer this question

Failing to "Jump to report" from hyperlink

  • xavier gonzalez

    The issue appears to be the inclusion of:

    %253aParameters%3dCollapsed%26rc

    ...in the query string.  (When removed, rpt displays parameters OK)

    Is there a (server-wide ) setting that can be changed to remove this

    Cheers, Col

     

  • Balamurali Krishnan

    This setting collapses the parameters area. It is generally expected that drillthroughs will contain all of the parameter values needed to run the target report. If you can't specify defaults for the report parameters that are not passed in the drillthrough, then you could use a URL action and construct the drillthrough link through an expression.

  • cats_five

    The docs have improved with RS 2005, especially with the latest update. You don't even have to have 2005, you can download the docs at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx. Other resources are books about RS 2000 (http://www.microsoft.com/sql/prodinfo/previousversions/rs/rs_books.mspx). This forum and lots of blogs are also helpful resources.

  • toddo

    Many thanks for this intelligence.  I managed to get it going with the URL action as suggested.

    I'm often coming up against fiddly issues like this with RS 2000 ...  RS help isn't all that comprehensive so can you advise where to go with such queries in the future   (Or are the forums my best bet )

    Many thanks,

    Col

     

     

     
  • Failing to "Jump to report" from hyperlink
Answer this question