Forum Discussion

miwundu's avatar
miwundu
Helper I
2 years ago
Solved

error 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 ...
65
  • miwundu's avatar
    miwundu
    2 years ago

    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's avatar
miwundu
Helper I
2 years ago

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