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