Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

TMasterK

MIS
Jan 6, 2020
1
US
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!

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

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top