CR XI: change data source for field 1

[dh42891]

I'm trying to create some sort of template in CR XI. I have a report formatted exactly how it needs to be. However, I need to be able to change the data source for a handful of fields from one table to another table in the same database. The field names will be exactly the same, just the table name changes. I'm relatively unfamilar with the intricacies and nuances of Crystal Reports so I'm not sure where to go from here. I can work around this outside of Crystal Reports, but that would require changes to our source tables I'm not ready to make just yet. Thanks,

dylan

 

[RobbieB]

You need to add the table that you want to change to. Then you will need to delete the current fields and replace them with the ones from the table you want to use.

 

[dh42891]

Thanks Robbie, but I've gotten that far; I was hoping to replace the source of the fields already in the report with the new table- without deleting or moving the fields and formulas. If I have to manually delete and replace each field, I have to go through the very finicky process of sizing and positioning each field again. So instead of removing and re-adding fields, I want to be able to redirect the field to a different table. Thanks again,

dylan

 

[lbass]

Try using database->set location.

-LB

 

[dh42891]

Beautiful! You have no idea how much time you just saved me!

dylan

 

[RobbieB]

If the fields were coming from exactly the same table just in different data sources (i.e. Live database vs. report data base) than you could just change the data source (as LBass mentioned). But because you want to use the same field but from a different table, I do not believe there is any other way to do deal with that than to delete the "old" and replace with the "new". With formulas it is easier. You just go into the formula and replace the "old" field with the "new" field. No need to delete and replace on the report.

 

[synapsevampire]

LB has explained the supported method within the Crystal designer.

If all things are equal and you're using ODBC, change the ODBC.

Please remember to include basic technical information, such as the database type and th connectivity being used.

-k

 

[synapsevampire]

Robbie: No, just use Set Location and point to the other table.

-k