cancel
Showing results for 
Search instead for 
Did you mean: 

Replace quickly tables/views

Former Member
0 Kudos

Hi,

I am using Crystal Reports 2008 SP3; I have some reports that need to use new tables and/or views. How can I quickly replace e.g. a old table with a new view - I also have to adapt the joins.

It seems that I have to go first to Database -> Set Datasource location; there I can select the table I would like to change and select the new one in the lower part of this dialog window.

Then I have to go to Database -> Database Expert -> Links to draw the new join.

Is there a faster way or more secure way?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

former_member292966
Active Contributor
0 Kudos

Hi Steve.

This is pretty much the only way to do this. You could change the report to use a view. Have all your tables and linking done in your view. If you want to change tables, change them in the view and no changes in the report would be required.

Good luck,

Brian

Answers (0)