Link to home
Start Free TrialLog in
Avatar of tkwadmin
tkwadmin

asked on

Crystal Report Link tables

Hello,

I am creating a crystal report and am running into challenges in that my unique ID for both tables is not exactly the same. Unfortunately,  the customer number is preceded by 00 in the other table. The ID's are the same outside of that and there are always 2 zeros.

Table1
ABCDEF

Table2
00ABCDEF

Is there any way to strip the two zeros prior to Crystal making the link?
SOLUTION
Avatar of chaau
chaau
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tkwadmin
tkwadmin

ASKER

Thanks everyone for the suggestions. I will be trying this out today and will update.
Of course you have 2 places to change/convert data:

1- At database end
2- At Reporting end

You have to see possibilities where you can change easily. In my opinion its easy to change at reporting end using formula but this way normally use to display or do some calculation. But if you can not change at crystal report end then second option is at database end. At database end you can either change your SQL query which is making/preparing the table or if its not possible then you can create a view on that table (By removing leading 00 in SQL query for view) and then design/fetch data at crystal report end using this view.
I hope you understand the story.

Thanks
Habibb