TOP N? 1

[Cooperdam]

In Crystal Reports, they had a feature called TOP N, that you could use to show only the number of lines in a report, u can also link it as a group so it would show top customers based on total lines.

I need to do the same in SSRS as all of my work has been coversions of Crystal but I don't see this option. is this available in SSRS?

 

[RiverGuy]

Yes, go to the properties of your table or matrix, and choose the filters dialog. One of the options will be to set some field as Top N criteria. Although personally, I usually prefer to do this in the database query.

 

[Cooperdam]

How can this work for a total field? That is, calculated dynamically by the tablix if you will.