I am using Crystal 10. I have two tables that contain identical fields but different formats. First is 11 digit number field on each but one have preceding zeros and other has preceding spaces. Other field is 7 digits one with preceding zeros text field and other is number field with nothing preceding. If anyone has an idea on how to join these fields.
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Table Joins through ODBC
- Thread starter dscoiho
- Start date
You will have to write a formula field to get the right or left (whichever it is) 7 spaces of the 11 character field, then use a subreport and link the 7 character field to the new formula.
In crystal you cannot link on a formula field, hence the need for a subreport.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
In crystal you cannot link on a formula field, hence the need for a subreport.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
What is the database you are using ?
If you have the ability to create views, stored procedures , queries etc... I would work on the database to create views with the fields in the same datatype and format.
HTH
Gary Parker
MIS Data Analyst
Manchester, England
If you have the ability to create views, stored procedures , queries etc... I would work on the database to create views with the fields in the same datatype and format.
HTH
Gary Parker
MIS Data Analyst
Manchester, England
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question