Thank you Gordonthe separate field on the same form holding the month was
my initial thought as well, then grouping on that field, as you
suggestedand you are correct, Crystal is not an option. Ok...thank you for
the confirmation of my thoughts and that I wasn't missing anything completely
obvious.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon Frank
Sent: Monday, October 29, 2012 7:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Monthly Summary Reports
**
What you'll need to do is create a hidden field which holds month in it. You
will need a translation Filter to take the Month number and translate it to
January, February
This Filter will work on the fly. Every record will have a value in it. It's a
little bit of overhead, but ARS doesn't care. If it's a Filter, then it is
server fast. Once you have the month stored, you can Group on it and get a
summary by using Statistics in the Report Writer.
Another way to do this is with a separate form which hold a translation between
month number and month. Doing it this way will allow any form to use it as a
lookup table.
Using the OOB report writer has limitations. Crystal has functions to do this
on-the-fly. but it doesn't sound like Crystal is available.
Gordon
From: LJ CTR MDA/IC Longwing lj.longwing@mda.mil
To: arslist@ARSLIST.ORG
Sent: Monday, October 29, 2012 9:31:44 AM
Subject: Monthly Summary Reports
Hey folks, looking for some reporting experts out there to help me out. I'm
trying to run a report that groups things by month, and the summarizes within
that month. I'm not seeing any method to use the MONTH() function within a
standard AR System report and would love if someone can give me a tip/trick
that's not coming to mind.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12
www.wwrug12.com ARSList: Where the Answers Are
_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
