Export from Crystal Reports is too small
Posted by Todd on November 13, 2001 9:53 AM
When I export a one-page report into Excel from an application that uses Crystal Reports, the report looks fine, but when I "Print" or "Print Preview", the whole one-page report is crammed into the upper left corner. The Scaling is automatically set to "Adjust to 10% of orignal size".
I've tried exporting several different versions of the Excel file, and all seem to do this. The software manufacturer claims innocence (surprise!). I end up having to go to Page Setup and change it every time I do an export.
I created a macro that "cleans up" extraneous cells and data and tried to add a line that changed the page formatting so it fits 1 page x 1 page, but it seems to give me an error message each time I run it - (can't recall it here, maybe save for a later post).
Any ideas? Thanks in advance...