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
307 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 500 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
IF SQL Query 12 29
SQL Server 2008 Std. License Key owner or vendor 4 56
SQL Query Across Multiple Tables - Help 5 22
Estimating my database size 7 17
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

733 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