SSRS report basic structure and settings

SSRS Report basic structure and Settings

The structure of the Rain Foundation for the entire report design can be divided into four main areas, such as header (page header), footer (page Footer), body (body), and data, as shown in. In the design screen, only the body and the data area are displayed by default, if you need to open the header or footer, you must right click on the outside of the body, open the header and footer area, you can display and design.

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;margin:0px;padding-left:0px ;p adding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clip_image002 "alt=" clip_image002 " Src= "http://s3.51cto.com/wyfs02/M02/58/CF/wKioL1S9wDuicrs4AAHfrwH9Js0854.jpg" border= "0" height= "570"/>

Headers and footers are primarily used to place descriptive information that is common to the entire report, such as page numbers, date of tabulation, auditing units, and so on. It is important to note that because the header and headers are descriptive areas, there is a logical limit to the entry in the header footer, so the designer is not allowed to place data region conditions such as data tables, matrices, lists, etc., as well as built-in columns such as footers, which are used only for header and footer areas.

1. Reports

After you understand the report design area, you can then set the report properties.

n Click "Report" from the drop-down options in the "Properties" window to modify the basic settings of the reports.

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;margin:0px;padding-left:0px ;p adding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clip_image004 "alt=" clip_image004 " Src= "http://s3.51cto.com/wyfs02/M02/58/CF/wKioL1S9wD3wsiueAACPVzYFBKw529.jpg" border= "0" height= "241"/>

n Right-click on the outside of the report body and select "Report Properties" to go to the Reports property dialog box. In fact, the content is the same as the above, but the property settings are packaged as a visual interface, so it is easier to operate.

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;margin:0px;padding-left:0px ;p adding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clip_image006 "alt=" clip_image006 " Src= "http://s3.51cto.com/wyfs02/M00/58/CF/wKioL1S9wEGwHiYWAAE06SsXtBI980.jpg" border= "0" height= "504"/>

It is worth mentioning that the Columns property, with the columns attribute can be cut vertically to produce a finer layout effect, is to set the Coumns property to 2 after the result.

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;margin:0px;padding-left:0px ;p adding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clip_image008 "alt=" clip_image008 " Src= "http://s3.51cto.com/wyfs02/M01/58/CF/wKioL1S9wETgSeU3AACJZaDC-1g445.jpg" border= "0" height= "243"/>

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;margin:0px;padding-left:0px ;p adding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clip_image010 "alt=" clip_image010 " Src= "http://s3.51cto.com/wyfs02/M02/58/CF/wKioL1S9wEnAVYeVAAE3SGUVF8U292.jpg" border= "0" height= "467"/>

When setting the report properties related to length, it is important to note that Report Designer determines whether to use centimeters (cm) or inches (in) as a unit of measure based on the "region and Language" setting in the current operating system.

2. Headers and footers

In the report format, you typically use the header and footer areas to place notes items about the report, including company logos, report topics, page numbers, and so on, usually header (page header) and footer (page Footer) The same content is repeated from the first page of the report to the last page. Header and footer settings are also available in SSRS, but only text boxes, images, and borders are currently available, and it is forbidden to place data regions, subreports, or any data region criteria in Header (page header) and footer (page Footer).

To add a header (page header), footer (page Footer), first switch to the Design tab of the report. There are several ways to turn off the header footer:

N Select the "Report", "Add page Header" or "Add page Footer" Options on the Function menu.

n Right-click directly around the body of the report to add a header footer.

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;margin:0px;padding-left:0px ;p adding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clip_image012 "alt=" clip_image012 " Src= "http://s3.51cto.com/wyfs02/M00/58/CF/wKioL1S9wEqhJEsYAACp1phQzAQ978.jpg" border= "0" height= "177"/>

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;margin:0px;padding-left:0px ;p adding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clip_image014 "alt=" clip_image014 " Src= "http://s3.51cto.com/wyfs02/M01/58/CF/wKioL1S9wEyi_pjUAACbagDZNY4840.jpg" border= "0" height= "202"/>

Where the SSRS default header (page header) and footer (page Footer) appear on the first and last page of the report (that is, Printonfirstpage and Printonlastpage are true), to change this setting, You must change the property value yourself.

3. Main body

A report body (body) is an area that is used to display the main content of a report. In addition to having a table, matrix, list, and so on, a data region (which displays data from a dataset) in a report body, you can also place other standalone report items to help beautify the report, and in the Properties Window drop-down menu, just select Body To set the appropriate properties.

650) this.width=650; "Style=" background-image:none;border-bottom:0px;border-left:0px;padding-left:0px; padding-right:0px;border-top:0px;border-right:0px;padding-top:0px; "title=" clip_image016 "alt=" clip_image016 "src = "Http://s3.51cto.com/wyfs02/M00/58/D2/wKiom1S9v3nCIw8aAACTHYkXsiI958.jpg" border= "0" height= "242"/>

This article is from the SQL Server deep dives blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1606024

SSRS report basic structure and settings