Convert multiple datasource onto one view

[OT2]

I cam using CR11 and an ODBC connection and would like to change the datasource on an old report, that was built by linking 9 tables, onto a single view.

I have tried the "Set Datasource Location" tool but it does not produce the results I would like and the report breaks on me once the changes are made, ie:

results I am getting:

Original Datasources New DataSource
table.one table.one(view1)
table.two table.two(view1)
table.three table.three(view1)
table.four table.four(view1)
table.five table.five(view1)
etc...


results I would like

table.one
table.two
table.three view1
table.four
table.five
etc...

 

[RobbieB]

If the tables are the same in the new data source you can use "set datasource location" on the "Database" tab and highlight your old table (s) in the top portion of the screen and update them with the new tables from the new datasource in the bottom of the screen. You will have to do it for each table individually.

 

[OT2]

Hi RobbieB, I tried that but the report breaks on me.

 

[elsenorjose]

OT2, what do you mean 'the report breaks on me'? Exactly what is happening? If you're not seeing the fields in your report anymore once you select the new data source, chances are the new source is missing some fields you had in the original. If the new data source/tables don't contain the same data you need in the report, then you have to map the data in your report to the new fields in your new data source. You do this when updating the data source. A dialog box should open asking you to remap the fields. If this isn't the case, please explain in more detail what you mean by the report 'breaking'.

 

[OT2]

Hi, once I make all the data source changes, the report runs forever and freezes up. I think my best bet is to start from scratch with my new view.