Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS Count Rows

I know variations of this question have been asked and I've read a lot of them but none of the solutions seem to work for me. I'm trying to get a row count or total count of only the results in one column. I can get a count using several different methods but only on the "dataset". As you can see from the image I want to count the number of rows returned for spcc_parcel. The counts I get now are wrong because I'm getting a total row count. Is it possible to just count the result rows?

Report Builder Screen Shot

Report Builder Screen Shot

like image 942
Amateur Avatar asked Dec 19 '22 16:12

Amateur


1 Answers

This is how we count Total Records in our report

=CountRows("DataSetName")
like image 56
bot Avatar answered Dec 21 '22 05:12

bot