Groups | Blog | Home
all groups > sql server reporting services > february 2005 >

sql server reporting services : Report Viewer Sort and Drill Through


Dan Costello breadbelt.com
2/16/2005 10:55:01 PM
We have the ReportViewer placed inside a DotNetNuke framework which is
displaying the initial report fine. However if we create a sort link on any
table header name or create a link on some data returned for a drill though
the new report renders outside the Iframe, outside the framework, and renders
as if you had called a URL report.

Is there any solution for a link within the report viewer Iframe that will
render to the iframe?

Anything would help,

Thank you,
TechnoSpyke
2/17/2005 8:22:50 AM
I had the same problem as you, sort of.

The solution is to modify the ReportViewer control. In the Render method,
assign a name to your IFrame.

output.WriteAttribute("name", "reportFrame");

On the BuildUrlString() add the rc:LinkTarget device info to point to your
IFrame.

this._url = this._serverUrl + "?" + this._reportPath +
"&rs:Command=Render&rc:LinkTarget=reportFrame" +
this.EmumProperties(this._properties);

Hope this helps.

Marlon

"Dan Costello breadbelt.com" <Dan Costello
[quoted text, click to view]

Dan Costello breadbelt.com
2/17/2005 9:43:05 PM
Thank you for the code this helps and gets me closer but still has a problem.
The drill through works fine and the FIRST time I sort a column works great.
However, the second sort in the same iframe seems to loose the iframe
identifier therefore rendering outside as if it was a URL rendered report as
before. Any suggestions?

Thank you again, we are a step closer!


[quoted text, click to view]
TechnoSpyke
2/22/2005 1:49:43 PM
I was testing on a report that had only one level of drill-through, so I
never had the problem before, as the new report would always show on the
dessignated IFrame.

However, on a new report, with multiple levels of drill-throughs, I am now
faced with the same problem as you. The first level would still show on the
IFrame, but the second would always show on _top.

I'm trying to fix this and will surely let you know if a solution comes up.
If you do find a solution, I would really appreciate if you could post it
too.

Thank you.

Marlon

"Dan Costello breadbelt.com" <Dan Costello
[quoted text, click to view]

AddThis Social Bookmark Button