Page 1 of 1
Report Designer - Comma in Invoice Number
Posted: 03 Jun 2011, 06:31
by CFormby
Hi All,
I have created a new invoice in Report Designer but my invoice number has a comma in it. (1461 showing as 1,461).
How can I remove the comma?
Thanks
Re: Report Designer - Comma in Invoice Number
Posted: 03 Jun 2011, 09:20
by klocky
Hi
you need to change the formating in Report Designer on the invoice layout. Go to Report Designer, click on the particular variable you want to change, then in properites click on formatting and you can change the appearance
Re: Report Designer - Comma in Invoice Number
Posted: 07 Jun 2011, 00:20
by CFormby
Hi, I've tried a number of different combinations in the Numeric Tab but they do not seem to work.
My current setting is:
Style: Value
Part: Whole
Format: (1.1)
Max/Min Decimals: 0
Ticked Suppress if not a number
Ticked Display leading zero
What settings do I need to remove the comma?
Re: Report Designer - Comma in Invoice Number
Posted: 07 Jun 2011, 10:38
by klocky
Hi
sorry I have noticed that you can't remove the comma
Re: Report Designer - Comma in Invoice Number
Posted: 16 Jun 2011, 15:43
by brucedenney
On the numeric tab tick the box that says use custom thousands separator and edit the separator and make it nothing