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 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

Report Viewer webpart did not work in wss 3.0

Hi,

I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Thanks,

Dan

I also ran into this and I reported it as an issue on connect.microsoft.com. However, according to the feedback, it is by design and it won't be fixed.|||

Thanks Teo,

I hope it will be solved at some point. Until then, I am using RS in integration mode. It works very nice.

Dan

|||

Take a look at this;

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx

When I try to add a Web Part to a SharePoint page, I get the following error message: "A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe."

Make sure you have followed all of the steps in the Installing the Web Parts section, Installation Process subsection of this paper, including using the –url option to stsadm. If you used the –globalinstall option, try leaving it out so the Web Part package is installed to the bin directory of the virtual server. Manually verify that the bin directory under your SharePoint Web root contains a file called RSWebParts.dll. If you installed SharePoint in the default Web root, this directory would be C:\Inetpub\wwwroot\bin. A copy of this DLL may be found in C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab (assuming that Reporting Services is installed in the default location).

|||He has the web parts working allright. It's just that the RS 2005 web parts are coded against the WSS 2.0 object model and don't support connections. Based on what I've heard they won't be enhanced to support the WSS 3.0 connections feature.sql

Report Viewer webpart did not work in wss 3.0

Hi,

I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Thanks,

Dan

I also ran into this and I reported it as an issue on connect.microsoft.com. However, according to the feedback, it is by design and it won't be fixed.|||

Thanks Teo,

I hope it will be solved at some point. Until then, I am using RS in integration mode. It works very nice.

Dan

|||

Take a look at this;

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx

When I try to add a Web Part to a SharePoint page, I get the following error message: "A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe."

Make sure you have followed all of the steps in the Installing the Web Parts section, Installation Process subsection of this paper, including using the –url option to stsadm. If you used the –globalinstall option, try leaving it out so the Web Part package is installed to the bin directory of the virtual server. Manually verify that the bin directory under your SharePoint Web root contains a file called RSWebParts.dll. If you installed SharePoint in the default Web root, this directory would be C:\Inetpub\wwwroot\bin. A copy of this DLL may be found in C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab (assuming that Reporting Services is installed in the default location).

|||He has the web parts working allright. It's just that the RS 2005 web parts are coded against the WSS 2.0 object model and don't support connections. Based on what I've heard they won't be enhanced to support the WSS 3.0 connections feature.

Report Viewer Web Part Title wont save

In shared view when i save a report viewer web part title & then go & select
another report viewer web part title on the same page the title then defaults
back to report viewer [1] & report viewer [2].
the same happens when i clock off the page & back to it.
thanksAny ideas Microsoft '
Thanks
"Tango" wrote:
> In shared view when i save a report viewer web part title & then go & select
> another report viewer web part title on the same page the title then defaults
> back to report viewer [1] & report viewer [2].
> the same happens when i clock off the page & back to it.
> thanks

Report Viewer web part in Sharepoint 2.0 site

Hello:
I'm running the SSRS 2005 web parts in a Sharepoint 2.0 site. I want
to display a report when a page loads using just the page viewer web
part.
In the properties of the web part, I have http://portal:81/Reports/Pages/Report.aspx?
in the Report Manager URL field and itempath=%2fRepVendorPortal%2fTop
+Sellers in the Report Path field.
When I hit apply, the web part displays "A required argument is
missing from the URL that opens this page: ItemPath".
What am I doing wrong here?
Any assistance is appreciated.
Thanks in advance.
-JoeNever mind. I had the report server URL incorrect (it should have
been just http://portal:81/reports) and the report path should have
just been /repvendorportal/Top Sellers. The + was causing a problem
too.
Thanks.
-Joe
On Nov 8, 1:14 pm, Joe <j...@.josephmarkovich.com> wrote:
> Hello:
> I'm running the SSRS 2005 web parts in a Sharepoint 2.0 site. I want
> to display a report when a page loads using just the page viewer web
> part.
> In the properties of the web part, I havehttp://portal:81/Reports/Pages/Report.aspx?
> in the Report Manager URL field and itempath=%2fRepVendorPortal%2fTop
> +Sellers in the Report Path field.
> When I hit apply, the web part displays "A required argument is
> missing from the URL that opens this page: ItemPath".
> What am I doing wrong here?
> Any assistance is appreciated.
> Thanks in advance.
> -Joe

report viewer web part error

I'm having problems with the SharePoint configuration on a REport Viewer web
part. When Report Explorer and Report Viewer are used together, all is fine.
This is just trying to configure Report Viewer as a stand alone web part.
My direct URL path to a report is:
http://server01/Reports/Pages/Report.aspx?ItemPath=%2fCorporate+Applications%2fOpen+Requests+By+Priority
In the Report Manager URL box, I have http://server01/Reports.
In the Report Path box I have:
/Pages/Report.aspx?ItemPath=%2fCorporate+Applications%2fOpen+Requests+By+Priority.
I get the Reporting Services Error in the Report Viewer web part:
"The path of the item
'/reportserver?%2fCorporate+Applications%2fOpen+Requests+By+Priority&rs:Command=Render'
is not valid. The full path must be less than 260 characters long, must start
with slash; other restrictions apply. Check the documentation for complete
set of restrictions. (rsInvalidItemPath) "
Of course the doc just tells me my path is too long, which it's not.
Any ideas?
Thanks,
PaulI have the same problem...did you figure out a solution? If so, can
you send it to me at ram.pisipati@.lmco.com
Thanks
Ram|||Hi,
I got the same error !
solution:
just enter the folder name from reporting service
i.e. /AD+Site+Reports
Torsten
ram.pisipati@.lmco.com schrieb:
> I have the same problem...did you figure out a solution? If so, can
> you send it to me at ram.pisipati@.lmco.com
> Thanks
> Ram|||Not sure I understand you correctly. Where do you want me to enter the
folder name?
the report viewer web part takes two parameters and this is what I am
entering for each of the parameters
Report Server path: http://www.myserver.com/Reports/?
Report path: /TestFolder/TestReport
Thanks in advance
Ram

Report Viewer web part (sp2)

Does anyone know how to pass parameters through to the Sharepoint
Report Viewer web part?
Thanks,
Paul.Go to the site:
http://blogs.sqlxml.org/bryantlikes/articles/628.aspx
It's give some advices. I hope that will help you

Report Viewer Web Part - Error - Help!

I am trying to integrate reports that I have built with VS 2005 and deployed to my report server locally.

The path to the report is

http://SERVERNAME/Reports/Pages/Report.aspx?ItemPath=%2fBilling+System+Reports%2fBasic+Financial+Reports%2fBasic+Financial+Statistics+-+TimeKeeper+YTD

When I put that into the "Report" parameter the web part display an error:

The report server has encountered a configuration error. See the report server log files for more information

And when I click on the ellipses, I get a pop up with the same error.

I installed SQL2005 SP2 and the RS Add on for MS sharepoint CTP

Any help would be great!

Thanks,

Erik

Assuming your report server is configured in SharePoint integrated mode (which I'm not sure it is). You don't use the report server path for the web part, you use the path to the report in SharePoint. You can get this path from the document library where the report is stored.

|||

What if I just want the web part to act like an iframe into the reporting services web front end, like the web parts for 2000 worked? Are these web parts not designed to work this way? If not, are there any 2005 web parts for viewing reports on the SSRS front end?

Thanks!

sql

Report Viewer vs Report Server

Bonjour!
I deploy a report with Report viewer (Visual Studio 2005) on our web site
and it's working fine, I use the Integrated security. When I try to access
the same report but on the report server I have an authentication error but
with RV it's OK. This means it doesn't talk to the server the same way. Does
someone have hit that problem'
Regards, Joel:)On Nov 7, 9:38 am, Joel <J...@.discussions.microsoft.com> wrote:
> Bonjour!
> I deploy a report with Report viewer (Visual Studio 2005) on our web site
> and it's working fine, I use the Integrated security. When I try to access
> the same report but on the report server I have an authentication error but
> with RV it's OK. This means it doesn't talk to the server the same way. Does
> someone have hit that problem'
> Regards, Joel:)
Hello Joel, you may need to post more specifics on your authentication
setup.
I assume that by deploying "on our web site" you mean that you are
including a Reporting Services report as an object in a ASP.NET page
using the ReportViewer object. Authentication here is a local data
source connecting one-hop to a data source, pulling the data back to
the client and rendering on the client. When deploying to a Reporting
Server, the RS connects to the DS, pulls the data to the RS, renders
it to HTML, and sends the HTML to the client (you).
Check that you deployed to your Reporting Server using
"OverwriteDataSources" at least once, so the .ds files are actually
accessable. Then check the permissions on the Server, making sure
that the "user" that logs into the Reporting Services server has
permission to read from the data source.
Or you may have the "double hop" issue. You are at your desktop, NT
Authenticating to the Reporting Server, which should be sending your
authentication information to a SQL Server using NT Authentication.
This has failed at our company, and required a long process to get it
fixed. Here's the microsoft link: http://support.microsoft.com/kb/264921/
or just search on "double hop" to find solutions.
-- Scott|||Thanks Scott, that's exactly what I'm doing, I will try the "Overwrite"
Regards, Joel :)
"Orne" wrote:
> On Nov 7, 9:38 am, Joel <J...@.discussions.microsoft.com> wrote:
> > Bonjour!
> > I deploy a report with Report viewer (Visual Studio 2005) on our web site
> > and it's working fine, I use the Integrated security. When I try to access
> > the same report but on the report server I have an authentication error but
> > with RV it's OK. This means it doesn't talk to the server the same way. Does
> > someone have hit that problem'
> >
> > Regards, Joel:)
> Hello Joel, you may need to post more specifics on your authentication
> setup.
> I assume that by deploying "on our web site" you mean that you are
> including a Reporting Services report as an object in a ASP.NET page
> using the ReportViewer object. Authentication here is a local data
> source connecting one-hop to a data source, pulling the data back to
> the client and rendering on the client. When deploying to a Reporting
> Server, the RS connects to the DS, pulls the data to the RS, renders
> it to HTML, and sends the HTML to the client (you).
> Check that you deployed to your Reporting Server using
> "OverwriteDataSources" at least once, so the .ds files are actually
> accessable. Then check the permissions on the Server, making sure
> that the "user" that logs into the Reporting Services server has
> permission to read from the data source.
> Or you may have the "double hop" issue. You are at your desktop, NT
> Authenticating to the Reporting Server, which should be sending your
> authentication information to a SQL Server using NT Authentication.
> This has failed at our company, and required a long process to get it
> fixed. Here's the microsoft link: http://support.microsoft.com/kb/264921/
> or just search on "double hop" to find solutions.
> -- Scott
>

Report Viewer toolbar problem

In my web page I have a report viewer with the print button turned on in properties, however when it is displayed I only get the navigation and export part. Would there be a reason for this?
Thanks for the help.

Hi

Install MSSRS Service Pack 2. That will solve your problem.

|||Adonis,
Thanks for the reply. Now I am using Report Services through SQL 2005 Standard and the Report Viewer through VS 2005 Standard if that matters any.
Where do I find the service pack for this that you mention?
Thanks for the information.|||

I think -

What CTP version of 2005 are you using? If July - upgrade

|||I have the full version of SQL 2005 Standard and Visual Studio 2005 Standard. These are the full release versions.|||

Good Evening!

Since I am on the other side of the world so to speak -

You have the "full" version - AND WITH ALL DUE RESPECT - did you purchase this - because if so - I would like to as well --

I can only get a CTP download here in BKK -

Give me some help here in that is this a general first release of 2005?

thank you

|||

I do have the "full" version of Standard (not Professional) for both Visual Studio 2005 and SQL Server 2005. These were offered at the Launch Parties. You can get the "full" version of the Express versions for free here:http://msdn.microsoft.com/vstudio/express/. These are free for one year so if you download them now, there is no cost to you at all.

Hope this helps.

|||

I have researched the "full version" as you have claimed - and SORRY - there is not a FULL version of 2005 other than the CTP release

or

a possible "full" -- BS --- if your company has a relationship - which every company has a relationship!

So in your request please provide a mod and release # then we can help - but do not say to this forum you have a "FULL" release of a "standard" version of 2005...

Watch your words!

|||

Huh? So what, the November 7 launch never happened and the beta is still out there?

I do not know what you are talking about.

But thanks for the great help you have provided.

|||

Sorry about my post about the "FULl" version - please take no personal offense!

I modified the toolbar one time to change the background color and font... I lost the print button on some reports and on others I lost the export button... I never could figure out why - so I reverted back....

I just recently read something on Microsoft's www site about RS 2005 behavioral changes - and the first paragrap indicated problems with headers - maybe there is something in that article - I will go back and look up and post the link to the article -- maybe a small "glitch" in the initial release

Best regards

|||Not sure if you are still working on this. If you are running reports in local mode, the print icons will not be available. Client-side printing is only available in remote mode when you are calling an actual Report Server. Not sure if that applies to your setup or not. You can supposedly get printing to work by writing your own code, but we are just trying this now so not sure if it works or not.

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

Actually, I still am having the problem, but I do see what you are saying because I changed the processing mode to remote and the print button displays. So what I did is import the report to the SQL Reporting Server (I hope I did this right) by using the SQL Management Console.

Now though when I run the app, I am getting the following error:

"The path of the item "\Reports\report.rdlc" is not valid. The path must be less than 260 characters long and restrictions apply. (rsIndalidItemPath)"

What did I do wrong here?

Report Viewer to Get Data from RS Deployed on separate Network.

Hi,

I am using Reporting Services in the following way. The application implements a three tier Architecture viz Web Server, Application Server and Database Server. Reporting Services 2005 is installed on the Database Server.

The application uses ReportViewer Control which is part of an ASPX page deployed on the Web Server. For ReportViewer Control to fetch data from Reporting Services using RS API, we have to set ReportServerUrl and Report Path. In this scenario, the web server cannot communicate to the database server directly. The web server is in the DMZ and it can only communicate with the Application Server which is in a separate Network.

How can I use Report Viewer Control to fetch data from Reporting Services which is on the Database Server.

Thanks & Regards,

Rajiv

I am afraid you won't like the answer but the Report Viewer control assumes a direct connection to the Report Server web service. It looks like in your situation, you need to install RS on the application server. A split deployment scenario is also an option (RS middle tier on the application server, while the catalog is on the database server) but you will need two licenses. Finally, in case you wan't to get innovative, try implementing an HttpHandler on the application server that would intercept SOAP and URL requests generated by the ReportViewer and forward them to the database server. I haven't done this but it should be possible. If you decide to try the last option, please post your findings here.|||

Hi,

Thanks for your reply. I am working on the approach that you have suggested. I have created an HttpHandler which is deployed as an Application Gateway on the Application Server. In the process request method of HttpHandler I am using HttpContext to get the current request and create a new request to the reporting server.

I am using windows XP, IIS 5.1. , Microsoft Visual Studio 2005 and Asp.net 2.0.

Scenario : Request an ASP.NET Page from the Webserver... which in turn makes a new request using HttpHandler which invokes Reporting Server.

"abc.aspx" page includes report viewer control. This page is deployed on the web server. The following properties are set for ReportViewer Control.

ReportVwrObj.ServerReport.ReportServerUrl = HTTPHandlerURL;

ReportVwrObj.ServerReport.ReportPath = ConfigurationManager.AppSettings["WebReportResults"].ToString ( ); //report file name and path.

Using Http Handler : I was able to sucessfully create a new request once i get the request from web server........However, I came across few issues related to Response.

Below is the sample code implemented in the ProcessRequest Method of HttpHandler.

public void ProcessRequest ( HttpContext context )

{

context.Response.ContentType = "text/plain";

//Url Request

RequestURL = "http://MahineName/reportserver";

///create the web request to get the remote stream

HttpWebRequest objRequest = ( HttpWebRequest ) WebRequest.Create ( RequestURL );

//objRequest.Credentials = CredentialCache.DefaultNetworkCredentials;

NetworkCredential nt = new NetworkCredential ( "Username", "Password", "Domain." );

objRequest.Credentials = nt;

objRequest.KeepAlive = false;

boolException = false;//clear exception

objResponse = ( HttpWebResponse ) objRequest.GetResponse ( );

if ( ( objResponse.ContentType.ToLower ( ).IndexOf ( "html" ) >= 0 ) || ( objResponse.ContentType.ToLower ( ).IndexOf ( "javascript" ) >= 0 )

||( objResponse.ContentType.ToLower ( ).IndexOf ( "xml" ) >= 0 ) )

{

//this objResponse is HTML Content, so we must parse it

StreamReader objReadStream = new StreamReader ( objReceiveStream, Encoding.Default );

//Uri test = new Uri(strRemoteUrl);

strContent = "";

strContent = objReadStream.ReadToEnd ( );

context.Response.ContentType = objResponse.ContentType;

context.Response.Flush ( );

context.Response.Write ( strContent );

///close streams

objReadStream.Close ( );

objResponse.Close ( );

}

context.Response.End ( );

}

In the above code, I have created a new httpwebrequest to forward the request to the reporting server. For the newly created request i get the response and flush it . I came across the below error while following this approach.

Response is not well-formed XML.

Data at the root level is invalid. Line 1, position 1.

Any Clue on this ?

|||Use a listener such as tcpTrace or SoapUtil to capture the request from the HttpHandler by redirecting to http://MahineName:8080/reportserver. It looks like the XML got distorted or something.

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 newbie

hi,

i'm a newbie in using report viewer and having a tough time now building a web app in c# and asp.net.. hope someone can help me on this.

i'm using VS2005 and RS2005.

i've tried looking at the sample RssNewsReader but i have problem running it. error message : Could not find type 'RssNewsReader.ChannelInfo'.

i think this is because i don't have system.ComponentModel in the reference and i don't have this dll file in my system as well, therefore i could not add it in.

i tried looking at sample in odetocode website but the sample wasn't built using VS2005, so i encounter problems changing the syntax.

can someone direct me to a sample i can use?

i want to know how to set parameter and filter the result according to the parameter selected and display it on the report viewer (using web form).

thanks!

I have exactly the same question

I would be happy to see some example of using the report viewer

control used in 2005.

|||

eyalkz,

you can get samples from www.gotreportviewer.com and check out Visual Studio Report Control forum. More discussion on this topic there.

hth

report viewer keep showing report is being generated

hi all,

i developed a web app with embedded report viewer to show the reports (server report). everything works alright. i created a setup file to install it at another machine. everything looks ok except that when i want to view the report, it will always show 'Report is being generated' for a very long time when it only takes a few seconds when i view it on report server.

i found the following warning in event viewer (application):

Process information:

Process ID: 4976

Process name: aspnet_wp.exe

Account name: DWPC1\ASPNET

Exception information:

Exception type: SoapException

Exception message: System.Web.Services.Protocols.SoapException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found > Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found

at Microsoft.ReportingServices.WebServer.SessionStarterAction.CreateExisting()

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

End of inner exception stack trace

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

Request information:

Request URL: http://localhost/AirForce/Reserved.ReportViewerWebControl.axd?ReportSession=icwhpl55jbfwm355yxxw152i&ControlID=56545a8d-aaa2-4050-b66e-3a18d3c931d8&Culture=1033&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&Interval=539000

Request path: /AirForce/Reserved.ReportViewerWebControl.axd

User host address: 127.0.0.1

User: DWPC1\dwdvpr

Is authenticated: True

Authentication Type: Negotiate

Thread account name: DWPC1\ASPNET

Thread information:

Thread ID: 7

Thread account name: DWPC1\ASPNET

Is impersonating: False

Stack trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2005.Execution.ReportExecutionService.GetExecutionInfo()

at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetExecutionInfo()

at Microsoft.Reporting.WebForms.ServerReport.TouchSession()

at Microsoft.Reporting.WebForms.SessionKeepAliveOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)

at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Please help. No specific error message to help me debug. i have no idea what's wrong.

Thanks!

I saw this message quite often before I've tried this approach: before trying to change the report path or HistoryId do the following:
ReportViewer1.ServerReport.ReportPath = "";
ReportViewer1.ServerReport.Refresh();

However, I still get sometimes the message "ASP.NET session expired" or something similar.

report viewer keep showing report is being generated

hi all,

i developed a web app with embedded report viewer to show the reports (server report). everything works alright. i created a setup file to install it at another machine. everything looks ok except that when i want to view the report, it will always show 'Report is being generated' for a very long time when it only takes a few seconds when i view it on report server.

i found the following warning in event viewer (application):

Process information:

Process ID: 4976

Process name: aspnet_wp.exe

Account name: DWPC1\ASPNET

Exception information:

Exception type: SoapException

Exception message: System.Web.Services.Protocols.SoapException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found > Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found

at Microsoft.ReportingServices.WebServer.SessionStarterAction.CreateExisting()

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

End of inner exception stack trace

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

Request information:

Request URL: http://localhost/AirForce/Reserved.ReportViewerWebControl.axd?ReportSession=icwhpl55jbfwm355yxxw152i&ControlID=56545a8d-aaa2-4050-b66e-3a18d3c931d8&Culture=1033&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&Interval=539000

Request path: /AirForce/Reserved.ReportViewerWebControl.axd

User host address: 127.0.0.1

User: DWPC1\dwdvpr

Is authenticated: True

Authentication Type: Negotiate

Thread account name: DWPC1\ASPNET

Thread information:

Thread ID: 7

Thread account name: DWPC1\ASPNET

Is impersonating: False

Stack trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2005.Execution.ReportExecutionService.GetExecutionInfo()

at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetExecutionInfo()

at Microsoft.Reporting.WebForms.ServerReport.TouchSession()

at Microsoft.Reporting.WebForms.SessionKeepAliveOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)

at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Please help. No specific error message to help me debug. i have no idea what's wrong.

Thanks!

I saw this message quite often before I've tried this approach: before trying to change the report path or HistoryId do the following:
ReportViewer1.ServerReport.ReportPath = "";
ReportViewer1.ServerReport.Refresh();

However, I still get sometimes the message "ASP.NET session expired" or something similar.sql

Report Viewer dlls on web server

I need to get the report viewer files onto my production web box. I know I can run the report view install to get the files registered in the GAL. Unfortunately running an install on a 'productionalized' box will be a big to do for the administrators in my company. Can this issue be resolved simply by copying out the files to the bin directory of the site in question? Are there any pro/cons to doing it this way (other than I'd have to do this for every site that needs reporting).

thanks,

MP

Keep the dlls local to your project by putting them in the bin folder. This should not have any negative effects. I have a report app accessing the dlls way. Cheers!

Report Viewer Date Format..

Hi,

I have done a report using the reportviewer page, and placed it in my web application and the last thing i need to do is sort out the date formats, primarily to a UK time..

1. I want to display todays date on the page, but in the format "Wednesday, 4 April 2007". I seem to be able to get the various parts needed, but not put them together in the same textbox, could someone help me with the concatonation?

=WeekdayName(Weekday(DateValue(DateString)))

2. All the dates extracted from the database are in the format MM/dd/yyyy, and i need them to be in dd/MM/yyyy, i am completely lost on how to do this...

any help will be much appreciated, even if you could tell me where i can go look up the syntax for this markup

regards

Chris

check this for all posible date formats:http://msdn2.microsoft.com/en-us/library/8kb3ddd4.aspx

|||

cheers for the link, don't know why i was having such a hard time finding it..

anyway, all sorted now, in the end i didn't do any sort of concatenation, but instead just used =FormatDateTime(Now(), 1)

and the other days were as easy as putting dd/MM/yyyy HH:mm in the fomrat field, nice

cheers!

sql

report viewer control

Hi,
i'm a newbie in using report viewer and having a tough time now
building a web app in c# and asp.net.. hope someone can help me on
this.
i'm using VS2005 and RS2005.
can someone direct me to a sample i can use?
i want to know how to set parameter and filter the result according to
the parameter selected and display it on the report viewer (using web
form).
Thanks,
Eyaltry here
http://www.devx.com/dotnet/Article/30610/1954?pf=true
Regards,
Jimmy M Joy
--
Microsoft Application Developer
"EyalK" wrote:
> Hi,
> i'm a newbie in using report viewer and having a tough time now
> building a web app in c# and asp.net.. hope someone can help me on
> this.
> i'm using VS2005 and RS2005.
> can someone direct me to a sample i can use?
> i want to know how to set parameter and filter the result according to
> the parameter selected and display it on the report viewer (using web
> form).
> Thanks,
> Eyal
>|||Try this http://www.gotreportviewer.com/
"Jimmy M Joy" wrote:
> try here
> http://www.devx.com/dotnet/Article/30610/1954?pf=true
> Regards,
> Jimmy M Joy
> --
> Microsoft Application Developer
>
> "EyalK" wrote:
> > Hi,
> >
> > i'm a newbie in using report viewer and having a tough time now
> > building a web app in c# and asp.net.. hope someone can help me on
> > this.
> >
> > i'm using VS2005 and RS2005.
> >
> > can someone direct me to a sample i can use?
> >
> > i want to know how to set parameter and filter the result according to
> > the parameter selected and display it on the report viewer (using web
> > form).
> >
> > Thanks,
> > Eyal
> >
> >sql