Unable to link Unique Identifiers

[maryjo2001]

i have two tables one is a decode table and the other uses a variation of the unique identifer along with other information. however i am unable to figure out how to link them in crystal. it is easy to do in access as i can create a function to delete the irrelevant numbers. for example table A has a field value of 677311019.001 and the corresponding field in the decode is 6771019. the 31 is a value that can change as it is the customers unique id. and the .001 is the number of transactions. so my problem is that the last extentions can change as well as the 31. how do i link them? in access i created a function that counted the customer id spaces and deleted everything up to that point and the same concept to delete everything up to the '.' how do i do that in crystal?

 

[rogar]

Can you create your query in access and store it there; then use the access query as your report data source?

 

[maryjo2001]

I can do this however then i will need to create a user group to access the area on the lan where the query will be stored. i did not want to have maintain that if it can all be done in crystal. do you know how to do that?

 

[Roadkill150]

You can do this in crystal through the use of a subreport with the second table. Create a formula in the main report of the similar field truncated to relevant digits then use this formula to link to the database field in the subreport Insert the subreport fields into the desired sections. This will of course slow your report down but it is a viable workaround. If numbers need to be summed or utilized in the main report inside formulas, then you can pass values to the main report using shared variables. Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com