Report builder/crystal reports

It sounds like a good application for the Crosstab Reports available
in Crystal. You can do it with a series of formulas like Todd
suggested, but with a Crosstab, Crystal should group them in the
proper months for you much more easily.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, Fredy Venczel <fvenczel@x> wrote:
> I have a question for all your Report Builder/Crystal Report
experts. What I
> would like to do is come up with transaction totals of a part on a
month by
> month basis for the last year. I want it to look something like
this:
>
> Part Current -1 -2 -3 -4 -5 -6 -7
-8
> -9 -10 -11
> abc total total total total total total total total
> total total total total
>
> I will filter on certain transaction types but I don't know how to
specify
> transactions separated for each month. Can someone give me a little
push?
>
> Thanks,
>
> Fredy Venczel
I have a question for all your Report Builder/Crystal Report experts. What I
would like to do is come up with transaction totals of a part on a month by
month basis for the last year. I want it to look something like this:

Part Current -1 -2 -3 -4 -5 -6 -7 -8
-9 -10 -11
abc total total total total total total total total
total total total total

I will filter on certain transaction types but I don't know how to specify
transactions separated for each month. Can someone give me a little push?

Thanks,

Fredy Venczel
I usually create a whole bunch of "buckets" via calculated fields which test for eligibility within the date range.
Like:
Period1-Amt = IIF(RecDate >= Per1-StartDate and RecDate <= Per1-EndDate,RecValue,0)
then can aggregate as needed on the period amounts that have been segregated into the buckets.

Sould like what you needed?
-Todd C.

-----Original Message-----
From: Fredy Venczel [mailto:fvenczel@...]
Sent: Friday, November 21, 2003 11:17 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] report builder/crystal reports


I have a question for all your Report Builder/Crystal Report experts. What I
would like to do is come up with transaction totals of a part on a month by
month basis for the last year. I want it to look something like this:

Part Current -1 -2 -3 -4 -5 -6 -7 -8
-9 -10 -11
abc total total total total total total total total
total total total total

I will filter on certain transaction types but I don't know how to specify
transactions separated for each month. Can someone give me a little push?

Thanks,

Fredy Venczel


Yahoo! Groups Sponsor
<http://rd.yahoo.com/SIG=12chk6p0l/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/EXP=1069521439/A=1524963/R=0/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=930016877>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]