Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Hyperlinks

Author  Topic 

erica686
Starting Member

13 Posts

Posted - 2009-12-16 : 20:39:16
I have a report, which uses hyperlinks to navigate to other detailed reports. When the hyperlink is clicked by the user, and the linked report generates, I want to create a home button, that will return them to the original report. I know that there is a 'back' button on the toolbar that can be used, but I want to make a link within the linked report instead.

Thanks.

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-12-17 : 14:04:10
add a hyperlink to the the detailed reports that point to home.

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page

erica686
Starting Member

13 Posts

Posted - 2009-12-17 : 18:20:38
I thought that I had already tried this and failed, but after trying again it has worked.

Another question... When I create the hyperlink that takes the user back to the main report, the main report refreshes... Is there anyway that I can stop the report from re-generating everytime the user goes back to that report?? I want the data to be current when it is first opened, but if the user goes to a different report and comes back, I don't need it to refresh.
Go to Top of Page

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-12-17 : 19:00:37
well unless there a SaveState property I am not sure how to do that. You could save the whole URL to the sub report in a variable and embed that in the hyperlink of the sub report?

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page
   

- Advertisement -