Issue with exporting as csv, xls (approx. 11000 rows)

[dlruop]

I have a report with 44 columns and 10816 rows. The data is shown in ReportSmith but is not exporting properly. When the report is exported or saved as a "csv" file, the file size equates to 476 KB (normally, it's about 7,000 kb). Also no data is populated on the exported file when opened in Excel.

FYI - ADP advised us that it is due to the number of columns. Though, we've always run the same report with the same amount of columns and just recently ran into this issue.

Any suggestions or solutions would be greatly appreciated!

 

[CharlesCook]

You could use a macro to do this. Check this out...

http://charlescook.com/PPS/ADP/ReportSmith/Enterprise/Creating-Interface-Files.pps

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[christimess]

Are you hosted and if so what drive are you trying to save to? If you are hosted and trying to save it to your personal computer, I would save it to the 'H' drive and them move it to your personal computer.

 

[RSHelp]

We really need more information like:
What ADP product are you using?
What version of ReportSmith are you using?

In general all of the ReportSmith v4.2.x versions below 4.2.2005 have various "Save As" issues.

If you are not on the newest ReportSmith (4.2.2005) and are an ADP Majors client you can download it from the ADP Support Site:

https://support.adp.com

If you are a PCPW v5.3 client then you can use an even newer version of ReportSmith, version 5.1.2.1 which is also available to ADP Majors clients on the ADP Support Site above.