Crystal Reports - Linking tables from Timberline SM Data to Timberline Data Source - one table has a prefix while other does not

SUGGESTED

I am trying to create a crystal report which will allow me to reprint a batch of open/unpaid SM invoices using information from two different tables, one from the Timberline SM Data and the other from the Timberline Data Source. 

I have one table in Timberline Data Source which is ARA_ACTIVITY_STATUS that has an invoice number of "SM123456" and the other table in Timberline SM Data that has an invoice number of "123456" referring to the same invoice. The ARA_ACTIVITY_STATUS adds the "SM" and I can not link them going through the standard linking options. Is there any way to link these?

I have tried creating a report with a formula to remove the SM from one of the tables so that it can be linked to a subreport. However the subreport (the actual invoice) that I want to print is already using subreports and the second tier subreport is not printing data that is needed.

I am open to any suggestions.

Parents Reply Children
No Data