Can I export to .xls with formulas?

[Erbium]

I have a sales report showing GL sales allocations by customer broken down by cost center. One of our account reps wants to take the exported spreadsheet for this customer, delete some lines / columns and have it automatically re-calculate the grand totals (which I currently provide as a value calculated by crystal before export, not a formula).

Is it possible to do an export where grand totals or sub totals are put as formulas instead of values, so the rep doesn't have to add the formulas themselves?

or is this too much for Crystal 8.5? can later version or other products do anything like this?

I know can do this if I write a program that reads a data file instead of using crystal, and produces a .tab file (named with extension .xls so it opens in excel automatically without import dialog). I simply put in say the 6th tab on 1st row '=sum(F2..F99)' or after the end of report I insert the actual row# to sum up in a similar string for a column or '=sum(b'+row#+'AB'+row#+')' to do row totals.

I just don't think this can be done in Crystal

 

[Madawc]

Have you tried writing the formulas as display strings in Crystal?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[dgillz]

Typically users want to export to excel for just this reason - to further manipulate the data. This defeats the purpose of crystal as a reporting tool.

Find out what the desired end output it, and have crystal produce it.

If the answer is that the account rep just wants to play with the numbers in excel, and your management has no problem with that, just export to excel in data only format (not sure if that is available in crystal 8.5). He can then spend hours and hours in excel, if that will accomplish anything.

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?