Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

Can I change a datasource tablename w/o having to manually replace all the references to it.

I have a CR10 .rpt file which  has a datasource with the tablename of "goober".

The report uses a variety of fields from this table, referenced, as typical, by goober.fieldname1.

I now need to change the datasource from a table named "goober" to a table named "widgets"

The widgets table has exactly the same structure.

I want all the field references in the .rpt file to change from goober.fieldname1 to widgets.fieldname1

Is there a way I can edit the .rpt file in CR (or even in a hex editor!) to change the table name so I don't have to delete and then re-create all the field references manually?

Tom
0
tfield98
Asked:
tfield98
1 Solution
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
You accomplish this in the Report Designer by:

1)  Navigating to Database|Set Datasource Location
2)  Drilling through the Current Data Source section until you highlight the table you need to change
3)  Drilling down through the Replace with section until you login into the new datasource and highlight the table you'd like to use
4)  Click the Update button

You may need to repeat this for multiple tables.

~Kurt
0
 
tfield98Author Commented:
Thanks SO MUCH!  That's exactly what I needed.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now