February 11, 2013 at 3:38 am
Hi all,
first of all, we have SQL Server 2008 R2 installed, currently in version 10.50.4000.0
We are having issues with a specific report, for which the end-user never gets to see any result on the Report Manager.
When I check the logging in the ReportServer database, more specific via ExecutionLog3, I see the demand of the user, with Status = 'rsSuccess' after about 5-6 minutes.
This problem doesn't happen all the time, most of the time the report works fine, only some moments it doesn't...
The report has 5 datasets, which all retrieve their data from Oracle.
It doesn't retrieve much data, the SQL's are well defined and checked by our DBA, they all work as they should.
They all contain group by statements, so only necessary data is returned from the db.
Sorting also happens in sql, so there are no sort actions on the report...
So the report simply contains 5 tablix, all shown on a seperate page, without anything special...
I am really stuck with this, it is a crucial report for the business, and we can't afford that sometimes, it just doesn't show-up...
Anyone has had this before, anyone any ideas ?
Many thanks for any help !
August 24, 2015 at 3:26 pm
I'm having a similar issue. Blank report with status rsSuccess.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply