Lisa, I may be all wrong on this... but... I think the Stats that ARS reporting does only show up when you do a "*.rep" output. ( or maybe it is that when you select CSV,ARX that it only dumps the data?) At any rate... I think you need to not use "output to CSV" to see the statistics show up because the "Stats" output lines are not really in a "CSV format". If it did output the "stats" then the "CSV file" would be "broken".
Column1, Column2,...,ColumnN 000555,"Bob",...,"other stuff" 000556,"Bob2",...,"other stuff2" ... SUM: 123456 000557,"Bob3",...,"other stuff5" 000558,"Bob4",...,"other stuff5" ... However in "Report" format (rep) that kind of file would be fine. You just loose the quotes and comma separators between columns. So try the other output format and see if the calculations show up then. HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Wed, Apr 9, 2008 at 1:46 PM, Kemes, Lisa <[EMAIL PROTECTED]> wrote: > ** > > At this point, I'm not even using the window open feature. I'm simply > trying to create this report and the use the "Export To:" feature to export > it to a .csv file. > > Lisa > > > ________________________________ > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) > Sent: Wednesday, April 09, 2008 1:39 PM > > > To: arslist@ARSLIST.ORG > Subject: Re: Regular Reports > > > > ** > > > Yeah, Lisa, there are a few things you have to do to get it to spit the > output out. > > > > I don't remember all of them, and I'm at a new job with a new instance of > remedy, so I don't have any old code to look at. > > > > On your window open active link, are you specifying a run criteria? > > Report Type: ARSystem > > Name: <Path to report file> > > Destination: <wherever> > > Operation: You might need to try the different options here to see if one > works > > Location: Embedded (or Report Form) > > Entry IDs: <not sure here, don't remember using it> > > > > I remember that last time I did this, I could not get the data to spit out. > There was something little that I was missing. > > > > > > Thanks, > > > > Gary Opela, Jr., RSP > > Remedy Engineer > > Leader Communications, Inc. > > Best Product, Best People, Best PriceTM > > An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated Company > > > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa > Sent: Wednesday, April 09, 2008 12:19 PM > To: arslist@ARSLIST.ORG > Subject: Re: Regular Reports > > > > ** > > Thanks so much! But I just keep getting a blank report.csv file when I > export it. What could I be missing? Is there any documentation (good > documentation) on reports anywhere? > > > > > Lisa > > > > > > ________________________________ > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Amen, Kevin > Sent: Wednesday, April 09, 2008 12:08 PM > To: arslist@ARSLIST.ORG > Subject: Re: Regular Reports > > ** > > Create New Report Style for the form. > > Fields Tab: Do not select any fields > > General Tab: Nothing > > Sort Tab: Select Region; check Group on this field > > Statistics Tab: > > Operation - select Sum > > Expression - select Charge > > Label - enter $Region$ > > Compute - select Region > > Layout - select Single Line > > Page Setup Tab: > > Column Per Title - None > > Page Break Per - None > > Compressed Text > > > > > Best Regards, > > Kevin Amen > Novartis Vaccines & Diagnostics > Information Technology > 510.923.3691 (Office) / 510.520.4060 (Cell) > > > > > > ________________________________ > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa > Sent: Wednesday, April 09, 2008 07:47 > To: arslist@ARSLIST.ORG > Subject: Re: Regular Reports > > ** > > Anyone? Bueller....Bueller? > > > > > Lisa > > > > > > ________________________________ > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa > Sent: Tuesday, April 08, 2008 2:02 PM > To: arslist@ARSLIST.ORG > Subject: Regular Reports > > ** > > I was wondering if I could run this with the regular Report feature in our > AR System. (Windows 2003, Oracle 10i DB, ARS 7.0.01 Patch 6). > > Right now I have to create a view form and a view in the database and then I > can run a report. > > Select REGION, SUM(CHARGE) from VPN_CHARGEBACKS_IMPORT > Group by REGION > > Is there anyway to run a report on the original form and grab the Region and > the SUM of the charges? (we do not have Crystal Reports yet) > > Lisa Kemes > AR System Developer > Tyco Electronics > 717-810-2408 tel > 717-810-2124 fax > [EMAIL PROTECTED] > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > ______________________________________________________________________ > This email has been scanned by the MessageLabs Email Security System. > For more information please visit http://www.messagelabs.com/email > ______________________________________________________________________ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers > Are" html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers > Are" html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
