Report field format

Hi
I have an invoice report where I want to display material number is displayed with comma separator. To display the number without comma separation, I have used the following “value format” but it is still display the numeric code as “800,254” where I want to display it as “800254”

RetailInvoice1.retailInvoiceLines2.material.docNumber 

with format string #

note there that RetailInvoice1 = first band and retailInvoiceLines2 = 2nd band for invoiceLines

Hi,
In my test report I have adjusted Format string = “#” and commas are not printed for big values anymore.
Try to point the field in the “{Band}.{Field}” format - do not define the whole path - just the band which comprises the field.

Thanks you. It’s working now.