Print Page | Close Window

changing datasource without re-creating report

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=15106
Printed Date: 22 Apr 2025 at 6:16am


Topic: changing datasource without re-creating report
Posted By: Gatekeeper
Subject: changing datasource without re-creating report
Date Posted: 07 Dec 2011 at 5:14am

I now have two seperate sql databases instead of one to run my Crystal Reports from. My 10 to 12 reports run off three different sql views as the data source off these sql tables.Should I just manually type in the new N' <datasource> in my sql views when I want to run the new second set of (duplicate fields/duplicate format) reports?..... thereby not having to change the sql view data source name in the Crystal Reports themselves (which can be irritating to actually accomplish)

 I tried making duplicate sql views and typed in the new "N' <project>'. Easy. Then I started changing the database source in my "save as" duplicate Crystal Reports.But Crystal Reports isn't smart enough to know to change all the formulas (oldprojectname.field needs to be newprojectname.samefield)?I would essentially have to re-create the entire report again and re-type all formulas even though I want the same exact fields and layout? Too much work. Easier to run first set of reports then edit the sql view "project" name N'<>


Replies:
Posted By: DBlank
Date Posted: 07 Dec 2011 at 8:13am
you can update teh source by
Database menu >Set Datasource location
highlight what you want to change in the 'current data source'
select the 'new data source' in the lower window
click update
 
you can rename the table in the database >Database expert screen if you need to


Print Page | Close Window