ASP.NET - sum formula problem in Crystal Report

Asked By dipak sinha on 31-Jan-12 06:19 AM

hello frnd

i m working on CT.

i want to sum by id.

i have this type record

I have:
GIFT.CONSTIT_ID        GIFT.Amount
1111111              $50
1111111              $10
2222222                $5
2222222              $20
2222222              $25

and I want

GIFT.CONSTIT_ID        GIFT.Amount
1111111              $60
2222222              $50

i m applyng
Sum({GIFT.Amount},{GIFT.CONSTIT_ID})

but this is showing
1111111              $60
1111111              $60
2222222              $50
2222222              $50

plz reply asap. thanks

Jitendra Faye replied to dipak sinha on 31-Jan-12 06:22 AM

something like this
magazines
if {table.type} = "magazines" and {table.date} <= date(yyyy,mm,dd) then
sum({table.field to summarize}
books
if {table.type} = "books" and {table.date} <= date(yyyy,mm,dd) then
sum({table.field to summarize}

ameena aamer replied to Jitendra Faye on 01-Jun-12 03:59 PM

Did you ever find a solution to this? I am currently facing the same issue and looking for an answer. I have two tables which one table contains all activities with cases and the other table contains activities with no cases. I want to create a summary table and want to get the sum of each.