Showing Duplicates but starting with the second character not the first (string)

[TMasterK]

Hello,

I have Crystal Reports 14. I have a list of invoice numbers with associated data. This is the string field used for invoice number {APINVOICE.INVOICE_NO}

The list includes duplicate invoice numbers but not in the traditional sense of a true duplicates.

For instance say I have this invoice number;

2522895

Then I create that same invoice number 2522895 BUT put a space in front of the leading number which is '2' in this case.

I need to only show duplicates starting with the second number so it DOES NOT count the space in front.

I have grouped my report by invoice number. I'm just not sure how to accomplish this?

ps. The space is used because the ERP system does not allow true duplicates so in order to get around this we use a space in front of the invoice number. This is only being done because we have to split certain invoices across two facilities/plants.

Thank you!

 

[lbass]

You can group on this formula: trim({table.invoiceno}).

-LB