Report - Values with different number of decimal places

[npa3000]

I have a form for creating offers and the user enters the items with their prices. Τhen there is a report where there is a "mirror" of the actual form.

Normally the prices have 2 or 3 decimal places.

The problem is that I don't know how to make it work with both cases as even with the "Decimal places: Auto"setting it doesn't work.

Any tips?

Thanks

 

[plog]

I don't know how to make it work

Huh? What's that mean? You need to explain what 'make it work' means. Perhaps demonstrate your issue with sample data.

 

[npa3000]

Maybe I didn't analyze it well.
The user can, for example, enter a price of €1.23(2 dec digit) or €1,305(3 dec digit).

In the report, I want the prices to appear as they are in the form.
I just can't find the right settings to make it work for both cases at the same time because either it will display it as 2 digit or 3 digit...

 

[Pat Hartman]

You have to set it either as auto which will misalign the columns and look funny OR fixed as three which nicely aligns everything.

 

[plog]

What is the field type of your data? I setup a table with a decimal field, input values with various numbers to the right of the decimal and then made a report. They all show the exact number I input them as.

Can you upload a sample database to demonstrate?

 

[June7]

Why does one value show period and other show comma? Is this a text field?