Print Page | Close Window

Updating Data Source to Command

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16986
Printed Date: 21 Apr 2025 at 2:47am


Topic: Updating Data Source to Command
Posted By: tdavenport
Subject: Updating Data Source to Command
Date Posted: 09 Jul 2012 at 6:31am
Crystal Reports 11.5 SP2

I have a set of reports that call on multiple tables. There are multiple formulas in these reports as well.

I need to change my reports to use a SQL command instead of calling on the individual tables.

Typically if I use "Set Data Source Location", I can change Data Sources and the fields and formulas automatically update. But this is when I'm just changing the Database (or DB location). In these cases, the table and field names are still the same.

What I'm trying to do it change the actual query. Which means that the table names change.. ex from "Computer" to "Command". The end result is that I loose all of my field mappings.

Is there a way to get CR to take my new Source query (SQL command) and update all of the fields and formulas to use the new fields?

-------------
Any and all suggestions are welcome.


Replies:
Posted By: hilfy
Date Posted: 10 Jul 2012 at 7:11am
I would create the command and temporarily leave your tables in the report.  You'll then have to manually change all of the formulas and the objects on your report to look to the command.  Once that is done, you'll delete the tables, leaving just the command.
 
I know it's a lot of work, but there's no tool like "Set Data Source Location" that will do this for you.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window