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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple counts

Status
Not open for further replies.
fhurmuzlu

fhurmuzlu

Programmer
Nov 16, 2004
52
US
I have Caseid table and Casecount table , each case number in Caseid table have multiple counts in Casecount table .I need a formula that show each case number with their counts?

(Casecount.CNT)CNT = Case Count
(caseid.CCN)CCN = Case Number
My Parameter is {?Casenumber}
 
Sort by date Sort by votes
What field in the casecount table is causing the multiple counts? If you determine what that is, then you could insert a crosstab in the report footer that uses casenumber as the row field, the mystery field as the column field, and case count as the summary.

-LB

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

crytalbria
  • Locked
  • Question
SQL Expression Field wtih multiple FROMs
Replies
3
Views
446
hilfy
hilfy
hpl2001
  • Locked
  • Question
Multiple multi value parameters
Replies
4
Views
174
pmax9999
pmax9999
supportsvc
  • Locked
  • Question
Combine Multiple If Statements as Single String? 1
Replies
7
Views
345
supportsvc
supportsvc
peaches9531
  • Locked
  • Question
Formula for multiple records selection criteria in Crystal
Replies
3
Views
340
lbass
lbass
Kofstar
  • Locked
  • Question
Hello All, Note indicates multiple
Replies
4
Views
132
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top