The Top% filter works similar to the TopN filter. A TopN filter with filter value =10 would return the first 10 values of the dataset - regardless of the total number of rows in the dataset. A Top% filter with filter value =10 would return the first 10% of the total number of rows in the dataset.
-- Robert|||I asked the question because the expression i wrote did not work so thought there was something wrong with my syntax. I finally found out that the reporting services filter does not correctly evaluate datatypes other than strings. So I changed my filter expression to convert the vaule into string first and now they work no thanks to the guy writing documentation. This is a bug and it took me quite a while to figure it out.
|||
The alternative is to make sure it takes the value as a numeric by preceeding it with an equal sign. Without this post I would have spent a long time trying to get this to work.
No comments:
Post a Comment