Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Report Builder 3.0 return a count of filtered rows

Author  Topic 

albokay
Starting Member

2 Posts

Posted - 2011-01-21 : 14:41:04
Im trying to get my report to show a total count of rows in the header. There is a filter involved so when I use...

=CountDistinct(Fields!Code.Value, "DataSet1")

it will return a result of all the rows the report pulls up, not just the filtered ones that are showing.

Is there any change to the expression I can make that will give me just the filtered results?

Thanks
Alex

redeyedbass
Starting Member

7 Posts

Posted - 2011-08-12 : 14:07:38

I'm also trying to find a way to do this as well.
Go to Top of Page
   

- Advertisement -