Author |
Message |
kamsri153
Newbie
Joined: 26 May 2009
Location: India
Online Status: Offline
Posts: 17
|
Topic: subtraction between two records Posted: 31 Aug 2009 at 5:17am |
Hi,
i have one doubt in crystal report.
sample records
reportype amount
C 100
D 120
now i have to subtract from reporttype D(debit) record amount value to reporttype C(Credit)
ex:
120-100
Is it possible.
Please help me.Urgent work
|
IP Logged |
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
Posted: 31 Aug 2009 at 6:32am |
you can try previous or next function. I haven't used them, but that would be the way to go. just have to make sure you are still in the same grouping, otherwise you math will probably make now sense in the report.
HTH
|
IP Logged |
|
kamsri153
Newbie
Joined: 26 May 2009
Location: India
Online Status: Offline
Posts: 17
|
Posted: 31 Aug 2009 at 9:07am |
thanks for your valuable reply. I will check it.
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 31 Aug 2009 at 9:17am |
I see where you were going with this lockwelle but I think this may be constant values of "C rows" being positive values and "D rows" being negative values.
If that is the case a formula field of to convert these could be used then Sum that formula field...
if {table.reporttype}="D" then -({table.amount}) else {table.amount}
Sum this formula field to get the total.
|
IP Logged |
|
kamsri153
Newbie
Joined: 26 May 2009
Location: India
Online Status: Offline
Posts: 17
|
Posted: 31 Aug 2009 at 9:45am |
i have 2 group in crystal report, is it possible to inter change group footer section only please guide me. Urgent.
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 31 Aug 2009 at 9:51am |
I do not understand your request
|
IP Logged |
|
kamsri153
Newbie
Joined: 26 May 2009
Location: India
Online Status: Offline
Posts: 17
|
Posted: 31 Aug 2009 at 10:40am |
sorry DBlank,
I have three groupfooter section 1,2,3
i want interchange the groupfooter section 2,3 that is my requirement.
no need to change the header section only footer section only.
Please help urgent work.
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 31 Aug 2009 at 10:51am |
Do you mean you want to have the summary from group2 appear on the footer for group3 and vice versa?
You would have to create sub reports in the footer that include the data from the other group to do that.
|
IP Logged |
|
kamsri153
Newbie
Joined: 26 May 2009
Location: India
Online Status: Offline
Posts: 17
|
Posted: 31 Aug 2009 at 11:03am |
sorry i got output values are correct, but i have to show the footer section 3 first the footer section 2, that is my needs.
Please Help Me
|
IP Logged |
|
kamsri153
Newbie
Joined: 26 May 2009
Location: India
Online Status: Offline
Posts: 17
|
Posted: 31 Aug 2009 at 11:04am |
sorry i got output values are correct, but i have to show the footer section 3 first then footer section 2, that is my needs.
Please Help Me
|
IP Logged |
|
|