Joined: 15 Oct 2007
Location: United States
Online Status: Offline
Posts: 10
Topic: changing datasource without re-creating report 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'<>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
