Forum Discussion
miwundu
Helper I
Helper Ierror emailing report in report server
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 ...
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
