Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: loop that counts occurrence in a atable Post Reply Post New Topic
Author Message
Anna
Newbie
Newbie


Joined: 24 Jul 2011
Online Status: Offline
Posts: 10
Quote Anna Replybullet Topic: loop that counts occurrence in a atable
    Posted: 08 Aug 2011 at 3:06am

Good Morning,

Another question Wink
 
How do I loop trough a table and counts the occurrence of the 5 different inputs; PADL1, PADL2, PADL3, PADL4 and PADL5?
 
Thank you in advance,
Anna 
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 08 Aug 2011 at 5:40am
Running Totals would be the easiest way, great a group by the input types, reset on change of group, and count the number of records.

Depending on what you want:
If you need more help I can provide it

option 1
Group by - table.inputype

at the end of each group footer have a running total with.

field to sum = unique value from table
type = count

eval
for each record

reset
change of group


Option 2 - have all totals in report footer

no group by (just suppress the detail)

rt1PADT

summ - unique value
type - count

eval

use form - itemtype = "PADL1"

Reset

Never


---

Do this for all types of inputs, and just put the running totals in footer
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.016 seconds.