8

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.

RLH
  • 15,230
  • 22
  • 98
  • 182

2 Answers2

10

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

Community
  • 1
  • 1
PowerUser
  • 11,583
  • 20
  • 64
  • 98
6

Go to Field Explorer -> Right click on Database fields -> Go to Set Datasource location -> In lower section (Replace with) -> Go to My Connections -> Right click on New Dataset (go to Refresh).

Amit Bhagat
  • 71
  • 1
  • 2
  • 4