how to show subtotal in columns?
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=92
Printed Date: 27 Apr 2024 at 8:34am
Topic: how to show subtotal in columns?
Posted By: Hamid
Subject: how to show subtotal in columns?
Date Posted: 05 Jan 2007 at 11:39pm
I have a table InstallmentPayment that contains 3 fields. i.e,
SubscriberId PaymtDate PaymtAmount
---------------------------------------------------
1 31/01/03 500
1 31/06/03 500
1 31/01/04 600
1 31/01/04 600
2 31/01/03 1000
2 31/06/03 1000
2 31/01/04 1000
2 31/06/04 1000
Subscribers pay installment amount for several years. I want to show the payment total for each year of every Subscriber in a single row for a subscriber. i.e
SubsId Paymt2003 Paymt2004
------ -------- ---------
1 1000 1200
2 2000 2000
How can I solve it?
Thanks in advance for reply.
------
Hamid
------------- Hamidur Rahman
|
Replies:
Posted By: BrianBischof
Date Posted: 06 Jan 2007 at 1:41am
Do a cross-tab report with Subscriber Id as the Row field; Year(field) as the column field, and Amount as the summary field. I'll be posting a new chapter on cross-tab reports this weekend (hoping I get time to finish on Sunday).
------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
|