Filter by Group, how to do that?

building reports crystal reports
1

I have a report with Group By CustomerID, displaying Payments
I want to

  1. exclude the groups if the sum of Payments = 0.00
    or
  2. take only the groups if sum of payments > 0

How to do that in CrystalReport XI?

calvinfoo (BOB member since 2015-05-20)

2

Take a look at the Select Expert for Group (click on the down arrow next to the funnel icon). This should work for you.

kevlray :us: (BOB member since 2010-06-23)

3

enter into group selection formula and write your condition
like
sum(field)=0
it works as expected… this is the main difference between record section formula and group selection formula which will frequently asked in interviews… record selection is to suppress records where as group selection formula is to suppress groups based on given criteria in groups…selection formula… hope this works as expected… enjoy learning and earning… :nopity:

surya.g :india: (BOB member since 2009-11-24)

4

It works! Thank you all.

This leads me a next problem. Not directly CrystalReport related, but something loosely with the record rows counting.

Example, Total Rows = 100, but after grouped and filter it will leave only 80. But the RowCounter remains and printed 100.

Example:

Records:
A 10
A 10
A -20
B 10
C 10

If I take the group Sum >0 then I should get only
B 10
C 10
Count = 2

But I get
B 10
C 10
Count = 5

This a bit confusing, but the idea is that.

calvinfoo (BOB member since 2015-05-20)