Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sum and Group by

Status
Not open for further replies.
wf

wf

Programmer
Joined
Feb 1, 2001
Messages
32
Location
US
I want to add a formula to my report that calculates the sum of a premium.

Ex:

PolicyNumber Riesgo Bank Premium
123 1 1 50
123 1 2 50

In the table these are two independent records one of them have 30 in the premium and the other one has 20, so the sum is 25.

In sql I do this query:

Select sum(premium) as premium from xxx group by policynumber, riesgo.

But I don't know how to do that in Crystal Reports.

Thanks.
 
Sort by date Sort by votes
Insert a group by policy.
Select the premium, and insert a subtotal. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cursedkorok
  • Locked
  • Question Question
Group consecutive dates
Replies
12
Views
1K
pmax9999
pmax9999
Cpreston
  • Locked
  • Question Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
684
Cpreston
Cpreston
socalvelo
  • Locked
  • Question Question
Group Sorting Distinct Count Minimum
Replies
2
Views
547
socalvelo
socalvelo
Insulations504
  • Locked
  • Question Question
why is my result getting multiplied by 17??
Replies
7
Views
711
pmax9999
pmax9999
jlr123
  • Locked
  • Question Question
date range group by month
Replies
8
Views
749
jlr123
jlr123

Part and Inventory Search

Sponsor

Back
Top