4 Replies Latest reply: May 15, 2014 9:59 AM by cardealers _ RSS

    Summary - Key Fields

    cardealers _

      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.