Showing posts with label aspx. Show all posts
Showing posts with label aspx. Show all posts

Wednesday, March 28, 2012

Report Web Viewer Control Error - SQL2005 September CTP

I am trying to use the Report Viewer Control in an ASPX page but getting the following error :- "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. ". This is with the SQL Server 2005 September CTP. Is there any option that i should turn on or off?...

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrowsql

Report Web Viewer Control Error - SQL2005 September CTP

I am trying to use the Report Viewer Control in an ASPX page but getting the following error :- "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. ". This is with the SQL Server 2005 September CTP. Is there any option that i should turn on or off?...

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrow

Monday, March 26, 2012

report viewer problem

I found a few topics about that problem but I'm not sure it solves my
problem.
I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
Each report view is running a diffrent report.
in the code behinde I'm adding each report a parameter from my page.
Now, my site is configure to send me errors to my mail.
I've noticed that every time that I leave the page with the 4 report
viewer open, after about 10-12 minutes (without toucing anything and
without any refresh or postback) I get an error mail with this error:
Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
(rsExecutionNotFound)
The page itself stay OK with the 4 viewer and the user don't know that
there was a problem but I do.
Any thing know way is that?
I saw some thing about session of the report viewer but I'm not sure
about that.
B.T.W
I'm still with sp1on my sql server, Does any body know if it realted
to my problem?
Thanks!On Jan 7, 8:51 am, nicknack <roezo...@.gmail.com> wrote:
> I found a few topics about that problem but I'm not sure it solves my
> problem.
> I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
> Each report view is running a diffrent report.
> in the code behinde I'm adding each report a parameter from my page.
> Now, my site is configure to send me errors to my mail.
> I've noticed that every time that I leave the page with the 4 report
> viewer open, after about 10-12 minutes (without toucing anything and
> without any refresh or postback) I get an error mail with this error:
> Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
> (rsExecutionNotFound)
> The page itself stay OK with the 4 viewer and the user don't know that
> there was a problem but I do.
> Any thing know way is that?
> I saw some thing about session of the report viewer but I'm not sure
> about that.
> B.T.W
> I'm still with sp1on my sql server, Does any body know if it realted
> to my problem?
> Thanks!
Actually, it sounds like the session is timing out. You might be able
to tweak the session timeout variable in the web.config file. Also, I
would suggest using fewer report viewer controls to improve
performance and streamline the application. You should be able to
dynamically set the report associated with the report viewer control.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Martinez,
Well, I need those 4 report viewer 'coz I need to display 4 graphs at
the same time for comparison but that not so bad.
The problem is the error I'm getting (actully - its 4 errors. one for
each viewer).
In my web.config of the asp.net appliction I have <sessionState
timeout=3D60> so it souldn't drop my seesion after 10 minuts (Maybe
there is a session configuration in the sqlserver as well').
Any way, The page does not refresh after the report are loaded so
isn't there a way to tell the viewer not to try and refresh him self?
Thanks again, hope to get more ideas,
Roy.
On 8 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:43, EMartinez <emartinez...@.gmail.c=om> wrote:
> On Jan 7, 8:51 am, nicknack <roezo...@.gmail.com> wrote:
>
> > I found a few topics about that problem but I'm not sure it solves my
> > problem.
> > I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
> > Each report view is running a diffrent report.
> > in the code behinde I'm adding each report a parameter from my page.
> > Now, my site is configure to send me errors to my mail.
> > I've noticed that every time that I leave the page with the 4 report
> > viewer open, after about 10-12 minutes (without toucing anything and
> > without any refresh or postback) I get an error mail with this error:
> > Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
> > (rsExecutionNotFound)
> > The page itself stay OK with the 4 viewer and the user don't know that
> > there was a problem but I do.
> > Any thing know way is that?
> > I saw some thing about session of the report viewer but I'm not sure
> > about that.
> > B.T.W
> > I'm still with sp1on my sql server, Does any body know if it realted
> > to my problem?
> > Thanks!
> Actually, it sounds like the session is timing out. You might be able
> to tweak the session timeout variable in the web.config file. Also, I
> would suggest using fewer report viewer controls to improve
> performance and streamline the application. You should be able to
> dynamically set the report associated with the report viewer control.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Jan 8, 2:13 am, nicknack <roezo...@.gmail.com> wrote:
> Hi Martinez,
> Well, I need those 4 report viewer 'coz I need to display 4 graphs at
> the same time for comparison but that not so bad.
> The problem is the error I'm getting (actully - its 4 errors. one for
> each viewer).
> In my web.config of the asp.net appliction I have <sessionState
> timeout=3D60> so it souldn't drop my seesion after 10 minuts (Maybe
> there is a session configuration in the sqlserver as well').
> Any way, The page does not refresh after the report are loaded so
> isn't there a way to tell the viewer not to try and refresh him self?
> Thanks again, hope to get more ideas,
> Roy.
> On 8 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:43, EMartinez <emartinez...@.gmail=.com> wrote:
> > On Jan 7, 8:51 am, nicknack <roezo...@.gmail.com> wrote:
> > > I found a few topics about that problem but I'm not sure it solves my
> > > problem.
> > > I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
> > > Each report view is running a diffrent report.
> > > in the code behinde I'm adding each report a parameter from my page.
> > > Now, my site is configure to send me errors to my mail.
> > > I've noticed that every time that I leave the page with the 4 report
> > > viewer open, after about 10-12 minutes (without toucing anything and
> > > without any refresh or postback) I get an error mail with this error:
> > > Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
> > > (rsExecutionNotFound)
> > > The page itself stay OK with the 4 viewer and the user don't know that=
> > > there was a problem but I do.
> > > Any thing know way is that?
> > > I saw some thing about session of the report viewer but I'm not sure
> > > about that.
> > > B.T.W
> > > I'm still with sp1on my sql server, Does any body know if it realted
> > > to my problem?
> > > Thanks!
> > Actually, it sounds like the session is timing out. You might be able
> > to tweak the session timeout variable in the web.config file. Also, I
> > would suggest using fewer report viewer controls to improve
> > performance and streamline the application. You should be able to
> > dynamically set the report associated with the report viewer control.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
If you are using local mode, you might want to switch to server mode.
Hope this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi,
I'm already useing server mode to load my report from the sqlserver to
my asp.net server where I'm running my application.
Its look like a session problem but I don't know way it need to
refresh the report after 10 minuts and look for the session again.
Thanks.
On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> If you are using local mode, you might want to switch to server mode.
> Hope this helps further.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Jan 9, 2:34 am, nicknack <roezo...@.gmail.com> wrote:
> Hi,
> I'm already useing server mode to load my report from the sqlserver to
> my asp.net server where I'm running my application.
> Its look like a session problem but I don't know way it need to
> refresh the report after 10 minuts and look for the session again.
> Thanks.
> On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> > If you are using local mode, you might want to switch to server mode.
> > Hope this helps further.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You might want to expand the session state in the web.config file a
little more. Also, you might try to see if there is a timeout set
somewhere for the virtual directory of your website -and/or- in IIS.
Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||I'll try to find another options.
Thank for your help Martinez!
Roy.
On 10 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 03:11, EMartinez <emartinez...@.gmail.=com> wrote:
> On Jan 9, 2:34 am, nicknack <roezo...@.gmail.com> wrote:
>
> > Hi,
> > I'm already useing server mode to load my report from the sqlserver to
> > my asp.net server where I'm running my application.
> > Its look like a session problem but I don't know way it need to
> > refresh the report after 10 minuts and look for the session again.
> > Thanks.
> > On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> > > If you are using local mode, you might want to switch to server mode.
> > > Hope this helps further.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant
> You might want to expand the session state in the web.config file a
> little more. Also, you might try to see if there is a timeout set
> somewhere for the virtual directory of your website -and/or- in IIS.
> Sorry that I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Jan 10, 12:58 am, nicknack <roezo...@.gmail.com> wrote:
> I'll try to find another options.
> Thank for your help Martinez!
> Roy.
> On 10 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 03:11, EMartinez <emartinez...@.gmai=l.com> wrote:
> > On Jan 9, 2:34 am, nicknack <roezo...@.gmail.com> wrote:
> > > Hi,
> > > I'm already useing server mode to load my report from the sqlserver to=
> > > my asp.net server where I'm running my application.
> > > Its look like a session problem but I don't know way it need to
> > > refresh the report after 10 minuts and look for the session again.
> > > Thanks.
> > > On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> > > > If you are using local mode, you might want to switch to server mode=.
> > > > Hope this helps further.
> > > > Regards,
> > > > Enrique Martinez
> > > > Sr. Software Consultant
> > You might want to expand the session state in the web.config file a
> > little more. Also, you might try to see if there is a timeout set
> > somewhere for the virtual directory of your website -and/or- in IIS.
> > Sorry that I could not be of greater assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Report Viewer Jump to URL error after drilldown

Hello,

I'm using an ASPX page + ReportViewer + remote report with drilldown and Jump to Url (target _blank) in IE 6.

The ReportViewer's property AsyncRendering is set to true.

After drilldown, if i click on the text with the navigation action "Jump to Url", i have this error message in IE : Javascript Error : can't execute code from a freed script.

The jump to URL "works", but not in a "blank" page (in the same page of the ReportViewer).

If the the ReportViewer's property AsyncRendering is set to false, "Jump to Url" works fine (in a new IE page). But my report is very large, and i need the AsyncRendering set to true.

The only solution i found is to use IFrame with direct URL access to ReportServer, instead of ReportViewer.

I would prefer to use ReportViewer, so if someone as an idea of this problem, many thanks for is help !

Thanks,

Frederic

I am having the same error that Frederic is having. not only that my web page is loading within the report viewer I am getting the same script error. When I set AsyncRendering =false, the script error goes away and web page loads correctly( in the same browser); however, my report is centered in the report viewer and I have to scroll to the right to see it. Everytime I expland or collapse the focus changes and I can't see the report unless I scroll to the right(that's annoying)

I am working with local reports since the data for my report come from class objects. I am not publishing my reports to the report server. Is there a way to accomplish this with Frames without the report viewer? If so please let me know. I have been having this problem for 2 weeks now and I am not finding any resolution for it.

I will appreciate any help I coul get with this.

Thanks in advance,

Mini

|||

Frederic,

Can you tell me how you got it to work with IFrame. I cant't get it to open an external link.

thanks

Mini

|||

Hi Mini,

I'm using a Report Server, not a local report, that's why instead of using ReportViewer i can use an IFrame with an URL to my ReportServer.

In the ASPX page i have declared :

<iframeid="frameRS"runat="server"src="http://localhost/ReportServer?/ReportFolder/Report1&rs:Command=Render&rc:LinkTarget=blank"width="100%"height="100%"></iframe>

In this exemple, the Report Server is local (localhost/ReportServer).

It's possible to change the value of the src property (C# exemple in the .aspx.cs file) :

protected

void Page_Load(object sender,EventArgs e)

{

this.frameRS.Attributes["src"] ="http://localhost/ReportServer?/ReportFolder/Report2&rs:Command=Render&rc:LinkTarget=blank";

}

Unfortunately, i'm not sure that you can use this solution with a local report.

Bests regards,

Frederic

|||

I managed to get my report loaded into the Frame and executed the hyperlink. However I am encountered with a new problem

My report is pretty wide and the report is not showing all of it to the right. I know my frame width is 100% thus I am not getting the scrollbar but some how part of the report on the right is missing. I am thinking it is not being returned from the report server. Howerver if I directly go to the server and run it, I see it all

Any idea what is going on

Thanks

Mini

|||

Hi Mini,

Did you manage with the example i sent you last week ?

Best regards,

Frederic

report viewer in new window

I'm executing report server from my aspx page as follows:
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
taSource=c:\temp\mydataset.xml)
this seems the easiest way.
Is there any way I can get the report to display in a new window so that my
aspx page still shows?
Thanks,
GDean,
In your ASP.NET page, you can generate script to run in the window onload
event. In your case, this script would call window.open passing the report
URL. Just make sure that you put in window onload to prevent cookie lost if
you are using Forms Authentication. This will guarantee that the script will
run when the page and cookies are loaded.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.manning.com/lachev
Home page and blog http://www.prologika.com
---
"G. Dean Blake" <Dean@.nospam.com> wrote in message
news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> I'm executing report server from my aspx page as follows:
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> taSource=c:\temp\mydataset.xml)
> this seems the easiest way.
> Is there any way I can get the report to display in a new window so that
my
> aspx page still shows?
> Thanks,
> G
>|||if you mean when my aspx page is just loading, I don't have the information
yet to generate the report. A purpose of my aspx page is to develop a
dataset to generate the report. My response.redirect is in answer to a
button click event.
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:uylD6E4hEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Dean,
> In your ASP.NET page, you can generate script to run in the window onload
> event. In your case, this script would call window.open passing the report
> URL. Just make sure that you put in window onload to prevent cookie lost
if
> you are using Forms Authentication. This will guarantee that the script
will
> run when the page and cookies are loaded.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.manning.com/lachev
> Home page and blog http://www.prologika.com
> ---
> "G. Dean Blake" <Dean@.nospam.com> wrote in message
> news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > I'm executing report server from my aspx page as follows:
> >
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> > taSource=c:\temp\mydataset.xml)
> >
> > this seems the easiest way.
> >
> > Is there any way I can get the report to display in a new window so that
> my
> > aspx page still shows?
> > Thanks,
> > G
> >
> >
>|||No, I meant using Page.RegisterClientScriptBlock in your ASP.NET page to
generate dynamically the browser window.onload call instead of using
Response.Redirect, e.g.
StringBuilder sb=new StringBuilder();
sb.Append("<script language=\"javascript\">");
sb.Append("function requestReport");
sb.Append("{");
sb.Append("window.open (<'your report URL'>");
sb.Append("}");
sb.Append("</script>");
this.Page.RegisterClientScriptBlock("script",sb.ToString());
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.manning.com/lachev
Home page and blog http://www.prologika.com
---
"G. Dean Blake" <Dean@.nospam.com> wrote in message
news:u$8xE%237hEHA.632@.TK2MSFTNGP12.phx.gbl...
> if you mean when my aspx page is just loading, I don't have the
information
> yet to generate the report. A purpose of my aspx page is to develop a
> dataset to generate the report. My response.redirect is in answer to a
> button click event.
> "Teo Lachev" <teo@.nospam.prologika.com> wrote in message
> news:uylD6E4hEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > Dean,
> >
> > In your ASP.NET page, you can generate script to run in the window
onload
> > event. In your case, this script would call window.open passing the
report
> > URL. Just make sure that you put in window onload to prevent cookie lost
> if
> > you are using Forms Authentication. This will guarantee that the script
> will
> > run when the page and cookies are loaded.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > http://www.manning.com/lachev
> > Home page and blog http://www.prologika.com
> > ---
> >
> > "G. Dean Blake" <Dean@.nospam.com> wrote in message
> > news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > > I'm executing report server from my aspx page as follows:
> > >
> >
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> > > taSource=c:\temp\mydataset.xml)
> > >
> > > this seems the easiest way.
> > >
> > > Is there any way I can get the report to display in a new window so
that
> > my
> > > aspx page still shows?
> > > Thanks,
> > > G
> > >
> > >
> >
> >
>

Friday, March 23, 2012

Report Viewer display problem

Hi,
I use reportviewer.dll in my aspx page, and everything works fine on my
development pc where sqlserver, reporting service and visual studio
installed. But when i try to access this page from another pc, iframe which
holds reportviewer gives me "The page cannot be displayed. The page you are
looking for is currently unavailable.....". Other stuff like ascx,
menus,gif are working well. Any suggestions?
Thanks.Ever find a solution to this?
"saglamtimur" wrote:
> Hi,
> I use reportviewer.dll in my aspx page, and everything works fine on my
> development pc where sqlserver, reporting service and visual studio
> installed. But when i try to access this page from another pc, iframe which
> holds reportviewer gives me "The page cannot be displayed. The page you are
> looking for is currently unavailable.....". Other stuff like ascx,
> menus,gif are working well. Any suggestions?
> Thanks.
>
>

Report Viewer control and ASPX

I am trying to use the Report Viewer Control in an ASPX page but getting the following error "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method". This is with September CTP of SQL Server 2005. I am not trying to set any DTD, the same report works if displayed using the WinForm viewer control...so I am not sure why this is happening. is there any samples available for using the Report Web viewer control in an aspx page?

Thanks

Krishna

This happens, when you are using a IP-address for the SQL Server Reporting Server once I started using DNS/Machine name the error went away - Krishna|||

Hello,

I am also getting the following error when viewing a report through an ASP.NET 2.0 Report Viewer control:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

I seem to be getting it when retrieving a large amount of data. When I run the same report for a subset of the data, the report runs fine.

Any ideas?

Thanks in advance...

Brian

|||

Same problem when using Report Builder inside of SQL Reporting Services with Service Pack. The SRS Product doesn't seem to scale well to large reports.

|||

Hello ,Krishnaswin

How do you fix the issue , can you explain more ?

How to use the DNS/Machine name ,i do not catch your meaning .

lizzy

|||

Hello,Kishnawin

I use the method as you suggested ,but still have the issue .

Hope some one can give some suggestion

|||I am having same problem. I am using DNS name.. Reports are not large but am still getting this error. Help please

Report Viewer control and ASPX

I am trying to use the Report Viewer Control in an ASPX page but getting the following error "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method". This is with September CTP of SQL Server 2005. I am not trying to set any DTD, the same report works if displayed using the WinForm viewer control...so I am not sure why this is happening. is there any samples available for using the Report Web viewer control in an aspx page?

Thanks

Krishna

This happens, when you are using a IP-address for the SQL Server Reporting Server once I started using DNS/Machine name the error went away - Krishna|||

Hello,

I am also getting the following error when viewing a report through an ASP.NET 2.0 Report Viewer control:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

I seem to be getting it when retrieving a large amount of data. When I run the same report for a subset of the data, the report runs fine.

Any ideas?

Thanks in advance...

Brian

|||

Same problem when using Report Builder inside of SQL Reporting Services with Service Pack. The SRS Product doesn't seem to scale well to large reports.

|||

Hello ,Krishnaswin

How do you fix the issue , can you explain more ?

How to use the DNS/Machine name ,i do not catch your meaning .

lizzy

|||

Hello,Kishnawin

I use the method as you suggested ,but still have the issue .

Hope some one can give some suggestion

|||I am having same problem. I am using DNS name.. Reports are not large but am still getting this error. Help please

Report Viewer control and ASPX

I am trying to use the Report Viewer Control in an ASPX page but getting the following error "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method". This is with September CTP of SQL Server 2005. I am not trying to set any DTD, the same report works if displayed using the WinForm viewer control...so I am not sure why this is happening. is there any samples available for using the Report Web viewer control in an aspx page?

Thanks

Krishna

This happens, when you are using a IP-address for the SQL Server Reporting Server once I started using DNS/Machine name the error went away - Krishna|||

Hello,

I am also getting the following error when viewing a report through an ASP.NET 2.0 Report Viewer control:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

I seem to be getting it when retrieving a large amount of data. When I run the same report for a subset of the data, the report runs fine.

Any ideas?

Thanks in advance...

Brian

|||

Same problem when using Report Builder inside of SQL Reporting Services with Service Pack. The SRS Product doesn't seem to scale well to large reports.

|||

Hello ,Krishnaswin

How do you fix the issue , can you explain more ?

How to use the DNS/Machine name ,i do not catch your meaning .

lizzy

|||

Hello,Kishnawin

I use the method as you suggested ,but still have the issue .

Hope some one can give some suggestion

|||I am having same problem. I am using DNS name.. Reports are not large but am still getting this error. Help please

Report Viewer control and ASPX

I am trying to use the Report Viewer Control in an ASPX page but getting the following error "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method". This is with September CTP of SQL Server 2005. I am not trying to set any DTD, the same report works if displayed using the WinForm viewer control...so I am not sure why this is happening. is there any samples available for using the Report Web viewer control in an aspx page?

Thanks

Krishna

This happens, when you are using a IP-address for the SQL Server Reporting Server once I started using DNS/Machine name the error went away - Krishna|||

Hello,

I am also getting the following error when viewing a report through an ASP.NET 2.0 Report Viewer control:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

I seem to be getting it when retrieving a large amount of data. When I run the same report for a subset of the data, the report runs fine.

Any ideas?

Thanks in advance...

Brian

|||

Same problem when using Report Builder inside of SQL Reporting Services with Service Pack. The SRS Product doesn't seem to scale well to large reports.

|||

Hello ,Krishnaswin

How do you fix the issue , can you explain more ?

How to use the DNS/Machine name ,i do not catch your meaning .

lizzy

|||

Hello,Kishnawin

I use the method as you suggested ,but still have the issue .

Hope some one can give some suggestion

|||I am having same problem. I am using DNS name.. Reports are not large but am still getting this error. Help pleasesql

Report Viewer control and ASPX

I am trying to use the Report Viewer Control in an ASPX page but getting the following error "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method". This is with September CTP of SQL Server 2005. I am not trying to set any DTD, the same report works if displayed using the WinForm viewer control...so I am not sure why this is happening. is there any samples available for using the Report Web viewer control in an aspx page?

Thanks

Krishna

This happens, when you are using a IP-address for the SQL Server Reporting Server once I started using DNS/Machine name the error went away - Krishna|||

Hello,

I am also getting the following error when viewing a report through an ASP.NET 2.0 Report Viewer control:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

I seem to be getting it when retrieving a large amount of data. When I run the same report for a subset of the data, the report runs fine.

Any ideas?

Thanks in advance...

Brian

|||

Same problem when using Report Builder inside of SQL Reporting Services with Service Pack. The SRS Product doesn't seem to scale well to large reports.

|||

Hello ,Krishnaswin

How do you fix the issue , can you explain more ?

How to use the DNS/Machine name ,i do not catch your meaning .

lizzy

|||

Hello,Kishnawin

I use the method as you suggested ,but still have the issue .

Hope some one can give some suggestion

|||I am having same problem. I am using DNS name.. Reports are not large but am still getting this error. Help please

Wednesday, March 21, 2012

Report usage in SQL2005 RS

Is there a SSIS equivalent to the information in DTS package described at
http://msdn2.microsoft.com/en-us/library/aa972246(SQL.80).aspx '
If not, is it possible to install the DTS package and migrate it to SSIS?Make sure Samples are installed on your MSSQL 2005 server. Then go to:
C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report
Samples\Server Management Sample Reports
There's a solution (Server Management Sample Reports.sln) that contains an
SSIS package and some sample reports. Read the
readme_ServerManagementReports.htm file for instructions.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"William" <William@.discussions.microsoft.com> wrote in message
news:B0511D2D-77F1-4FFC-A070-A8FE2C47C567@.microsoft.com...
> Is there a SSIS equivalent to the information in DTS package described at
> http://msdn2.microsoft.com/en-us/library/aa972246(SQL.80).aspx '
> If not, is it possible to install the DTS package and migrate it to SSIS?