Tham khảo tài liệu 'sams microsoft sql server 2008- p6', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Tablix New in 2008 Table Matrix List 231 FIGURE Simple Tablix design. 13 To properly color the entire row or column you can use the following expression in the Backgroundcolor property of the innermost group where RowGroupI is the name of the row group IIF Not InScope RowGroup1 LightGrey White Because a cell in a Tablix contains one or more report items you format the result by formatting those items. For example a cell that presents textual information contains a Textbox report item. By setting properties and formatting text in a Textbox report item you can manipulate the rendering outcome. For example you can conditionally hide row data by setting the Hidden property of each cell to True. Chapter 14 shows an example of this. We frequently use several properties of a Tablix in our work. To set these properties select the entire Tablix by either clicking the Tablix s corner handler or selecting the Tablix from the drop-down list on the Properties window. The frequently used properties are as follows Filters A set of filter expressions for a Tablix. Filters limit data displayed by a Tablix much like the WHERE clause limits results of a query. Whereas in most of the cases you want to actually leverage a WHERE clause to improve performance and reduce unnecessary network traffic you still need to have a filter for example in situations when you can t change a data set . FixedColumnHeaders and FixedRowHeaders When set to True these keep column and row headers displayed when the user scrolls through Tablix. lease purchase PDF Split-Merge on to remove this watermark. 232 CHAPTER 13 Working with Report Items GroupsBeforeRowHeader Skips the specified number of column groups before displaying row headers. Tablix will display columns of data and then row headers. LayoutDirection A direction of column expansion. Left to right LTR default or right to left RTL . NoRowsMessage When a data set returns no results SSRS renders this message rather than an empty
