Drill through links not rendering in report viewer

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

, +

Hi,

I've got a report developed in VS2010 SP1 for SSRS with a "Go to report" drill through action.

The links render and work when using the native reporting services interface.

But when I render the report in my application using the ASP.Net report viewer, the links are not rendered.

I've inspected the HTML and there's simply no interactivity rendered in the report rendering response.

Is there something I'm not doing which I need to do to enable drill through actions in an ASP.Net application using the report viewer?

If it makes a difference, the report viewer is working in remote mode. Also when using the web service interface too (So /reportserver instead of /reports)

Native mode renders the following anchor in its response:

HTML

<a tabindex="1" onclick="var rp=$get('ReportViewerControl_ctl09_ReportControl');if(rp&&rp.control)rp.control.InvokeReportAction('Drillthrough','113iT0R0R0R0x0:0');return false;"  önkeypress="if(event.keyCode == 13 || event.which == 13){var rp=$get('ReportViewerControl_ctl09_ReportControl');if(rp&&rp.control)rp.control.InvokeReportAction('Drillthrough','113iT0R0R0R0x0:0');}return false;" href="" style="removed:pointer;" class="A4245441523f047238dd5ddd74a6cb4d1138a" target="_top"><div style="WIDTH:28.70mm;" class="r13"><div class="A4245441523f047238dd5ddd74a6cb4d1137"><span class="A4245441523f047238dd5ddd74a6cb4d1136">BF0014</span></div></div></a>

With ASP.Net report viewer, you don't get anchor as part of the response.

Regards,

Steve

Posted 18-Sep-12 3:28am

Stephen Hewison

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Stephen Hewison · Accepted Answer · 2012-09-25T00:36:00

There is a bug in the report viewer control.

When you install SP1 for VS2010, it adds new assembly versions for the report viewer to the GAC.

The new version contains the bug.

Unfortunately it's not possible to specify, within your config, which version to use as all versions have the same assembly version number. This is done to allow easier upgrade of the report viewer component. But it also means that once you install the SP1 component it's very difficult to roll back.

The SP1 runtime version is: v2.0.50727

Make sure you use an earlier version on your live servers, such as the one referenced in the connect article.

The good new is, if you haven't installed the SP1 viewer into the GAC on your production servers, then you shouldn't experience the problem in your live environment.

There is currently a connect article showing progress with this fault. There is a work-around which involves using GACUtil to remove the SP1 assembly versions, but this could create issues for you at a later date and make VS2010 unstable.

http://connect.microsoft.com/VisualStudio/feedback/details/652114/reportviewer-drillthrough-broken-after-vs2010-sp1[^]