Display data for current month & past 3 months

[gavinlow]

Say, I have the following tables:
1. Table1 - DATE, BALANCE, CREDIT INT, DEBIT INT
2. Table2 - DATE, TRANSTYPE1, TRANSTYPE2, TRANSTYPE3
Both the tables contain monthly data for each customer (ie. 1 month 1 record)

Say, current processing month is Sep 2002.
I need to generate the following report:
Jun-2002 Jul-2002 Aug-2002 Sep-2002
BALANCE xx xx xx xx
CREDIT INT xx xx ......
DEBIT INT .
----------- .
TRANSTYPE1 .
TRANSTYPE2 .
TRANSTYPE3 .

What's the best way to do this?
Thanks.
Total:

 

[kenhamady]

Sounds like 2 cross-tabs, with just a column field for the month and each having 3 summarized fields that sum each field.
I assume that TransTypeX is an amount you need to sum.

I would write these as 2 separate reports, because I am not sure I would trust the link between tables to be exactly one to one. You could then put the TransType report in as a subreport. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com