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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
