error emailing report in report server

[miwundu]

Hello,

I have 59 reports I run in my report server and they all run well except one.

When I click on the report in report server, it runs and displays the result but cannot export to excel. I have exported it to word and it worked but the format needed is in excel. The report size is 10MB. I have deleted the report recently and rescheduled it and got the same error message-(cannot be emailed refer to the remote server. The screenshot is some information I got from the log file.

I need some help to resolve this.

[miwundu · Accepted solution]

I am able to resolve this problem. The log file did not give helpful information but I discovered one thing when I tried to rebuild the report in other to isolate the problem. The report runs in SQL but in report builder it fails. The SQL query has a date field that consist of string and date data formats. It runs fine in Oracle but Report builder handles it differently. I formatted the date to String using TO_CHAR(Home_Date,'mm/dd/yyyy') and it worked. 
There are 45 columns in the report but this column was failing.
Select CASE WHEN inspection ='F' then Inspection
ELSE TO_CHAR(Home_Date,'MM/DD/YYYY') end as Date_Field
from Table. This solved the problem

[miwundu]

I have used this process but I still get the same error. I was able to construct the URL using my server url, uploaded it on report server but the error persist

[miwundu]

I have limited the report size to 2MB yet I get the same error. I have other  reports of size 21MB and they run successfully.

This report runs but cannot export by email or manually be exported in excel after execution but exports in word format

[Anonymous]

Hi @miwundu ,

Large reports with many pages or complex layouts may cause memory problems during export.
Verify that your system has enough available RAM to handle the report (especially since it is 10MB)

Add a link to the report to force SSRS to create the file instead of presenting it on the screen.
The link should point to: http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fYourReportName&rs:Format=excel

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[miwundu]

Can you share step by step process of how to add a link to the report?

[miwundu]

The link you shared does not work. can you resend it