Friday, December 5, 2008

ACT! Reports published to Excel

At the recent ACT! by Sage conference at Coolum. Ben Lederer showed us how to add Microsoft Excel as an output option for reports.  It involves a small registry change. The knowledge base article #14690. See it here

It also adds output as Tiff and HTML as other options.

You will find though that the standard reports in ACT! are not particularly useful as it embeds all the content of the report into excel. This includes images and other text and formatting that you probably don't want if your purpose is to perform calculations in the spreadsheets that you create. You'll see what I mean.

If you want to perform calculations on report data I'd recommend making very simple purpose built reports with no formatting


No comments: