Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Is there a way to add link in the SSRS report so as to jump to a section in the report?

Posted on 2012-03-30
2
Medium Priority
?
316 Views
Last Modified: 2012-04-14
I want to add several links on the top of the report so that when my users click on the link it will jump to different sections within the same report.

It's a little bit like the anchor in HTML.  Any idea?  Thanks.
0
Comment
Question by:thomaszhwang
2 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 1000 total points
ID: 37789113
Not quite a perfect answer, but maybe a way around it ...

I've used a picture of a button with the right legend  (clipped from SSMS!!) and the action going to another report. You should be able to do the same thing for the same report, using a stored procedure for the data in the dataset, and use the button to pass the SP a parameter that tells it in what order to send the sections. Then you start with them ordered A, B, C, D, E, F and maybe you click a button labelled "D" so you get the report in order D, E, F, A, B, C - so rather than scrolling the report, the report moves to you!.
0
 

Author Closing Comment

by:thomaszhwang
ID: 37847504
There is something called bookmark.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question