Can you update a data table, without losing your columns in your report in Crystal Reports?

crystal-reports crystal-reports-2008
RLH picture RLH · May 30, 2013 · Viewed 19.6k times · Source

I have a Crystal Report that contains numerous fields and functions that all reference one SQL Server data view. Recently, I've had to make a copy of the underlying SQL data view and make a few modifications. I need to use my new data view as my data source within my Crystal Report.

My problem is that I need to keep the original data view, without changing it's name, but I need my Crystal Report to reference the new data view.

Is there an easy way for me to update my report's data source without having to update all of my columns and formulas? Otherwise, I'm starting from scratch and might as well create a new report, which I'd prefer not to do.

Answer

PowerUser picture PowerUser · May 30, 2013

Yes. I haven't used CR in a while, but I used to do that frequently. There's actually a built-in option to change your data source and remap any fields it can't find in the new data source.

Check out #1 of Todd Watson's answer: How do I point Crystal Reports at a new database

Related questions

How do I point Crystal Reports at a new database

I have a Crystal Reports 2008 user that has over 100 custom developed reports. The reports all query Sql Server databases (SQL 2005). This database server is getting replaced with a new system (running SQL 2008 R2) and the existing databases will be moved …

Read More
Crystal Reports Custom IsNull Function

I am trying to create a custom IsNull Function in Crystal Reports; the function must act the same way as the IsNull Function in MS SQL Server. I want to specify a field, and if the field is null, then …

Read More
extract raw SQL query from a Crystal Report .rpt file

I've got an .rpt file that I did not write and can find no documentation about. I want to be able to review the SQL that is generated from this report so that I can figure out, well, what data …

Read More