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:

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

Desired
1. When I select a link in the document map
    a. I want the corresponding row in the report to be highlighted.
rhservanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

oleggoldCommented:
You can do it with conditional formatting ,very much alike crystal:
http://weblogs.sqlteam.com/joew/archive/2008/08/20/60693.aspx
0
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.
SimulateDocMap.rdl
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PortletPaulfreelancerCommented:
rhservan,

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.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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 ?
0
Mark WillsTopic AdvisorCommented:
Ummm... to clarify, I was assuming the group by is segregated by page breaks.
0
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...
0
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.