redirected report now broken :(

[pelajhia]

I have a report which I developed several months ago and it has been running fine. (CE/CRv10)

I recently took the production version of this report and tried pointing it to our test environment to update it since the underlying view is being changed.
I could no longer see the views, not even the schema name I was looking for.
Two things have changed that I am aware of: I have applied some crystal patches to my pc and my userid has been changed. I was given a new db log on and granted read rights to the public schema which I can see. I was told the views I need should be availble to anyone w/access to 'public'; this is an Oracle 9i db. I do NOT see the tables under public, just millions of other things.

Setting the database options in Crystal Designer to look for 'Owner Like' the schema I need allows me to see the correct tables/views and so I have redirected the report.
The report has a subreport going to a different database; I had to change the db owner option again to see those views and redirect the sub report.
When I run the report now, however it takes FOREVER, I let it run overnight and it did return the correct data.
If I run the main report and suppress the sub, that part runs fine.
If I preview just the sub, that part runs fine. If I then run the whole report, THAT runs fine, but if I then CLOSE the CR Designer and reopen it and the report, reconnect to the db, the report hangs again with 'accessing database' at the bottom of the window.
Just to be clear here: the main report goes to a table, the sub goes to a view which has recently been 'recompiled' by the dba. I can log onto the two db's and access/query the table and view I am interested in without prefixing any schema/owner name.
Any ideas about what could be going on here? Thanks!

 

[kskid]

I don't have CR10 but I thought the CR Designer is not usable in CR10. From what I have seen on the posts is to copy the SQL statements form the Crystal Designer and paste it to an Add Command in Cr10

Correct me if I am wrong.


-LW

 

[pelajhia]

I have made a mistake in calling CR Developer version CR designer - oops! I am not using designer but I am using Crystal Reports, v10.

 

[kskid]

Then I would click on Database -> Verify Database to see if any changes occurred to the DB

 

[pelajhia]

yes, changes certainly have occured - that is why I am doing this in the first place. I have since re-verified several times to make sure that is not a problem, but I just get a 'database is up to date' message.
The view in the subreport is changed on our test db.

 

[kskid]

Are you verifying BOTH the main report and subreport on the Test DB? If you verify the main report on the production DB, then the production verify will also apply to the subreport.

That's happen to me so I just thoought I would pass it on.

 

[pelajhia]

Yes, I am verifying both parts of the report.
I have decided that the report might just be corrupt somehow, it is behaving so oddly.
It is not too complex a report so I just rebuilt it and it is working fine.
I hope the problem is not related to re-directing to another datasource, because I'll have to redirect this one to production in a few days. So far all is well. Weird stuff. Thank you for your suggestions !