CODEWITHSUNDEEP
vb.netreporting-servicesssrs-2008-r2
Aarin
Aarin

Reputation: 76

SRSS count how many rows in group?

enter image description here

I want to find how many rows will contain by DateOfInvestment group(Blue color arrow), if it contain more than one then above heading row will show "DateS" of Investment, or if it is single row then "Date of Investment".

I used IIF(CountRow("DateOfInvestment")>1,"...","...") its shows error

Upvotes: 0

Views: 89

Answers (1)

solutionist
solutionist

Reputation: 158

You can count the number of distinct values in the dataset of the field being grouped.

="Date of Investment" & IIF(CountDistinct(Fields!DateOfInvestment.Value, "DateOfInvestmentGrp") = 1, "", "s") & ":"

Upvotes: 1

Related Questions