Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prevent range parameters from rounding

Status
Not open for further replies.

xcmuchip

Programmer
May 31, 2001
70
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
 
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
 
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
 
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
 
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.
 
Here is what I ended up doing...

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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top