Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Arithmatic Operations based on rows Post Reply Post New Topic
Author Message
kirandb
Groupie
Groupie
Avatar

Joined: 10 Jun 2009
Location: United States
Online Status: Offline
Posts: 69
Quote kirandb Replybullet Topic: Arithmatic Operations based on rows
    Posted: 08 Jan 2010 at 7:58am

My Data is something like

ID     NAME        MONTH              QTR              YEAR               YTD 
---    --------       ----------           ----------          --------           ---------   
1       TEXAS       13,546            40,564            154,546        16,764
2       OHIO         5,675             23,567             101,453        7,685
3       CALI          -5,778           -25,764            4,678            -6,878
 
Row 4 could be any arithmatic operation such as (Row1 + Row3 ) / Row2.
 
How do i implement in crystal reports 2008 ?
 
Thanks,
Kiran
share your knowledge
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 11 Jan 2010 at 5:47am
the short answer is create a formula using shared variables.
 
you would need to know what you want row 4 to do (or the range of options) then you would need to keep track of the values you want row to act on.  If it is always just 3 rows, you could name variables, but if the number of rows is indeterminate at the time of design, you would probably need to use an array of shared variables.
 
HTH
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.031 seconds.