Report wont render

I am having an issue with a particular report not rendering when
displaying in the web browser from reporting services web site. The
report never displays and if you check under site settings the job is
showing that it is in an Action of "Render". Has anyone else ever seen
this? Is there something I should look for in one of the log files to
help me find out what is causing this error?
Thanks ahead of time.sfibich wrote:
> I am having an issue with a particular report not rendering when
> displaying in the web browser from reporting services web site. The
> report never displays and if you check under site settings the job is
> showing that it is in an Action of "Render". Has anyone else ever seen
> this? Is there something I should look for in one of the log files to
> help me find out what is causing this error?
> Thanks ahead of time.
A litte more infomation. I get the following message in the browser:
NOTE: I did not cancel the query.
Reporting Services Error
----
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot read the next data row for the data set pfg_dw.
(rsErrorReadingNextDataRow) Get Online Help
Operation cancelled by user.
----
Microsoft Reporting Services|||This looks like an IIS timeout issue. Try increasing the IIS timeout on the
report server: Computer Management - Internet Information Services - Web
Sites - Default Web Site: Right-click properties: Connection timeout.
IIS 6 has a default connection timeout of 120 seconds (while IIS 5 has 900
seconds).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"sfibich" <sfibich@.pfgc.com> wrote in message
news:OdTAv8p8EHA.1400@.TK2MSFTNGP11.phx.gbl...
> sfibich wrote:
> > I am having an issue with a particular report not rendering when
> > displaying in the web browser from reporting services web site. The
> > report never displays and if you check under site settings the job is
> > showing that it is in an Action of "Render". Has anyone else ever seen
> > this? Is there something I should look for in one of the log files to
> > help me find out what is causing this error?
> >
> > Thanks ahead of time.
> A litte more infomation. I get the following message in the browser:
> NOTE: I did not cancel the query.
> Reporting Services Error
> ----
--
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot read the next data row for the data set pfg_dw.
> (rsErrorReadingNextDataRow) Get Online Help
> Operation cancelled by user.
> ----
--
> Microsoft Reporting Services
>sql

Report Viewer Sort and Drill Through

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,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
breadbelt.com@.discussions.microsoft.com> wrote in message
news:EAA4C2DE-FDF3-4D45-B044-37BC7FA2700A@.microsoft.com...
> 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,
>|||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!
"TechnoSpyke" wrote:
> 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
> breadbelt.com@.discussions.microsoft.com> wrote in message
> news:EAA4C2DE-FDF3-4D45-B044-37BC7FA2700A@.microsoft.com...
> > 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,
> >
>
>|||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
breadbelt.com@.discussions.microsoft.com> wrote in message
news:2D8961A7-2606-4341-A177-34249E1948D3@.microsoft.com...
> 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!
>
> "TechnoSpyke" wrote:
>> 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
>> breadbelt.com@.discussions.microsoft.com> wrote in message
>> news:EAA4C2DE-FDF3-4D45-B044-37BC7FA2700A@.microsoft.com...
>> > 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,
>> >
>>sql