x

SSRS Report loading and showing Blank

the report is getting loading but displaying blank page after loading for 1-2 minutes in the client system through URL.But when tried in my system i am getting the report.The Client uses the same version of Internet explorer which we use. Can any one provide the solution?

more ▼

asked Mar 20 at 12:43 PM in Default

avatar image

sravan
0 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Run the code below on the ReportServer database. Try to identify the report and occurrence when it ran with blanks. Pay close attention to the "status" and "rowcount". In the status field you are look for rsSuccess and ideally a rowcount great than zero.

If they look ok, Try reviewing the log files typically in MSRS11.MSSQLSERVER/Reporting Services/LogFiles

 SELECT  C.Description , C.Name,
         EL.TimeStart ,
         EL.TimeEnd ,
         EL.Parameters ,
         EL.UserName ,
         EL.TimeDataRetrieval / 1000.0 AS [Data] ,
         EL.TimeRendering / 1000.0 AS [Render] ,
         EL.TimeProcessing / 1000.0 AS [Process] ,
         EL.Status ,
         EL.[RowCount]
 FROM    dbo.ExecutionLog AS EL
         LEFT JOIN dbo.Catalog AS C ON EL.ReportID = C.ItemID
 WHERE   EL.TimeStart BETWEEN '2017-03-11 06:00:31' AND '2017-03-30 23:00:30'

My initial guess would be permissions. But Let wait and see what you report back.

more ▼

answered Mar 21 at 07:54 AM

avatar image

sp_lock
10.8k 27 37 37

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x690
x2

asked: Mar 20 at 12:43 PM

Seen: 49 times

Last Updated: Mar 21 at 07:54 AM

Copyright 2017 Redgate Software. Privacy Policy