Wednesday, March 7, 2012

expression for count on a field

Can anybody point me in the right direction please?

I am printing labels. And have got this problem.

The total quantity for example is 250 all with different labels fields.

What I need is:

1 of 250

2 of 250

Example of label field: IAC-000245

This is my expression:

=CountDistinct(Fields!ASSETNO.Value)

But the result is is giving me 250 for all labels it should be 1 or 2 or 3

The end result will be:

=CountDistinct(Fields!ASSETNO.Value) & " to " & Fields!QUANTITY.Value

Kindest Regards

This may work for you...

=RunningValue(1,Sum,Nothing)

To append a string, you may need to convert the Running Value to a string.

cheers,
Andrew|||

Thank you it worked like a dream

No comments:

Post a Comment