Visual Linking Expert putting in bad links at add

When I add table using the Visual Linking Expert, as soon as I click Add, it puts the talbes in but as always I am required to completely delete the linking and start over.  Why does it put bad linking between the tables on first add?
LVL 1
dba123Asked:
Who is Participating?
 
frodomanConnect With a Mentor Commented:
"Why" is kindof a loaded question... ;-)

The simple answer is that it *tries* to be helpful by linking tables that it thinks you probably want to link.  I agree that when this happens though it's a pain because often it doesn't link correctly and you have to do it over again...

frodoman
0
 
vidruConnect With a Mentor Commented:
You can turn Smart Linking off in CR 8.5 by going to File > Options > Database tab > uncheck 'Auto-SmartLinking' in the Advanced Options section.

For CR10 (and maybe 9), it's a Registry hack:
http://support.businessobjects.com/library/kbase/articles/c2014792.asp

-dave
0
 
ebolekConnect With a Mentor Commented:
That is why I dont use tabkles in my reports. I create stored procedures and i can take careof the linking in the proc. I recommend you dothe same. If something changes you dont ned to change it in the report. You goto the proc an dchange it. Crystal will understand the chnage and will ask to fix it when the report is run next time.

Stored procs are cleaner and faster.

But you can do whatever you want. It is a free country

:)
Regards
Emre
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
dba123Author Commented:
Yea, I have a problem right now where I'm trying to fix a few reports someone did using stored procedures.  All other reports that are not using sp are working fine.  Maybe you can help me with that problem when I put in a new post.  We are using VBScript, ASP, and generating reports that way by passing parameters to the report which is something totally new to me...I have never had to deal with Crystal this way.
0
 
dba123Author Commented:
I think stored procedures are overkill for Crystal.  I mean how often would you reuse a sp for another report...reports vary and one sp returns a certain set of results of which other reports may not need....most reports I know are very tailored as in what fields it needs.  Maybe if one sp returns let's say 10 fields, and you create another report to also use that sp, maybe  you don't have to use all 10 fields returned if you only want to use 5 of the fields....reuse of sp...don't know if you can do that.
0
 
frodomanCommented:
dba123,

I agree with your last posting.  Often an SP is overkill in my opinion [ no offense Emre - as you say, it's a free country :-) ]

I use SP's when it's necessary because the table relations are too complex for Crystal or when it takes too long to build a report.  SP's have their place, but for me it's only when the complexity requires it - most of my reports use tables or views.

You *can* re-use SP's as you questioned, but I'd have to ask "why" you'd want to pass all that extra data around that you don't really need?  Just use two SP's instead would be far more efficient.

0
 
frodomanCommented:
Dave (vidru) -

Thanks for that link - I knew I'd seen it somewhere before but I couldn't find it.

frodoman
0
 
bdreed35Commented:
dba123:

When you are in the Visual Linking Expert, is automatically linking by Name or by Key?  I think the typical default is by Name and that may be what is causing the problem for you.  

In CR9, you can change the linking by hacking the registry:
http://support.businessobjects.com/library/kbase/articles/c2012286.asp

BTW, what CR version are you using?  It helps people answer your question if you provde that up front.
0
 
ebolekCommented:
If you have any problems with sp , will happy to help you

Gald to help

Regards
Emre
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.