May 31, 2018 at 10:42 am
The report appears fine ( Takes 1.27 minutes for the data to appear )
That is fine. But the user needs the data saved in an EXCEL sheet.
So I tried the Export option to EXCEL waited there for many minutes and never saw the data appear in EXCEL.
TRIED CSV option that failed as well.
Any ideas how you can help.
May 31, 2018 at 11:09 am
mw_sql_developer - Thursday, May 31, 2018 10:42 AMThe report appears fine ( Takes 1.27 minutes for the data to appear )
That is fine. But the user needs the data saved in an EXCEL sheet.So I tried the Export option to EXCEL waited there for many minutes and never saw the data appear in EXCEL.
TRIED CSV option that failed as well.Any ideas how you can help.
Go to the Reporting Services log file as it should indicate any errors when rendering.
Go to your SSRS directory and then to Reporting Services\LogFiles. Files are named with ReportServerService_<datetime>.log
What is available for rendering would be in the rsreportserver.config file. That file would be in the SSRS directory\Reporting Services\ReportServer
Check the <render> section for the extentions.
If an extension fails to load, that gets logged in the Reporting Services log file when SSRS starts up.
Sue
May 31, 2018 at 11:15 am
How wide is this data as well? If it's 187,326 rows, but only 3 columns wide, that's not a lot to do. If, on the other hand, it's 187,326 rows and 1,264 columns wide, well, that's a totally different kettle of fish.
What have you done to try and troubleshoot the problem yourself so far as well?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 31, 2018 at 11:21 am
And I should add another thing to check... the times for each phase(retrieval, process and rendering) of the process would be in the ExecutionLog3 view.
I would guess that most likely there is something in the SSRS log file though.
Sue
May 31, 2018 at 11:42 am
Sue_H - Thursday, May 31, 2018 11:21 AMAnd I should add another thing to check... the times for each phase(retrieval, process and rendering) of the process would be in the ExecutionLog3 view.
I would guess that most likely there is something in the SSRS log file though.Sue
if I just pull as a report ( HTML ) then it takes 1.27 minutes. Comesout fine.
Try to save it to excel-- runs for ever and fails
The number of columns = 23
What is the log that i have ti check and where can I find this log ?
May 31, 2018 at 12:47 pm
When you successfully export other reports to Excel, are they in .xls or .xlsx format? Excel.xls files have a 65,000 row limit, and for many years that was SSRS's export option.
May 31, 2018 at 1:28 pm
mw_sql_developer - Thursday, May 31, 2018 11:42 AMSue_H - Thursday, May 31, 2018 11:21 AMAnd I should add another thing to check... the times for each phase(retrieval, process and rendering) of the process would be in the ExecutionLog3 view.
I would guess that most likely there is something in the SSRS log file though.Sue
if I just pull as a report ( HTML ) then it takes 1.27 minutes. Comesout fine.
Try to save it to excel-- runs for ever and fails
The number of columns = 23What is the log that i have ti check and where can I find this log ?
Go to your SSRS directory and then to Reporting Services\LogFiles. Files are named with ReportServerService_<datetime>.log
Sue
June 1, 2018 at 10:29 am
doug.brown - Thursday, May 31, 2018 12:47 PMWhen you successfully export other reports to Excel, are they in .xls or .xlsx format? Excel.xls files have a 65,000 row limit, and for many years that was SSRS's export option.
One would hope that as the OP has posted in the SQL Server 2012 forums, that that is what they are using. 🙂 SSRS 2012 exports to xlsx, unlike 2008 and prior, which exports to xls. Of course, that doesn't mean you can't add xls as an export option; but if you're exporting a dataset with so many rows that would seem silly.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply