Tuesday, December 28, 2010

Crystal Reports : Exporting to Excel cleanly

To export to Excel, click on the little "envelope" icon on the toolbar.
Select Destination: Disk File
Now drop down the Format list box. You'll see two choices for Excel. One should read "Excel", the other, "Excel (Data Only)"
In general, Crystal does a great job of exporting to a spreahsheet. However, it does take some pretty serious liberties with cell spacing and sizing. But if you're looking to act upon the data in the spreadsheet after exporting, you should try the Data Only format, as it will export none of the cosmetic touches of the report.


Paulo said...

Discovering somebody who will focus on making reimbursements is difficult. A great many people go to their family, however in the event that relatives additionally have low FICO ratings, or are near the breaking point of their obligation to-wage proportion, this road is shut. check cashing

Thomas pedro said...

These limitations can be forced by the previous proprietor of the property, or the township relying upon application. For example, you may be restricted with respect to what sort of house you can construct; or what materials you can utilize. Cash Advance

xumeiqing said...

michael kors outlet online
ugg australia
adidas nmd
fitflops sale clearance
nike free flyknit
ugg outlet
hermes birkin
ed hardy
cheap jordan shoes

marko said...

I found the ideal place, a place that was sufficiently far out in the nation to make tracks in an opposite direction from the buzzing about of city life, yet not sufficiently far to make a lengthy drive to the city. https://www.usacheckcashingstore.com/san-diego