Ausway
asked on
Business Objects Query Panel in Crystal Reports XI
Hi Experts,
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.
Kind Regards
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.
Kind Regards
ASKER
Hi, yeah, using Crystal Database Expert. Smart linking could not do the job. I used manual linking by key, link from project id to id.
Is smart linking off? If not turn it off it sometimes seems to activate at the worst times.
mlmcc
mlmcc
ASKER
Thanks. Turned off the smart linking, Still the same thing. I am using an inner join project id > id. Enforce Join To? Is that correct? The parameter passes to the projectdetails (project id) query and I want to match that to the project in project investments (id)
I have never used the enforce so I don't know what it does.
I suggested the smart linking off because I remember a report I did several years ago that had a similar problem and the problem was in how the tables were joined but I don't recall what the fix was.
mlmcc
I suggested the smart linking off because I remember a report I did several years ago that had a similar problem and the problem was in how the tables were joined but I don't recall what the fix was.
mlmcc
ASKER
Thanks. I will play around a little more. See if different link options will make a difference,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Kurt, great feedback! Proves what was suspected, Crystal limitations. I can freely do this in WebI.
I guess it is up to management now, either remove the fields from the report or attempt a second Universe query.
I guess it is up to management now, either remove the fields from the report or attempt a second Universe query.
I don't think this is relevant to your problem, but FWIW, the enforce options in the links control whether or not the query that CR generates will include tables that (in theory) aren't really needed. Normally, if you add some tables to a report and link them together, but don't actually use fields from some of the tables, CR won't bother to include those tables in the query, since you're not really using any data in them. The "enforce" options tell CR to include one linked table if the other one is used, even if you're not actually using anything in the first table. The directions (to, from and both) tell it which way to apply the "enforcing". From the CR Help:
> For example, if you create a link from TableA to TableB using Enforce To
> and select only a field from TableA, the join to TableB will be enforced,
> and the Select statement that is generated will include both tables.
James
> For example, if you create a link from TableA to TableB using Enforce To
> and select only a field from TableA, the join to TableB will be enforced,
> and the Select statement that is generated will include both tables.
James
Thanks James for that explanation.
Since I normally don't include extra table unless required to make the links ( then they are "used") I never looked into what the enforce options do.
mlmcc
Since I normally don't include extra table unless required to make the links ( then they are "used") I never looked into what the enforce options do.
mlmcc
I don't normally use/need them either (especially since almost all of my reports use stored procedures). Just one of those things that I got curious about, for whatever reason, and looked up somewhere along the line. :-)
James
James
ASKER
Thank you!
Why were those responses accepted as the solutions?
~Kurt
~Kurt
Those two posts were definitely not the solution. Skimming back through the posts, Kurt's first post seems like the closest thing to an actual solution (basically that you were running into a design limitation), and my previous post is at least somewhat relevant, since I was describing the "enforce" option that you had mentioned.
mlmcc, maybe you should re-open the question?
James
mlmcc, maybe you should re-open the question?
James
mlmcc,
I appreciate the note about the Request Attention link. I just think of that as something for the OP to use.
As for how to close the question, hopefully Ausway will re-close the question, but if not, Kurt's post # 35094286 seems like the "solution". My post about the enforce option, while hopefully informative, was basically just to explain that I didn't think it was related to the problem, so I don't know if I'd include it.
James
I appreciate the note about the Request Attention link. I just think of that as something for the OP to use.
As for how to close the question, hopefully Ausway will re-close the question, but if not, Kurt's post # 35094286 seems like the "solution". My post about the enforce option, while hopefully informative, was basically just to explain that I didn't think it was related to the problem, so I don't know if I'd include it.
James
Starting the automated closure procedure to implement the recommendations from the participating Expert(s).
- thermoduric -
EE Community Support Moderator
https://www.experts-exchange.com/questions/26903418/26-Mar-11-21-Automated-Request-for-Attention-Q-26875746.html
- thermoduric -
EE Community Support Moderator
https://www.experts-exchange.com/questions/26903418/26-Mar-11-21-Automated-Request-for-Attention-Q-26875746.html
DO you have smart linking turned off?
mlmcc