Report Viewer w/SQL DB not showing in viewer?

Morning,

This is driving me daft!

I designed the report and attached to the DB. The Query builder shows me data coming back.

I then attached the local report to the viewer, on a web page, and ran it in the IDE.

The webpage comes up witht the toolbar accross the top but no report! No error msg either.

When I step thru the codebehind. I added in a Try catch just so I could see what was going on.

The viewer object has the rpt and the SQL cmd thats in the report. So it seems to be connecting correctly. But no report. Not even just the text objects. I just get a blank viewer!

Help please!

Thanks

Deasun

I am having the same problem. I am using an object data source and the report is completely blank. I can export the data to excel or acrobat but I don't understand why I can't see any data at all on the page.|||

Did you specify a percentage as the height or width of the viewer? I saw another post that said there was a bug in the viewer so I changed my dimensions to pixels and it works.

|||

I must try that.

More then likly I have %s on it.

I have seen this bug in a few objects to date. One that comes to mind is the Infragistics Tree controll.

Specify a % W/L and it does some strange stuff sometimes. Put in a pixel size or none at all and it works fine.

Thanks

Deasun

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 Service not showing up in WSS 3.0 Central Admin

I installed the Reporting Service for Share Point just fine but when I go to central admin I do not see the reporting service section. Any Ideas?Can you check under site settings -> Site collection features and see if the feature is activated?|||

Install SharePoint.exe and Install SharePointRS.msi with same user ?

|||I had installed the reporting service and share point as different users on the server. I reinstalled RS using the same login as was used to install WSS and I now have the Report Service in Central Admin. THanks for all of the help.

Report Server problem

I am using SQL Server 2000 reporting services.I created a report in VS.net 2003.Report is showing in preview pane properly.But when i press start it gives a messege "No Reprot Server was found at http://localhost/ReprotServer".
Is reprot server required for the reprot.whats other alternative to show the report on web browser?

Hi,

By default, the reportserver's URL is http://localhost/reportserver.
When installing reporting services on a named instance this will be http://localhost/reportserver$instancename.

First check in your IIS what the exact name of the reportserver is. Also check that IIS is started. Try to open the reportservice.asmx file.

If this works, check the reportserver path in the Project Properties. Make sure it is the same as in your IIS.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi Geert,

Thanks! for your reply..

Here the problem is that report server component is not installed on my computer.Also

during installation this component is not showing in the list, only client component is showing and get

installed.Although I have IIS, SqlServer 2000 and framework 1.1 installed properly.I am unable to find how to install report server

and report manager.

pls help me out...

Thanks again!!

|||

Hi,

Wich Service Pack does your SQL Server has? In able to run Reporting Services on SQL Server 2000, you must at least have SP3 installed.

Also, the reporting server must be installed separately. Although, it is licensed with your existing SQL Server.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi Geert,

Thanks! for the support...

Now the server component is showing with report server.But after installation it gives error messege

'The ReportServer windows service can not start.You do not have sufficient privilege'. ans the it rollback the installation.

Although i am logged in as local system account.

i also read somewhere on net that Use of the Local Service account for the ReportServer Windows service is not supported.

i am not on any domain.pls suggest me what to do.

thanks

|||

Hi,

The account that you specified in the setup must have the rights to run a service (Logon as a service permission). This can be set in the windows policy. Maybe that this is not set. I know that for 2005, the setup gives the necessary permissions but for 2000 it can be that you need to do this manually.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||Thanks Geert!!.. its installed successfully...

Report Refreshing Issue - Showing Old Data

Hello, Just wondering if anyone can provide a solution to the following:
You are viewing a published report and the underlying data changes. If you
click on the refresh button in Internet Explorer, the report still displays
the old / unchanged data (clicking on the RS refresh button returns the new
data).
Is there any way to force Internet Explorer to get a new copy of the report
with the new / changed data, when the IE refresh button is clicked. This is
important as the report is being executed from an application and the users
wonâ't have access to the RS refresh button. Thanks.Make sure, that on the report manager, clcik on the properties of the report,
and on the execution tab, make sure it is set to "Always run with most recent
data" and "Do not cache " option is checked.
Also try using the refresh button in the report managertool bar, and not the
IE refresh button. This refresh button is present next to to the export drop
down list. (Will be visible after you run the report).
Apart from this cant think of anything else. Hope that helps.
"Maple Tardis" wrote:
> Hello, Just wondering if anyone can provide a solution to the following:
> You are viewing a published report and the underlying data changes. If you
> click on the refresh button in Internet Explorer, the report still displays
> the old / unchanged data (clicking on the RS refresh button returns the new
> data).
> Is there any way to force Internet Explorer to get a new copy of the report
> with the new / changed data, when the IE refresh button is clicked. This is
> important as the report is being executed from an application and the users
> wonâ't have access to the RS refresh button. Thanks.