none
ReportingService图表按照Y值筛选前N项 RRS feed

  • 问题

  • 大家好

    用于ReportingService图表(柱状图)数据绑定的Dataset构造好了,一共20家单位的数据,现在需要根据数据从大到小排序,只显示前10家单位的数据,请问如何实现。

    即在不修改DataSet的前提下,如何通过指标排序只显示前N项的数据,而不是显示全部数据。

    感谢!

    2013年9月13日 1:42

答案

  • To sort the data points in ascending or descending order on a chart

    1. Right-click a field in the Category Field drop zone and click Category GroupProperties.

    2. In the Category Group Properties dialog box, click Sorting.

    3. For each sort expression, follow these steps:

      1. Click Add.

      2. Select the expression that matches your data field. In most cases, this is an aggregated value, such as =Sum(Fields!Quantity.Value).

      3. From the Order column drop-down list, choose the sort direction for each expression. A-Z sorts the expression in ascending order. Z-A sorts the expression in descending order.

    4. Click OK.

    More information refer to:

    http://technet.microsoft.com/en-us/library/ms157462(v=sql.100).aspx
    
    http://technet.microsoft.com/en-us/library/ms157313(v=sql.100).aspx
    
    http://technet.microsoft.com/en-us/library/cc627509(v=sql.100).aspx
    
    http://sqlblog.com/blogs/stacia_misner/archive/2011/03/16/34197.aspx
    

    2013年9月16日 1:13