link on partial match
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16628
Printed Date: 21 Apr 2025 at 12:14pm
Topic: link on partial match
Posted By: carstowal
Subject: link on partial match
Date Posted: 29 May 2012 at 10:29am
when the shipper (packlist) is created an invoice ID is applied by the system
SHIPPER.INVOICE_ID
an example might be SHIPPER.INVOICE_ID 164331 on SHIPPER.PACKLIST_ID PK250999
additionally users are allowed on the receivables side to manually create invoices without having created a shipper. this is how we create credit memos
our users will take the an Existing Invoice_ID to which a credit memo is related to and add cm to the end
manually creating a new Receivables.Invoice_ID of 164331cm in the system
so both 164331 & 164331cm exist on the Receivables side, however the cm is not linked in any way to the Shipper db
Is there a way to link SHIPPER.INVOICE_ID and RECEIVABLE.INVOICE_ID based only on the first 6 characters so that RECEIVABLE.INVOICE_ID 164331 & 164331cm both link back to SHIPPER.INVOICE_ID 164331
|
Replies:
Posted By: kevlray
Date Posted: 29 May 2012 at 12:01pm
|
Do you want to group, filter, display? Using a function where it returns the left six characters is easy to set up ( LefT({SHIPPER.INVOICE_ID},6) )
|
Posted By: carstowal
Date Posted: 30 May 2012 at 3:10am
|
I want to LINK the fields in the table based on the left 6 characters
|
Posted By: DBlank
Date Posted: 30 May 2012 at 4:17am
|
use a command object to get the data set and create a field with the left 6 characters which can be used to join
|
|