Report Net- Sum Distinct Rows

[JKas]

Hello,

Using ReportNet 1.1, I am trying to create a report that sums the people within an age group. I want to count each person only once, but sum all people into one row by age.

Here is what I did:
1) I used the "count(distinct)" function on each person's ID.
2) I used the "years between" function to calculate age.

Here are my results so far:

AGE Count
50 1
1
1
51 1
1
Summary 5

However, I want the report to just display the summary total for each age group, as follows:

Age Count
50 3
51 2
Summary 5

I have tried every combination of using the Aggregrate functions (total, aggregate, automatic, etc) on my List column for the Count. However, nothing seems to work.

Is there a way to just show row sub-totals in ReportNet? or do I have to create a second query and total the first?

Thanks

Jeff

 

[thanask]

I think you have a column (say person ID) in the group by function which forces the result to display the way you had mentioned.

If not, can be send the query generated for the report..

Regards
K