Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Failed to save as Excel file
- Thread starter eletuw
- Start date
CharlesCook
Programmer
First a few dumb questions:
Did the report return data?
Is the save format switch on?
CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining
Did the report return data?
Is the save format switch on?
CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining
- Thread starter
- #3
CharlesCook
Programmer
Is this something you can make happen at will?
CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining
CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining
I've run into this same problem before. Here is the work-around that ADP posted on their website.
Issue:
I am attempting to export a rather large report to Excel and the amount of rows shows at the bottom. The data never saves from the report. If I attempt to export to a .csv file, the report results in all commas, no data. We have located a macro that will get the report to report the data successfully, but I was wondering, is this a limitation of the software? Are there any stated, accepted, or documented limitations of any type for the size or amount of data that ReportSmith will export without some sort of modification?
Error Code:
Solution:
While we fixed the 32,000 record limitation in 3.12 and 4.2, we are still using Excel 4 as the Excel format when performing a save as operation. Excel 4 has a record limitation of 16,000 records. That is why the operation does not complete. To avoid this problem, we recommend using the "DIF" data interchange format. This is actually the preferred file format to use since it has no row limitation. And it opens directly into Excel.
Current versions of Excel are limited to 64,000 records per worksheet. By using the DIF format, you will be able to get around this. According to Microsoft documentation that we have read, if you use a DIF file format that has more then 64,000 records, the Excel import wizard should break the file up into multiple worksheets within a workbook.
Issue:
I am attempting to export a rather large report to Excel and the amount of rows shows at the bottom. The data never saves from the report. If I attempt to export to a .csv file, the report results in all commas, no data. We have located a macro that will get the report to report the data successfully, but I was wondering, is this a limitation of the software? Are there any stated, accepted, or documented limitations of any type for the size or amount of data that ReportSmith will export without some sort of modification?
Error Code:
Solution:
While we fixed the 32,000 record limitation in 3.12 and 4.2, we are still using Excel 4 as the Excel format when performing a save as operation. Excel 4 has a record limitation of 16,000 records. That is why the operation does not complete. To avoid this problem, we recommend using the "DIF" data interchange format. This is actually the preferred file format to use since it has no row limitation. And it opens directly into Excel.
Current versions of Excel are limited to 64,000 records per worksheet. By using the DIF format, you will be able to get around this. According to Microsoft documentation that we have read, if you use a DIF file format that has more then 64,000 records, the Excel import wizard should break the file up into multiple worksheets within a workbook.
- Thread starter
- #6
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question