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 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