Hope this is something simple I am missing. Did a search here but didn't see this...

 

I am connecting to a SQL Server 2005 DB via OLEDB in Crystal Reports XI. I can connect, see the tables and add through the Databse Expert. However, when I click on the Link tab there is nothing there except the opening dialogue saying I need to link etc. No table diagrams etc. If I exit. I can see and use the tables in the report but obviously they are not linked.

 

Am I doing something wrong? Missing a setting? I have used Crystal before with other databases and didn't have a problem.

 

Thanks for any help including "dummy you need to...."

 

Bob

 

No such thing as a dumb question, just dumb people lol! To answer your questions....

 

1) No I can see the entire tab. It is blank, not even a window inside (white area where tables would appear). All I have is statement at top "Linking is needed to match records of one table with corresponding records of another table." followed by the Open, Cancel, Help at the bottom.

 

2) If I close then get the message "Your current link configuration contains multiple starting points etc....."

 

3) Version is 11.0.0.2269 which is not R2 but does have SP2 applied.

 

Bob

 

 

What I am trying to do is demo reporting off of the Data Warehouse. I am using Crystal because our customers have it. The demo does not go into the mechanics of creating the actual report so if I get there some other way that is ok for now. Course if someone asks how did you do that....

 

Thanks for the help. Possibly someone else may have encountered this and will chime in.

 

Bob