Numeric Output format Excel issue
I've made a .rtf report but i have the following problem:
In the database the field is a number (20,4) but excel sets the decimal values only to two. (the column on excel output is set as general)
Example:
database excel
10,0000 10
10,0200 10,02
10,0030 10,00
10,0050 10,01
10,0005 10,00
It not eliminates the rest of decimal values, it only hides them and i have to click in the increase decimal button in order to show - in excel.
I do not want this field to be text because is a mandatory requirement from the client in order to make filters and ordering ans sum column values,etc