Discussions
Categories
- 384.5K All Categories
- 2.5K Data
- 552 Big Data Appliance
- 1.9K Data Science
- 451.3K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 560 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.5K SQL & PL/SQL
- 21.4K SQL Developer
- 296.9K Development
- 1 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.6K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 166 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 531 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
Export to Excel Error - no data found
Sam.K
Member Posts: 627
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
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
Answers
-
Hello,
Please check if the following example, from Denes, can help you - http://apex.oracle.com/pls/otn/f?p=31517:117
Regards,
Arie. -
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, -
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. -
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
This discussion has been closed.