I am using Crystal Reports XI with Clarity CA Universe and am having trouble with table(s) linking, particularly, unable to properly link two tables ( CA Clarity Universe) using the standard Links Option. I try and link [Project Current Facts] to [Project - Investment Info] by using Project Id --> Id but i am not getting the correct results. When I pass the Project Name parameter, I get multiple results as opposed to a single Project Name based on Id. If I add an additional Link by Project Code, then it works but another filter no longer works (OBS).
Not sure if anyone has experienced this problem before or knows of better ways to link tables in Link Options for CR XI. Please note that this is as CA Universe Specific enquiry, not connecting to the transactional database direct.
Any tips/hints would be much appreciated. Many thanks in anticipation.