Tonumber formula; exporting to Excel

[cheningham]

I have a field in my database that is a string field, but contains a number. I want to have this number listed in a column which includes other "real" number fields, and then be able to export this column along with others, to Excel for further manipulation. I can get the formula to behave and the fields show up properly, but

a) I cannot create a total field in Crystal (String is non-numeric -maybe I'm naive (ie. not the programming type) but didn't tonumber cure this?)

and...

b) Get "Failed to export the report - error in MS Excel export format DLL" when I try to export this out.

Any suggestions would be most welcome

Thanks

 

[synapsevampire]

Did you create a formula to convert it, and then do your total (insert sumary) on this formula?

Formula: @MyTotal

if not isnull({myfield}) and trim({myfield}) <> &quot;&quot;
tonumber({myfield})
else
0

Probably some overkill in this, but it should work.

The export error is more ominous...can you export to other formats? Export other reports using Excel?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com