Forum Discussion
error emailing report in report server
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
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.
The link you shared does not work. can you resend it