篩選、分組和排序資料 (報表產生器及 SSRS)Filter, Group, and Sort Data (Report Builder and SSRS)

在報表中,運算式可用於協助您控制、組織和排序報表資料。In a report, expressions are used to help control, organize, and sort report data. 依預設,在您建立資料集與設計報表配置時,報表項目的屬性會依據資料集欄位、參數和 [報表資料] 窗格中出現的其他項目,自動設定為運算式。By default, as you create datasets and design the report layout, properties of report items are set automatically to expressions based on the dataset fields, parameters, and other items that appear in the Report Data pane. 您也可以將互動式排序按鈕加入至資料表或矩陣資料格,讓使用者以互動方式變更群組或群組內資料列的資料列排序順序。You can also add an interactive sort button to a table or matrix cell to enable a user to interactively change the row sort order for groups or rows within groups.

  • 篩選運算式 :篩選運算式會依據您所指定的比較方式,測試包含或排除的資料。Filter expressions A filter expression tests data for inclusion or exclusion based on a comparison that you specify. 在從資料連接擷取資料後,篩選便會套用到報表中的資料。Filters are applied to data in a report after the data is retrieved from a data connection. 您可以將任何篩選組合加入到下列項目:報表伺服器上的共用資料集定義、報表中的共用資料集執行個體或內嵌資料集、資料區 (例如資料表或圖表) 或資料區群組 (例如資料表中的資料列群組或圖表中的類別目錄群組)。You can add any combination of filters to the following items: a shared dataset definition on the report server; a shared dataset instance or embedded dataset in a report; a data region such as a table or a chart; or a data region group, such as a row group in a table or a category group in a chart.

  • 群組運算式 :群組運算式會依據資料集欄位或其他值來組織資料。Group expressions A group expression organizes data based on a dataset field or other value. 系統會在您建立報表配置時自動建立群組運算式。Group expressions are created automatically as you build the report layout. 將篩選套用到資料之後,以及在結合報表資料和資料區之時,報表處理器會評估群組運算式。The report processor evaluates group expressions after filters are applied to the data, and as report data and data regions are combined. 您可以在建立群組運算式之後加以自訂。You can customize a group expression after it is created.

  • 排序運算式 :排序運算式會控制資料出現在資料區中的次序。Sort expressions A sort expression controls the order in which data appears in a data region. 系統會在您建立報表配置時自動建立排序運算式。Sort expressions are created automatically as you build the report layout. 根據預設,群組的排序運算式會設定為與群組運算式相同的值。By default, a sort expression for a group is set to the same value as the group expression. 您可以在建立排序運算式之後加以自訂。You can customize a sort expression after it is created.

  • 互動式排序 :您可以將互動式排序按鈕加入到資料表或矩陣中的資料行標頭或群組首資料格,讓使用者排序資料行或反轉資料行的排序次序。Interactive sort To enable a user to sort or reverse the sort order of a column, you can add an interactive sort button to a column header or group header cell in a table or matrix.

    為協助使用者自訂篩選、群組或排序運算式,您可以變更運算式,以將參考加入至報表參數。To help your users customize filter, group, or sort expressions, you can change an expression to add a reference to a report parameter. 如需詳細資訊,請參閱 MSDN 上的 報表參數 (報表產生器和報表設計師)類型之報表資料來源為基礎的資料集。For more information, see Report Parameters (Report Builder and Report Designer).

    如需詳細資訊和範例,請參閱下列主題:For more information and examples, see the following topics:

  • 群組運算式範例 (報表產生器及 SSRS)Group Expression Examples (Report Builder and SSRS)

  • 篩選方程式範例 (報表產生器及 SSRS)Filter Equation Examples (Report Builder and SSRS)

  • 報表產生器教學課程Report Builder Tutorials

  • Reporting Services 教學課程 (SSRS)Reporting Services Tutorials (SSRS)

  • 報表範例 (報表產生器和 SSRS)Report Samples (Report Builder and SSRS)

注意

您可以在報表產生器以及 SQL Server Data Tools 的報表設計師中建立和修改分頁報表定義檔 (.rdl)。You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. 每種撰寫環境都會提供不同的方式來建立、開啟和儲存報表與相關的項目。Each authoring environment provides different ways to create, open, and save reports and related items.

篩選報表中的資料Filtering Data in the Report

篩選是報表的一部分,有助於控制從資料連接擷取的報表資料。Filters are parts of a report that help control report data after it is retrieved from the data connection. 如果您無法在從外部資料來源擷取資料之前,變更資料集查詢來篩選資料,請使用篩選。Use filters when you cannot change a dataset query to filter data before it is retrieved from an external data source.

如果可能,請建立只會傳回需要顯示在報表中之資料的資料集查詢。When it is possible, build dataset queries that return only the data that you need to display in the report. 您可透過減少必須擷取和處理的資料量,協助增進報表效能。When you reduce the amount of the data that must be retrieved and processed, you are helping to improve report performance. 如需詳細資訊,請參閱 報表內嵌資料集和共用資料集 (報表產生器及 SSRS)For more information, see Report Embedded Datasets and Shared Datasets (Report Builder and SSRS).

從外部資料來源擷取資料之後,您可以將篩選加入至資料集、資料區和資料區群組,包括詳細資料群組。After the data is retrieved from the external data source, you can add filters to datasets, data regions, and data region groups, including detail groups. 篩選會在執行階段先套用至資料集、套用至資料區,然後套用至群組 (按照群組階層的由上而下順序)。Filters are applied at run time first on the dataset, and then on the data region, and then on the group, in top-down order for group hierarchies. 在資料表、矩陣或清單中,系統會針對資料列群組、資料行群組和相鄰群組獨立套用篩選。In a table, matrix, or list, filters for row groups, column groups, and adjacent groups are applied independently. 在圖表中,系統會針對類別目錄群組和數列群組獨立套用篩選。In a chart, filters for category groups and series groups are applied independently. 如需詳細資訊,請參閱 加入資料集篩選、資料區篩選和群組篩選 (報表產生器及 SSRS)For more information, see Add Dataset Filters, Data Region Filters, and Group Filters (Report Builder and SSRS).

針對每個篩選,您會指定一個 「篩選方程式」(Filter Equation)。For each filter, you specify a filter equation. 篩選方程式包含一個指定所要篩選之資料的資料集欄位或運算式、一個運算子和一個要比較的值。A filter equation includes a dataset field or expression that specifies the data to filter, an operator, and a value to compare. 在處理項目時,只會包含符合篩選條件的資料值。Only those data values that match the filter condition are included when the item is processed.

您可以在篩選運算式中包含參數,讓使用者協助控制報表中的資料。To enable your users to help control the data in a report, you can include parameters in filter expressions. 如需詳細資訊,請參閱參數集合參考 (報表產生器及 SSRS)For more information, see Parameters Collection References (Report Builder and SSRS).

若要自訂每個使用者的檢視,您可以在篩選中包含內建欄位 UserID 的參考。To customize a view for each user, you can include a reference to the built-in field UserID in a filter. 如需詳細資訊,請參閱內建的全域和使用者參考 (報表產生器及 SSRS)For more information, see Built-in Globals and Users References (Report Builder and SSRS).

群組報表中的資料Grouping Data in the Report

群組可組織報表中的資料以供顯示或計算彙總值。Groups organize data in a report for display or for calculating aggregate values. 了解如何定義群組以及使用群組功能可協助您設計更精確的報表。Understanding how to define groups and use group features helps you to design reports that are more concise.

系統會在您執行下列作業時自動建立群組運算式:Group expressions are created automatically when you do the following:

  • 在資料表、矩陣或圖表精靈中排序資料集欄位,或是在地圖精靈中比對欄位。Arrange dataset fields in a Table, Matrix, Chart wizard or match fields in the Map wizard.

  • 在資料表、矩陣或清單中,將欄位加入至 [群組] 窗格中的 [資料列群組] 或 [資料行群組] 區域。In a table, matrix, or list, add a field to the Row Groups or Column Groups area in the Grouping pane.

  • 在圖表中,將欄位加入至 [圖表資料] 窗格中的 [類別目錄群組] 或 [數列群組] 區域。In a chart, add a field to the Category Groups or Series Groups area in the Chart data pane.

  • 在地圖中,指定欄位,以比對地圖元素與 [圖層資料] 內容功能表項目中的分析資料。In a map, specify a field to match map elements with analytical data in the Layer Data context menu item.

    群組是報表定義的一部分。A group is a part of the report definition. 每個群組都有一個名稱。Each group has a name. 依預設,群組名稱是其依據的資料集欄位。By default, the group name is the dataset field that it is based on.

    在資料表或矩陣區域內,您可以建立多個資料列群組和資料行群組。In a table or matrix data region, you can create multiple row groups and column groups. 您可以透過組織巢狀群組、相鄰群組及遞迴階層群組 (例如組織圖),以視覺階層顯示您的資料。You can display your data in a visual hierarchy by organizing nested groups, adjacent groups, and recursive hierarchy groups (such as an organizational chart).

    群組名稱會識別運算式範圍。The group name identifies an expression scope. 您可以將群組的名稱指定成下列作業的執行範圍:計算彙總、在向下鑽研報表中以階層方式組織資料並從父節點切換為子節點的顯示、在多個資料區中顯示相同資料的不同檢視,以及視覺化資料表、矩陣、圖表、量測計或地圖中的摘要資料。You can specify the name of a group as a scope in which to calculate aggregates, to organize data hierarchically and toggle the display of child nodes from parent nodes in a drilldown report, to display different views of the same data on multiple data regions, and to visualize summary data in a table, matrix, chart, gauge, or map. 如需詳細資訊,請參閱 總計、彙總與內建集合的運算式範圍 (報表產生器及 SSRS)For more information, see Expression Scope for Totals, Aggregates, and Built-in Collections (Report Builder and SSRS).

    若要在數個資料集欄位上分組,請將每個欄位加入到群組運算式集合。To group on several dataset fields, add each field to the set of group expressions. 您也可以在 MicrosoftMicrosoft Visual BasicVisual Basic中,撰寫自己的群組運算式。You can also write your own group expressions in MicrosoftMicrosoft Visual BasicVisual Basic. 例如,您可以依據值的範圍分組,或者使用報表參數讓使用者選取在資料區中分組資料的方式藉以進行分組。For example, you can group by a range of values, or by using a report parameter to enable your user to select how to group data in a data region. 如需詳細資訊,請參閱 群組運算式範例 (報表產生器及 SSRS)For more information, see Group Expression Examples (Report Builder and SSRS).

    若要呈現報表,您可以在每個群組或每個群組執行個體的前後加入分頁符號,以減少每個頁面的資料量並協助您管理報表轉譯效能。For report presentation, you can add page breaks before and after each group, or each instance of a group, to reduce the amount of data on each page and help you manage report rendering performance. 如需詳細資訊,請參閱新增分頁符號 (報表產生器及 SSRS)For more information, see Add a Page Break (Report Builder and SSRS).

    建立資料區群組是在報表中組織資料的一種方法。Creating data region groups is one way to organize data in a report. 另外還有其他幾種組織資料的方法,每一種都有其各自的優點。There are several other ways to organize data, each with its own advantages. 如需詳細資訊,請參閱 鑽研、向下鑽研、子報表和巢狀資料區 (報表產生器及 SSRS)For more information, see Drillthrough, Drilldown, Subreports, and Nested Data Regions (Report Builder and SSRS).

定義群組變數Defining Group Variables

當您定義群組時,可以建立群組變數,以便在以群組為範圍並可從巢狀群組存取的運算式中使用。When you define a group, you can create a group variable to use in expressions that are scoped to the group and accessed from nested groups. 群組變數會針對每個群組執行個體計算一次,而且可以從子群組中的運算式存取。A group variable is calculated once per group instance and can be accessed from expressions in child groups. 例如,如果資料是依區域和子區域分組,您可以計算每個區域的稅額,並在子區域群組的計算中使用該稅額。For example, for data that is grouped by region and subregion, you can calculate a tax for each region and use that tax in calculations from the subregion group.

如需詳細資訊,請參閱 報表和群組變數集合參考 (報表產生器及 SSRS)總計、彙總與內建集合的運算式範圍 (報表產生器及 SSRS)For more information, see Report and Group Variables Collections References (Report Builder and SSRS) and Expression Scope for Totals, Aggregates, and Built-in Collections (Report Builder and SSRS).

資料區中的群組和範圍Groups and Scope in Data Regions

您可以為每個資料區指定相同的群組運算式,以提供相同資料集內資料的多個檢視。To provide multiple views of data from the same dataset, you can specify the same group expressions for eac data region. 例如,您可以顯示分類資料,以在資料表中顯示所有詳細資料,並在圖形圖中顯示彙總,同時協助您以相對於整個資料集的方式視覺化每個類別目錄。For example, you can display categorized data in a table to show all detail data and in a pie chart to show aggregates and to help visualize each category in relation to the entire dataset. 如需詳細資訊,請參閱 將多個資料區連結至相同的資料集 (報表產生器及 SSRS)For more information, see Linking Multiple Data Regions to the Same Dataset (Report Builder and SSRS).

當您在資料表、矩陣或清單的資料格中建立巢狀資料區時,您會自動將資料的範圍設定成該資料格的最內層群組成員資格。When you nest a data region in a cell in a table, matrix, or list, you are automatically scoping the data to the innermost group memberships of the cell. 例如,假設您將圖表加入到同時位於資料列群組和資料行群組的資料格中。For example, assume that you add a chart to a cell that is in both a row group and a column group. 可用於該圖表的資料範圍在執行階段便為最內層的資料列群組執行個體與最內層的資料行群組執行個體。The data available to that chart is scoped to the innermost row group instance and innermost column group instance at run time. 如需詳細資訊,請參閱 總計、彙總與內建集合的運算式範圍 (報表產生器及 SSRS)For more information, see Expression Scope for Totals, Aggregates, and Built-in Collections (Report Builder and SSRS).

排序報表中的資料Sorting Data in the Report

若要控制報表中資料的排序次序,您可以在資料集查詢中排序資料,或針對資料區或群組定義排序運算式。To control the sort order of data in your report, you can sort data in a dataset query, or define a sort expression for a data region or group. 您也可以將互動式排序按鈕加入到資料表和矩陣,讓使用者變更資料列的排序次序。You can also add interactive sort buttons to tables and matrices to enable a user to change the sort order for rows.

三種類型的排序全都可以在相同的報表中結合。All three types of sorts can be combined in the same report. 依預設,排序次序是由資料集查詢傳回資料的順序來決定。By default, sort order is determined by the order in which data is returned by the dataset query. 排序運算式會套用在資料區和資料區群組中。Sort expressions are applied in the data region and data region group. 互動式排序則是在排序運算式之後套用。Interactive sorts are applied after sort expressions.

對於包含彙總函式的運算式,大部分的結果都不會受排序次序影響。For expressions that contain aggregate functions, most results are not affected by sort order. 下列彙總函式的傳回值會受排序次序影響:First、Last 和 Previous。Return values for the following aggregate functions are affected by sort order:: First, Last, and Previous. 如需詳細資訊,請參閱 彙總函式參考 (報表產生器和 SSRS)For more information, see Aggregate Functions Reference (Report Builder and SSRS).

排序資料集查詢中的資料Sorting Data in a Dataset Query

將資料集查詢中的排序次序加入到預先排序資料,然後再針對報表進行擷取。Include sort order in the dataset query to pre-sort data before it is retrieved for a report. 透過排序查詢中的資料,排序工作將由資料來源而非報表處理器完成。By sorting data in the query, the sorting work is done by the data source instead of by the report processor.

若是 MicrosoftMicrosoft [SQL Server]SQL Server 資料來源類型,您可以將 ORDER BY 子句加入到資料集查詢。For a MicrosoftMicrosoft [SQL Server]SQL Server data source type, you can add an ORDER BY clause to the dataset query. 例如,下列 Transact-SQLTransact-SQL 查詢會從 SalesOrders 資料表,以遞減的順序排序 Sales 和 Region by Sales 資料行: SELECT Sales, Region FROM SalesOrders ORDER BY Sales DESCFor example, the following Transact-SQLTransact-SQL query sorts the columns Sales and Region by Sales in descending order from the table SalesOrders: SELECT Sales, Region FROM SalesOrders ORDER BY Sales DESC. 如需詳細資訊,請參閱《 SQL Server 線上叢書》中的<使用 ORDER BY 排序資料列>。For more information, see "Sorting Rows with ORDER BY" in SQL Server Books Online.

注意

並非所有資料來源都支援在查詢中指定排序次序的能力。Not all data sources support the ability to specify sort order in the query.

利用排序運算式排序資料Sorting Data with Sort Expressions

若要在資料從資料來源擷取後排序報表中的資料,您可以針對 Tablix 資料區域或群組 (包括詳細資料群組) 設定排序運算式。To sort data in the report after it is retrieved from the data source, you can set sort expressions on a Tablix data region or a group, including the details group. 下列清單描述針對不同項目設定排序運算式的效果:The following list describes the effect of setting sort expressions on different items:

  • Tablix 資料區域:Tablix data region. 在執行階段套用資料集篩選和資料區域篩選之後,針對資料表、矩陣或清單資料區域設定排序運算式來控制資料在資料區域中的排序次序。Set sort expressions on a table, matrix, or list data region to control the sort order of data in the data region, after dataset filters and data region filters are applied at run time.

  • Tablix 資料區域群組:Tablix data region group. 設定每個群組 (包括詳細資料群組) 的排序運算式來控制群組執行個體的排序次序。Set sort expressions for each group, including the details group, to control the sort order of group instances. 例如,您可以針對詳細資料群組,控制詳細資料列的次序。For example, for the details group, you control the order of the detail rows. 若是子群組,您可以針對父群組中的子群組,控制群組執行個體的次序。For a child group, you control the order of group instances for the child group within the parent group. 根據預設,當您建立群組時,排序運算式會設定為群組運算式以及遞增順序。By default, when you create a group, the sort expression is set to the group expression and to ascending order.

    如果您只有一個詳細資料群組,您可以在查詢中、資料區域上,或詳細資料群組上,將排序運算式定義為相同的效果。If you have only one details group, you can define a sort expression in the query, on the data region, or on the details group to the same effect.

  • 圖表資料區域:Chart data region. 設定類別目錄和數列群組的排序運算式來控制資料點的排序次序。Set a sort expression for the category and series groups to control the sort order for data points. 根據預設,資料點的次序也是色彩在圖表圖例中的次序。By default, the order of data points is also the order of the colors in the chart legend. 如需詳細資訊,請參閱 設定圖表上數列色彩的格式 (報表產生器及 SSRS)For more information, see Formatting Series Colors on a Chart (Report Builder and SSRS).

  • 地圖報表項目:Map report item. 您通常不需要排序地圖資料區的資料,因為地圖會將要顯示在地圖元素上的資料分組。You do not typically need to sort data for a map data region because the map groups data to display on map elements.

  • 量測計資料區:Gauge data region. 您通常不需要排序量測計資料區的資料,因為量測計會顯示相對於某個範圍的單一值。You do not typically need to sort data for a gauge data region because the gauge displays a single value relative to a range. 如果您需要排序量測計中的資料,則必須先定義一個群組,然後設定該群組的排序運算式。If you do need sort data in a gauge, you must first define a group, and then set a sort expression for the group.

依其他值排序Sorting by a Different Value

您可以按照欄位值以外的其他值來排序資料區中的資料列。You might want to sort the rows in a data region by a value other than the field value. 例如,假設 [Size] 欄位包含對應於小、中、大和超大的文字值。For example, suppose that the field Size contains text values that correspond to small, medium, large, and extra large. 依預設,以 Size 為根據之資料列群組的排序運算式也是 [Size]。By default, the sort expression for a row group based on Size is also [Size]. 若要更進一步控制資料排序的方式,您可以將欄位加入到定義所需排序次序的資料集查詢中。To have more control over the way that data is sorted, you can add a field to the dataset query that defines the sort order that you want.

或者,您也可以定義只包含大小的資料集,以及用來指定所需次序的值。Alternatively, you can define a dataset that includes only the sizes and a value that specifies the order that you want. 您可以將排序運算式變更為使用 Lookup 函數做為排序次序值。You can change the sort expression to use the Lookup function for the sort order value.

例如,假設下列 Transact-SQLTransact-SQL 查詢定義一個名為 Sizes 的資料集。For example, assume that the following Transact-SQLTransact-SQL query defines a dataset named Sizes. 此查詢會使用 CASE 陳述式,針對 Size 的每個值定義排序次序值 SizeSortOrder:The query uses a CASE statement to define a sort order value SizeSortOrder for each value of Size:

SELECT Size,   
  CASE Size  
        WHEN 'S' THEN 1  
        WHEN 'M' THEN 2    
        WHEN 'L' THEN 3  
        WHEN 'XL' THEN 4  
        ELSE 0  
  END as SizeSortOrder  
FROM Production.Product  

在具有以 [Size]做為根據之資料列群組的資料表中,您可以變更群組排序運算式,以使用 Lookup 函數來尋找對應於大小值的數值欄位。In a table that has a row group based on [Size], you can change the group sort expression to use a Lookup function to find the numeric field that corresponds to the size value. 這個運算式類似於下例:The expression would be similar to this:

=Lookup(Fields!Size.Value, Fields!Size.Value, Fields!SizeSortOrder.Value, "Sizes")  

如需詳細資訊,請參閱在資料區中排序資料 (報表產生器及 SSRS)Lookup 函數 (報表產生器及 SSRS)For more information, see Sort Data in a Data Region (Report Builder and SSRS) and Lookup Function (Report Builder and SSRS).

加入使用者的互動式排序Adding Interactive Sorting for the User

您可以將互動式排序按鈕加入到資料行標頭和群組首,讓使用者變更資料表或矩陣中報表資料的排序次序。To enable a user to change the sort order of report data in a table or matrix, you can add interactive sort buttons to column headers or group headers. 使用者可以按一下按鈕來切換排序次序。Users can click the button to toggle the sort order. 系統以可讓使用者互動的轉譯格式支援互動式排序,例如 HTML。Interactive sort is supported in rendering formats that allow user interaction, such as HTML.

您可以將互動式排序按鈕加入到 Tablix 資料區資料格裡的文字方塊中。You add interactive sort buttons to a text box in a tablix data region cell. 依預設,每個資料格都包含一個文字方塊。By default, every cell contains a text box. 在文字方塊屬性中,您可以指定要排序資料表或矩陣資料區的哪個部分 (父群組值、子群組值或詳細資料列)、排序的依據,以及是否要將排序運算式套用到具有對等關聯性的其他報表項目。In the text box properties, you specify which part of a table or matrix data region to sort (the parent group values, the child group values, or the detail rows), what to sort by, and whether to apply the sort expression to other report items that have a peer relationship. 例如,如果在相同資料集中提供檢視的資料表和圖表都包含在矩形中,它們就是對等資料區域。For example, if a table and a chart that provide views on the same dataset are contained in a rectangle, they are peer data regions. 當使用者在資料表中切換排序次序時,圖表的排序次序也會切換。When a user toggles the sort order in the table, the sort order for the chart also toggles. 如需詳細資訊,請參閱互動式排序 (報表產生器及 SSRS)For more information, see Interactive Sort (Report Builder and SSRS).

如何主題How-To Topics

在報表中捲動時將標頭保持可見 (報表產生器及 SSRS)Keep Headers Visible When Scrolling Through a Report (Report Builder and SSRS)

與群組一起顯示頁首和頁尾 (報表產生器及 SSRS)Display Headers and Footers with a Group (Report Builder and SSRS)

將互動式排序加入至資料表或矩陣 (報表產生器及 SSRS)Add Interactive Sort to a Table or Matrix (Report Builder and SSRS)

在資料區域中設定沒有資料的訊息 (報表產生器及 SSRS)Set a No Data Message for a Data Region (Report Builder and SSRS)

建立遞迴階層群組 (報表產生器及 SSRS)Create a Recursive Hierarchy Group (Report Builder and SSRS)

在資料區中加入或刪除群組 (報表產生器及 SSRS)Add or Delete a Group in a Data Region (Report Builder and SSRS)

與群組一起顯示頁首和頁尾 (報表產生器及 SSRS)Display Headers and Footers with a Group (Report Builder and SSRS)

在圖表中加入或刪除群組 (報表產生器及 SSRS)Add or Delete a Group in a Chart (Report Builder and SSRS)

將總計加入到群組或 Tablix 資料區 (報表產生器及 SSRS)Add a Total to a Group or Tablix Data Region (Report Builder and SSRS)

本節內容In This Section

群組運算式範例 (報表產生器及 SSRS)Group Expression Examples (Report Builder and SSRS)

篩選方程式範例 (報表產生器及 SSRS)Filter Equation Examples (Report Builder and SSRS)

加入資料集篩選、資料區篩選和群組篩選 (報表產生器及 SSRS)Add Dataset Filters, Data Region Filters, and Group Filters (Report Builder and SSRS)

了解群組 (報表產生器及 SSRS)Understanding Groups (Report Builder and SSRS)

建立遞迴階層群組 (報表產生器及 SSRS)Creating Recursive Hierarchy Groups (Report Builder and SSRS)

總計、彙總與內建集合的運算式範圍 (報表產生器及 SSRS)Expression Scope for Totals, Aggregates, and Built-in Collections (Report Builder and SSRS)

報表和群組變數集合參考 (報表產生器及 SSRS)Report and Group Variables Collections References (Report Builder and SSRS)

將包含多個資料範圍的數列顯示在圖表上 (報表產生器及 SSRS)Displaying a Series with Multiple Data Ranges on a Chart (Report Builder and SSRS)

將多個資料區連結至相同的資料集 (報表產生器及 SSRS)Linking Multiple Data Regions to the Same Dataset (Report Builder and SSRS)

另請參閱See Also

運算式 (報表產生器及 SSRS) Expressions (Report Builder and SSRS)
資料表、矩陣和清單 (報表產生器及 SSRS) Tables, Matrices, and Lists (Report Builder and SSRS)
圖表 (報表產生器及 SSRS) Charts (Report Builder and SSRS)
地圖 (報表產生器及 SSRS) Maps (Report Builder and SSRS)
走勢圖和資料橫條 (報表產生器及 SSRS) Sparklines and Data Bars (Report Builder and SSRS)
量測計 (報表產生器及 SSRS) Gauges (Report Builder and SSRS)
指標 (報表產生器及 SSRS)Indicators (Report Builder and SSRS)