This content has been marked as final. Show 4 replies
I am combining two reports in a one to many entry format. The end reports looks like:
MANAWA 4849.53 0.00 0.00 MANAWA 77 DAVE 2425.87
MANAWA 364 DENNIS 2423.66
ARCHER 3555.18 0.00 0.00 ARCHER 77 DAVE 1777.59
(the dashing are just to get the report to look correct)
In order to get get this output I have created the following summary:
/size[list][*]Filter: Default Filter
Key fields: Account, Dealer, Overfund Fees, Other 3, Other 4, Total
Item fields: Dealer #, Dealer Name, Agent Number, Agent Name, Amount
Summary fields:[/size][/list]The fields Overfund Fees, Other 3, Other 4, Total, Amount are all numeric, but when I export the summary to Excel these fields are character.
Any ideas how to get the numeric fields to stay numeric? I know it has to do with the way I built the summary, but I haven't figured out how to get my report in any other way.