SSRS doesn't like this, why?

[garbsmj]

Perhaps, I'm just doing something dumb here, but all I'm trying to do is count loans by county. In the subtotal section of the County group, I have:


="Total for " + Fields!County_Name.Value + ": "
+ CountDistinct(Fields!Loan_Num.Value, "County")

Where Loan_Num is the first field in the detail section and County_Name is the name of the county (eg. "Mickey") and County is the group.

The expression itself seems fine, but when I preview the report I get the ever so unhelpful "err#". I've verified that everything up to the CountDistinct is working - I've tried RunningValue too and it's bombed out.

If you could just direct me to a handy-dandy site that discusses this and doesn't start with Micro####, it would be nice.

[HansV]

What happens if you omit the "County" argument:

="Total for " & Fields!County_Name.Value & ": " & CountDistinct(Fields!Loan_Num.Value)

or for testing purposes just

=CountDistinct(Fields!Loan_Num.Value)

[garbsmj]

Thanks Hans! I knew it was something dumb I did. The count worked - now I just need to figure out how to get the rest of the sentence they want.

Bless this lounge