danagin
Member
Remove 0\'s in database output
I'm running a report with database output to a flat file and all of my numeric fields are filling out with 0's to 32 characters. For example, I have a field that is Math Numeric(2), and it contains the number 1. On the database output I get "000000000000000000001.0000000000". It looks like this is happening for all numeric fields on the report. Anyone have any ideas?
Just to note, I'm working with R47042C, but I'm having this happen with other similar reports.
I'm running a report with database output to a flat file and all of my numeric fields are filling out with 0's to 32 characters. For example, I have a field that is Math Numeric(2), and it contains the number 1. On the database output I get "000000000000000000001.0000000000". It looks like this is happening for all numeric fields on the report. Anyone have any ideas?
Just to note, I'm working with R47042C, but I'm having this happen with other similar reports.