Drillthrough Reports not working in Webforms Report Viewer Control

I am using SSRS 2005.
I created a report (Report A) which links to another report (Report B). The
drillthrough works fine both in Visual Studio and via Report Manager.
I have an ASP.NET application which uses the Report Viewer Control to
display Report A. When I click the links in Report A to go to Report B, the
Report Viewer Control/IE shows the hour glass as if something is about to
happen, refreshes the page but still displays Report A.
Obviously the link is set up properly and the reports work since linking
from Report A to Report B works fine from Report Manager.
Are there any known issues with Drillthrough Reports not working in Webforms
Report Viewer Control? Are there any special considerations I should know
about? Any special set up I should be doing?
Any help with this will be greatly appreciated.
--
Chris, SSSIHello Chris,
I have tested on my side that the Drillthrough report works fine on my side.
Here are the steps:
1. Create a new Web Site in the VS 2005.
2. Drag a Report View Control to the Web Page.
3. Click the triangle in the right-up of the Report View Control.
4. Enter the Report Server name and the Report Path of the Drillthough
report.
5. Run the solution and the Drillthough report works fine.
Please try the steps on your side and let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Wei Lu,
According to your steps I am doing everything correctly, but as I mentioned
in my intial post this is not working.
Can you please answer these questions from my original post:
1) Are there any known issues with Drillthrough Reports not working in
Webforms
Report Viewer Control?
2) Are there any special considerations I should know about?
3) Any special set up I should be doing?
4) What could explain this behavior of the report links not working *ONLY*
in the Report Viewer Control?
Thanks!
-- Chris
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> I have tested on my side that the Drillthrough report works fine on my side.
> Here are the steps:
> 1. Create a new Web Site in the VS 2005.
> 2. Drag a Report View Control to the Web Page.
> 3. Click the triangle in the right-up of the Report View Control.
> 4. Enter the Report Server name and the Report Path of the Drillthough
> report.
> 5. Run the solution and the Drillthough report works fine.
> Please try the steps on your side and let me know the result.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||I don't see any attachment. Is it supposed to be attached to your reply?
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> So far as I know, there is not any known issue with Drillthrough Reports
> not working in Webforms Report Viewer Control.
> The only thing I do in the VS project is add the ReportViewer control:
> <rsweb:ReportViewer ID="ReportViewer1" runat="server"
> Font-Names="Verdana" Font-Size="8pt"
> Height="400px" ProcessingMode="Remote" Width="692px" >
> <ServerReport ReportPath="/ReportDemo/Drillthrough" />
> </rsweb:ReportViewer>
> The attachement is the sample aspx page.
> Please let me know does this works on your side.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support|||Hello Chris,
OK. I will post the HTML Code of the aspx Page.
============================<%@. Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs"
Inherits="_Default" %>
<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
Font-Names="Verdana" Font-Size="8pt"
Height="400px" ProcessingMode="Remote" Width="692px"
DocumentMapCollapsed="True">
<ServerReport ReportPath="/ReportDemo/MultiParameter" />
</rsweb:ReportViewer>
</div>
</form>
</body>
</html>
=============================
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hi,
It turns out I created my own problem. Chalk it up to lack of experience
with ASP.NET apps. ;-)
The problem was I have code in my code behind page to configure the Report
Viewer control, but I was not checking for a post back condition. When the
user clicks a link to a drill through report a post back is done. As a result
my code behind page was reinitializing the Report Viewer on every user click.
Once I moved that Report Viewer set up code inside a check for "not
postback" everything worked fine.
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
>