Welcome, Guest. Please Login.
05/18/24 at 05:15:24
News:
Home Help Search Login


Pages: 1
Send Topic Print
Report Editor - Format field display (Read 722 times)
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Report Editor - Format field display
07/13/04 at 09:02:06
 
How do you get a field to display with less zeros  
after the decimal point?  Our price fields display four zeros after the decimal point, and I'd like to make them just 2 zeros. Smiley
 
Thanks,
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Danimal
Member
**




Posts: 59
Gender: male
Re: Report Editor - Format field display
Reply #1 - 07/13/04 at 09:30:46
 
The report editors are basically WYSIWYG - which means that the fields are not easily formatted like Crystal Reports or the such.  Until the report editor eats its WheatiesTM, you might want to try the following in this situation:
 
  • Make a backup & open your form.
  • Make sure your (4-decimal) price field is right-aligned.
  • Create a rectangle.
  • If the default fill (brush) color isn't white, change it.
  • Change the rectangle border (pen) color to white.
  • Position the rectangle over the top of the last 2 digits of the field on the right.
  • Save your changes.
  • When printed, the invisible box should cover the unwanted decimals.

 
Not pretty by any means, but it works!  HTH   8)
Back to top
 
 
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Report Editor - Format field display
Reply #2 - 07/15/04 at 09:07:16
 
Cheesy
Ya know, this does work!  A creative idea, Danimal!
 
Thanks,
 
Back to top
 
 

Val Feehan
  IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: Report Editor - Format field display
Reply #3 - 07/15/04 at 12:32:28
 
Great, I'll try that on one of my forms that the people don't like the 4 decimals-I think it's quotations.  
 
It would be good if the fields could be set to the decimal length desired.
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
Pages: 1
Send Topic Print