I have a report I created in Crystal Reports 2008. I want to export the results into an Excel template that contains formulas for two columns in the template. Is this possible? Any help would be greatly appreciated. Thanks in advance.
At least one of the 3rd-party Crystal Reports Desktop Scheduling tools listed at: http://www.kenhamady.com/bookmarks.html provides that functionality. It allows you to replace named ranges inside MS Excel spreadsheets with values of formulas with matching names. The file can then be saved to a new dynamically named file and emailed as part of a bursting process.
The advantage of this technique is that you can keep and control all elements in the template spreadsheet. For example, the template spreadsheet may have formulas, conditional formatting, hidden columns, and macros.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.