Prevent range parameters from rounding

[xcmuchip]

I have a range parameter that allows entries such as ".01555". When the range value is displayed on the report, it displays as ".02". The correct records are being pulled into the report, but I want to show the user EXACTLY what they entered as the parameter. I tried to format the max of the parameter value, but it didn't work.

Not a major problem, but a bothersome one. TIA

 

[dgillz]

This is a format issue. Format the paramter field, and any formula field(s) based on it, to have 4 decimals. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[xcmuchip]

Format the field where? I tried it through default values button. It doesn't allow past 2 decimal places. I tried to change the max of the range to text and it still rounds. Could you be more specific?

TIA

 

[dgillz]

In the design window, drag the parameter field onto the report, and format the field from there - Rt click, format field, etc.

I'm pretty sure you have to drag the field onto the report before you can format it, although I honestly have never tried to format a field that was not already there.
Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[xcmuchip]

Figured it out. I had been using the ToText function in my formula to display my parameter range. I was trying to use a format string. Instead, I changed it to specify # of decimals to carry it out to. Now it works. Thanks for your help.

 

[xcmuchip]

Here is what I ended up doing...

"% Difference Range: " & ToText({@MinDifference},5) & " to " & ToText({@MaxDifference},5)