Crystal Reports - 'Database Connection Error'

[mjmcdonagh1]

Hello,

Not sure how many Crystal Reports experts are out there but i'm looking for a bit of help if anyone could so oblige!

Basically our Data Analyst/Crystal Reports Wizard/DBA/Oracle or Oracle etc left the company about a month ago and as she is yet to be replace i've been asked to fill in the gaps short term. But I know basically nothing about reporting/data analysis. So apologies if i'm just being dim...

Anyway - i've been asked for a report that is needed urgently and i've hit a snag. Fortunately the report they want is very similar to a report that has previously been used they just need Margins added on to it, but when i've gone to edit it I realised that a couple of the Tables it used no longer exist. So I removed these tables and added in the tables which replaced these (these tables have the same fields as their legacy counterparts) and added the appropriate links. When trying to run the report sat through all of the errors telling me fields had the wrong names and updated them.

Now that i've done all that, when I try to run the report I get two pop ups. The first says "Failed to retrieve data from the database" and when I ok it, the second appears and says "Database Connection Error: If tables are already linked then the join type cannot change".

It's Crystal Reports XI we're running and the report only looks at one SQL Database.

I'm completely at a loss here, so any insight would be much appreciated.

Thanks,

Matt.

 

[mjmcdonagh1]

Hey,

After a bit of Googling I found solution to this!

Basically I was a bit to over zealous when linking the new tables. I made a circular link eg

TABLE1 FIELD1 - TABLE2 FIELD1
TABLE1 FIELD1 - TABLE3 FIELD1
TABLE2 FIELD1 - TABLE3 FIELD1

I just removed one of these links and it all works fine! Huzzah!

I'm not sure if this actually makes any sense or not. If not let me know, but this definitely fixes it!

Thanks,

Matt.

 

[mjmcdonagh1]

Hey,

After a bit of Googling I found solution to this!

Basically I was a bit to over zealous when linking the new tables. I made a circular link eg

TABLE1 FIELD1 - TABLE2 FIELD1
TABLE1 FIELD1 - TABLE3 FIELD1
TABLE2 FIELD1 - TABLE3 FIELD1

I just removed one of these links and it all works fine! Huzzah!

I'm not sure if this actually makes any sense or not. If not let me know, but this definitely fixes it!

Thanks,

Matt.

 

[ZionZA]

You going to mark yourself for best answer? lol

 

[mjmcdonagh1]

You going to mark yourself for best answer? lol

Haha! No, just thought i post the resolution in case anyone else comes across!