Hi John, I have a table in my system that contains a field for the part number, the mask and the quantity of decimals for the unit price. Just before printing I scan the records and convert the unit price to allt(str(unitprice,9,decimals)). The value of decimals is taken from the table mentioned. I set the quantity of decimals for the total to the largest of the unit price decimals. I align the unit price manually in the designer. Hope this helps.
----- Original Message ---- From: John J. Mihaljevic <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2007 11:51:07 AM Subject: RE: Decimal-aligning data in reports Thanks much, Andrew. I considered that, but would prefer to not show trailing zeros where they're not necessary. For example, in Quantity. We wanna see "123" - not "123.0000." Doable any other way? > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:profoxtech- > [EMAIL PROTECTED] On Behalf Of Andrew Stirling > Sent: Thursday, November 29, 2007 9:46 AM > To: [EMAIL PROTECTED] > Subject: Re: Decimal-aligning data in reports > > John > > Format the numbers to have the required decimal places ie if your unit > price was 0.052 it would display 0.0520. Make each of the fonts non > proportional. > Then you can place the text boxes the way you want. > > HTH > > Andrew Stirling > 01250 874580 > http://www.calcpay.co.uk > HMRC Accredited UK payroll program > > > John J. Mihaljevic wrote: > > Hi all, > > > > I have the following three fields listed one underneath the other in > a > > column: > > > > Quantity > > UnitPrice > > ExtendedPrice > > > > Examples of those values may be: > > > > 100 > > 0.0525 > > 5.25 > > > > We don't want the numbers left-aligned or right-aligned...we want > them to be > > aligned by the decimal. Is there a way to automatically choose data > in a > > report form and have it align by the decimal point, or do I have to > move > > each field manually until they're properly aligned? > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
