Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: how to show subtotal in columns? Post Reply Post New Topic
Author Message
Hamid
Newbie
Newbie
Avatar

Joined: 05 Jan 2007
Location: Bangladesh
Online Status: Offline
Posts: 1
Quote Hamid Replybullet Topic: how to show subtotal in columns?
    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
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.039 seconds.