Formula preventing a report from being exported to Excel

[Extrmdressage]

Hi,
I have a formula in Crystal 8.5 that calculates annual salary for our staff. Here is the formula: ({EComp.EmHourlyRate}) * tonumber ({@Hours2}) * tonumber ({@Weeks})
The emhourlyrate field is the staff's hourly rate. Hours2 is Left ({@Hours},2 ) and Weeks is Right ({@Hours},2 )


Unfortunatly, I get the error 'failed to export the report. Error in MS Excel export format dll' when I try to export this to Excel. Does anyone have any suggestions on what I could try to get this to work? I appreciate any feedback. Thank you in advance.

 

[satinsilhouette]

Does it export if you comment the formula out?

Thanks so much!
satinsilhouette

 

[Turkbear]

Hi,
Have you tried exporting using the 'data only' option for Excel exports?



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Extrmdressage]

Where is the 'data only' option for Excel?

 

[HowardHammerman]

In the more recent versions of Crystal (Version XI and Version 2008) a page of options comes up when you try to export to Excel. If you are using an older version you might try to export to a *.csv. I think the tonumber() function might be giving you a problem. Try VAL()

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[Extrmdressage]

()VAL worked, thanks HowardHammerman