• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1732
  • Last Modified:

How can I select the document map in a report and highlight corrsponding location in the report?

I have created a document map in my SSRS report:

1. When I select a link in the document map
     a. It does not by default highlight the corresponding row in the report.

1. When I select a link in the document map
    a. I want the corresponding row in the report to be highlighted.
1 Solution
You can do it with conditional formatting ,very much alike crystal:
ValentinoVBI ConsultantCommented:
Interesting question, but unfortunately this is not possible out-of-the-box.  There's no "DocumentMap_OnClick" or similar event in which one would be able to do this.

I thought with some creativity and the bookmark functionality that I could build something similar myself but have unfortunately not succeeded in this.  I did manage to build a navigation table using bookmarks but couldn't figure out how to combine this with a hidden report parameter.  The missing link is the possibility to pass the bookmark ID through a report server URL parameter, apparently that is not supported either.

I also came across a hack that involved custom code to push javascript into the output but couldn't get that to work either.

Ref How to: Add a Bookmark to a Report (Report Builder 3.0 and SSRS)

I have included the RDL for your reference, in case you'd like to continue in this direction.

you might have been falsely encouraged by the "You can do it with conditional formatting" comment made earlier - regrettably it isn't just a conditional formatting issue.

There has to be "event handling" to capture the user's click in the display map before a format condition can be activated. Sadly SSRS does not provide the necessary event handling capability.

I can't comment on the other suggestions by ValentioV, but something beyond "out-of-the-box" would have to be involved. Note, if you wish to remain out-of-the-box the answer is it isn't currently possible.

No points please, just wanting to confirm the absence of the needed event handling.
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Mark WillsTopic AdvisorCommented:
There does seem to be some confusion about Document Maps.

They are like a Table of Content on the left hand side like a Tree. You click on one of the groups and the report would refresh to show just that group.

So, why or what is intended by highlighting with a colour (or somehow else) when the report is essentially filtered just to that group on the document map ? Assuming page breaks...

So, it wont go to the "row" in the report. It is not quite that style of navigation. The report will be rendered to reflect just the item you clicked on within the Document Map.

There are a couple of easy to understand examples floating around : http://www.sqlcircuit.com/  and http://ssrstutorials.blogspot.com.au/2012/10/lesson-21-ssrs-2008-r2-document-maps.html Both show step by step how to build, but more importantly what the document map does.

Little bit surprised there isn't one in EE Articles... (just in case someone might be inspired to write)

Does that make sense ? Or is there something else I am missing ?
Mark WillsTopic AdvisorCommented:
Ummm... to clarify, I was assuming the group by is segregated by page breaks.
ValentinoVBI ConsultantCommented:
Ummm... I was assuming the group by is segregated by page breaks.

You were indeed :)  When using page breaks it would indeed appear as if the doc map filters but it is actually just jumping to the item which happens to be on another page.  Without page breaks the report just jumps down to the clicked item...
Mark WillsTopic AdvisorCommented:
And that is my point... Unless you page break, you will not have any other option.

There simply isn't the control needed to highlight the current row based on the document map selection.

So, I guess the answer is "it cannot be done" using the standard controls.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now