Visual Basic Crystal Reports - Field Count

Author

Field Count - Per Group

Mythran

2006-04-12, 7:05 pm

I have a crystal report in a VB.Net project. In this report, it is grouping
based on ColumnName (actual field name is 'ColumnName'). I also have a
formula field that is named ColumnCount. The current formula is
count({tblColumn.ColumnName}). This is fine, except when the report
displays more than 1 group (multiple column name values are present in the
data), the formula field displays the same # for both groups.

What I am aiming for is just displaying the # of rows per group, not all the
rows in all the data. So, how do I do this? Should be very simple, being
that it should just be reset when the report gets to a new group.

Thanks!

Mythran

Mythran

2006-04-12, 7:05 pm

"Mythran" <kip_potter@hotmail.comREMOVETRAIL> wrote in message
news:%23dHREZkXGHA.3740@TK2MSFTNGP03.phx.gbl...
>I have a crystal report in a VB.Net project. In this report, it is
>grouping based on ColumnName (actual field name is 'ColumnName'). I also
>have a formula field that is named ColumnCount. The current formula is
>count({tblColumn.ColumnName}). This is fine, except when the report
>displays more than 1 group (multiple column name values are present in the
>data), the formula field displays the same # for both groups.
>
> What I am aiming for is just displaying the # of rows per group, not all
> the rows in all the data. So, how do I do this? Should be very simple,
> being that it should just be reset when the report gets to a new group.
>
> Thanks!
>
> Mythran
>

Strike this question. I was able to do this using a running total field
instead of a formula field :) w00t.

Thanks,
Mythran

Iain Sharp

2006-04-13, 4:11 am

On Wed, 12 Apr 2006 08:57:37 -0700, "Mythran"
<kip_potter@hotmail.comREMOVETRAIL> wrote:

>
>"Mythran" <kip_potter@hotmail.comREMOVETRAIL> wrote in message
>news:%23dHREZkXGHA.3740@TK2MSFTNGP03.phx.gbl...
>
>Strike this question. I was able to do this using a running total field
>instead of a formula field :) w00t.
>
>Thanks,
>Mythran

Also, I think you'll find that
count({tblColumn.ColumnName},{tblColumn.ColumnName}) would have
worked. (This is a sub-count by columnname, you were looking at the
total count for the report.

Iain

Sponsored Links