Đang chuẩn bị liên kết để tải về tài liệu:
Sams Microsoft SQL Server 2008- P7

Tham khảo tài liệu 'sams microsoft sql server 2008- p7', 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ả | Paging Report Improved in 2008 281 columns that you want to have and spacing between. Figure 15.3 shows a multicolumn report design example. FIGURE 15.3 Multicolumn report design. 15 Advanced Group Properties RepeatOnNewPage KeepTogether New in 2008 KeepWithGroup New in 2008 and HideIfNoRows New in 2008 These properties are accessible in the Advanced mode of the grouping pane and enable you to do the following RepeatOnNewPage Repeat the group s row header on every page where the group has at least one row. KeepTogether Force SSRS to attempt keeping the entire group together on a page instead of inserting a page break between. Not supported for column groups. KeepWithGroup Help to keep the group s header and footer together on the same page instead of orphaning to another page. The property can have one of the following values Before Keep this static member mostly footer with the previous group in a grouping pane. Note gray static members in the grouping pane. After Keep this static member mostly header with the previous group in a grouping pane. lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. 282 CHAPTER 15 Advanced Report Formatting None Let SSRS decide whether to use Before or After. HideIfNoRows Hide a static element of a group when the group has no data. This property overrides other Visibility properties. To access the Advanced mode display the grouping pane if not shown in BIDS select Report Grouping and using the arrow on the right side of the grouping pane select Advanced Mode and then select Tablix where you want to set those properties. Summary SSRS supports a comprehensive set of formatting capabilities through the report item s properties which control output appearance. Some of the key properties are as follows BackgroundColor Controls the background color of the item. When a report requires alternating colors for rows of output this property can be used in conjunction with functions RowNumber and Runningvalue. Color .