Written by Joe Cocuzzo, Senior VP of Report Writing Services - iatricSystems
If you did output in the picture, change the data type of all fields to INT instead of FREE or DATE or other non numeric value. If you are doing output in a trailer region, you may need to add FNC=LST to the field to prevent automatic totaling. Putting DAT=INT on a string works fine and removes the quotes, but if it is in a trailer and is a string you will get wacky output as magic will attempt to sum the strings in the trailer.
If you have any fields with DAT=DATE you need to change them to computed field that puts the date in the correct format and use DAT=INT on that field,For example, change @hire.date to xx.hire.date
xx.hire.date
DAT=INT
VAL=%Z.date.out(@hire.date)
The reason you have to do this is that as soon as you change a date field's type to INT, it will come out YYYYMMDD
