Alan: How many records is your query pulling on average and what you have set for the max number of records that can be returned on the server? If your way lets you get around the record limit set on the server, that's an argument in favor of doing it your way.
Is your CSV created and do your reports run during standard business hours or after hours? Depending on those answers, there's a potential argument there in terms of not impacting performance from your users' perspective. Do you know what's at the heart of your management's concern about data "purity"? I mean, have you ever had them define their concern really, really specifically and tie it to a specific business concern in the present as opposed to a vague concern caused by some weird problem that they pulled their hair out over 15 years ago trying to solve that they still remember? If it's a case of a couple of records being in the system that aren't in your .csv, due to a time lapse between when the CSV is created and when the reports are created, is there some compelling business reason why management can't wait for the next run of the reports to see those few records or else just check the production system? If you can get a concrete sense of their concern, you could always lay out ALL the pros and cons of both ways and ask, "Is this measly X records per week that you're concerned about *really* worth all the things we would have to have to trade (or risk) in order to get that?" Sometimes people need a little help to see the tradeoffs. Good luck! Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA [email protected]<mailto:[email protected]> ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Longwing, Lj Sent: Monday, March 25, 2013 3:29 PM To: [email protected] Subject: [EXTERNAL] Re: Running many (different) Crystal Rpts from same dataset.. pls back me up! ** Well, other than the fact that going directly to the db well in many instances not give you what you want in a remedy sence, there is the fact that your method pulled from the same db, and has the same data, so yours could be argued to be more efficient, and just as pure On Monday, March 25, 2013, Alan Truelove <[email protected]<mailto:[email protected]>> wrote: > ** > I am running 6 Crystal Reports (70 of each) from the same SQL dataset (saved > as a CSV text file) extracted from Remedy (using API, and getting only the 11 > fields I need (out of 160..) and 1 week's worth of data out of several years.. > This works just fine. > Management insists that going to the original database for each of the 420 > reports is somehow 'purer' (takes much much longer...) > Any comment welcome, in confidence of course... > _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: > "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
