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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER