export formulas to excel

[kap1]

I'm using version CR9 with Access 2000 and VB6. I need to export a report that contains formulas to excel and have the formulas show up in excel. The excel document also needs to be formatted so I'm using the option of MS Excel 97-2000 instead of data only.

For example:
The report contains the following fields:
Field: TotalWages = Wages + Tips + Bonus
Field: MedicareTax = MedicareTax
Field: TotalIncome = Total Wages - MedicareTax
After exporting to excel all fields including TotalIncome are just the values and not a formula.

Is this possible?

I read the Business Objects knowledge base article c2011861 - Exporting summary fields as Excel worksheet functions
The article states that formula field formulas cannot be exported but database summary fields can. Are they talking about a summary field in an Access Query? I haven't been able to find an example.
Thanks for the help.

 

[dgillz]

A summary field in Crystal will show up in Excel as a Sum(). For example:

Sum(A2..A2132)

The above would be an example of the excel expression equating to a crystal summary field on 2131 records, after exported to Excel. You can also do this on Average, Minimum, Maximum, etc.

You cannot create excel formula fields when exporting from Crystal other than these summary fields.

One question: Why are you exporting to Excel? Most people export to Excel because they are very comfortable with it and can use Excel to further manipulate the data. If you take the time to design your Crystal report with the FINISHED output, rather than relying on further manipulation of the data in Excel, there will never be a need to export it, and it will save you time in the long run.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[kap1]

Thanks for the answer.
Here is my situation and why my customers will want to export the report to Excel.

The customer has entered data into a VB application. As part of the application I want to provide the user with a standard report based on that data. However, the customer will want to run different scenarios on the data from the application. I don't know what variations they will want to use. The customer does not have Crystal Reports just my VB application. By exporting the basic report and formulas to Excel they can plug in different numbers quickly and easily to see how they effect the bottom line without having to change the "real data". Also I don't know all of the different ways they will want to run the data.

Does a newer version of CR allow formulas to export?

Kim

 

[dgillz]

no.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz