After upgrading from Seagate Info 7 to CE9 - CR9 issues 1

[bessebo]

OK,
Here is my issue and it is very frustrating. I am modifiying a report that was originally created using the deisgner in Seagate Info. Now I am using Crystal Reports 9. All I want to do is add a table and link it in the same database in Crystal Reports 9 so I can add a field to the existing report. It makes me add a new connection for the same database and it shows in the Database Expert now as 2 different databases even though they are the same. I can link the new table no problem and the report runs in the designer.
My issue comes when I go into Crystal Management Console, Objects and pull up the report. Then I go into the database tab and want to put in the password so that the user doesn't have to do this. I now see 2 data sources which are the same and when I try to put in the password for one of them and click on Update it will not stick. Then when I run the report from ePortfolio it fails with an incorrect logon information error. What am I doing wrong? This is crazy and it is such a simple change...

Regards,
Bessebo

 

[bikejockey]

CR 9 database handling changed considerably. This is what I would try first.

Open the report in Crystal Reports, select Database/Set Datasource Location.

I would Select Create a New Connection, Select the proper connection. Now you need to select each table one at a time in the Current Data Source window, then explore to the table in the bottom window and select it, Then use the Update button. Do this for all the tables, then do a Database/Verify Database.

Then you should be able to add the new table with the Database Expert. The scroll box on the left may be positioned to the create new connection part of the tree. You want to scroll it to the top and select current connections.

 

[bessebo]

Thank you , Thank You, Thank You. I thought I was going crazy when it wasn't obvious to me how to avoid the problem of creating another data source. Your solution worked like a charm. Yes, I agree CR9 datbase handling did change considerably...

Thanks Again,
Bessebo