cancel
Showing results for 
Search instead for 
Did you mean: 

Setting a new database location problems

Former Member
0 Kudos

I've not ran into this before. I'm pointing a report to a new location , but I'm not seeing the report data. The other odd thing is that after pointing to the new location, if I show the SQL, it is still looking at the old location. Yet another odd thing is when I'm setting locations, I don't see one of the sub reports. It's still in design view, but not in the connections screen.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Try to run the seperate queries for the for both db locations and see whether u are getting data for it or not.

May be there is no data in other location that is why it is not visible.

Regards,

Misra P.

Former Member
0 Kudos

Hey Mark, when you are pointing to the new datasource, CR does not change the name.

also, you will need to change datasource in the subreport as well.

Answers (1)

Answers (1)

Former Member
0 Kudos

Ok, I got the report working but I don't know why Crystal didn't complain about it. The new location had a field changed in the table (a linking field between tables at that). It had an underscore added by another programmer (recordid was changed to record_id). Crystal didn't complain and I even did the option to make sure the database was up to date and it claimed everything was fine. Evidently it refused to set to the new location without giving an error and was reporting no problems with the fields because it was looking at the old location.