Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export to Excel Error - no data found

Sam.KSep 21 2008 — edited Sep 21 2008
Hi All,

I am having a problem with the "export to Excel" link for one of my reports. Athough I have created tens of reports that look same as this one and they all export to excel properly, but this report returns no data " no data found" in the excel report! I have checked almost every element in the report and could not find out the reason why it is exporting no data !

Does any of you have a clue?

Thanks,
Sam K

Comments

Arie Geller
Hello,

Please check if the following example, from Denes, can help you - http://apex.oracle.com/pls/otn/f?p=31517:117

Regards,
Arie.
Sam.K
Arie,

I checked that link out , but this is not really what I am looking for. I have created over 100 reports that has the export to excel link and they all work fine EXCEPT this particular report. I tried to compare the properties of this report with other reports and they look same!! I am interested in only knowing if this is possible and knowing the possible reasons behind that.

Thanks,
Arie Geller
Hello,

>> I checked that link out , but this is not really what I am looking for

The ‘No Data Found” issue, while exporting to CSV is not a new issue. Denes blogged about it, and in the example he also explain some pre conditions that can lead to this kind of problem. If you’ll search the forum you’ll find many threads on this problem.

If you created so many working reports in the past, and you can’t figure out the problem, you can appreciate the fact that it’s almost impossible to single out the only one that isn’t working, without seeing it at all. Can you recreate the report, with the problem on apex.oracle.com?

Regards,
Arie.
M Tajuddin
Hi Sam,
Does your query return any column in report region?
Is the table in the same schema?

If you have other reports working fine, it could be a little issue that causing trouble. Did you try eliminate the report and do fresh one again?

Thanks,

Tajuddin
http://tajuddin.whitepagesbd.com
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 19 2008
Added on Sep 21 2008
#apex, #apex-discussions, #excel, #export
4 comments
629 views