Appendix A: Report Item Reference


Report Objects

The first section of this appendix lists the report objects available in Reporting Services. These include the layout areas, the data regions, and the remaining report items. This section describes each object, including whether the object has its own custom properties dialog box, and lists all the properties for that object. Properties can be set in the Properties window or in the custom properties dialog box. The font of each property lets you know if the property can be set in the Properties window, the custom properties dialog box, or both. (See the following key.)

Layout Areas

KEY:

  • Property in Properties Window Only

  • Property in Properties Window and Custom Properties Dialog Box

  • Property in Custom Properties Dialog Box Only

Body

Description: The layout area containing the bulk of the report content

Custom Properties Dialog Box: No (The Columns and ColumnSpacing properties can be found in the custom properties dialog box for the report.)

Properties: BackgroundColor, BackgroundImage, BorderColor, BorderStyle, BorderWidth, Columns, ColumnSpacing, Size

Notes: If the Size: Width of the Body item added to the Margins: Left and Margins: Right of the Report item is wider than the PageSize: Width of the Report item, your report will span multiple pages horizontally.

Page Footer

Description: The layout area repeated at the bottom of each page. Can be enabled and disabled in the Report Properties dialog box or on the Report menu.

Custom Properties Dialog Box: No (The PrintOnFirstPage and PrintOnLastPage properties can be found in the custom properties dialog box for the report.)

Properties: BackgroundColor, BackgroundImage, BorderColor, BorderStyle, BorderWidth, PrintOnFirstPage, PrintOnLastPage, Size

Notes: You cannot include field values in the Page Footer.

Page Header

Description: The layout area repeated at the top of each page. Can be enabled and disabled in the Report Properties dialog box or on the Report menu.

Custom Properties Dialog Box: No (The PrintOnFirstPage and PrintOnLastPage properties can be found in the custom properties dialog box for the report.)

Properties: BackgroundColor, BackgroundImage, BorderColor, BorderStyle, BorderWidth, PrintOnFirstPage, PrintOnLastPage, Size

Notes: You cannot include field values in the Page Header.

Report

Description: The report is not a layout area itself but, rather, it is a container for the other layout areas.

Custom Properties Dialog Box: Yes

Properties: Author, AutoRefresh, Classes, CustomCode, DataElementName, DataElementStyle, DataSchema, DataTransform, Description, DescriptionLocID, DrawGrid, EmbeddedImages, GridSpacing, InteractiveSize, Language, Margins, PageSize, References, ReportParameters, SnapToGrid

Notes: If the Size: Width of the Body item added to the Margins: Left and Margins: Right of the Report item is wider than the PageSize: Width of the Report item, your report will span multiple pages horizontally.

Data Regions

KEY:

  • Property in Properties Window Only

    Property in Properties Window and Custom Properties Dialog Box

    Property in Custom Properties Dialog Box Only

Chart

Description: A business graphic such as a line graph or a pie chart. The chart is the only data region that cannot contain other report items.

Custom Properties Dialog Box: Yes

Properties: BackgroundColor, BackgroundImage, Bookmark, BorderColor, BorderStyle, BorderWidth, Calendar, ChartAreaBorderAndLineStyle, ChartAreaFillStyle, Clustered, Color, Cylinder, DataElementName, DataElementOutput, DataSetName, Direction, DisplayChartWith3-DVisualEffect, DisplayLegendInsidePlotArea, Filters, Font, Format, HorizontalRotation, Label, LabelLocID, Language, LegendBorderAndLine Style, LegendFillStyle, LegendFontStyle, LegendLayout, LegendPosition, LineHeight, Location, Name, NoRows, NumeralLanguage, NumeralVariant, Orthographic, Padding, PageBreakAtEnd, PageBreakAtStart, Palette, Parent, Perspective, PlotAreaBorderAndLineStyle, PlotAreaFillStyle, PointWidth, Shading, ShowLegend, Size, Subtype, TextAlign, TextDecoration, Title, TitleFontStyle, ToolTip, ToolTipLocID, Type, UnicodeBiDi, VerticalAlign, VerticalRotation, Visibility, WallThickness, WritingMode, X-AxisFormatting, Y-Axis Formatting

Chart Category Group

Description: Controls the category groupings on the chart. These usually form the x-axis of the chart.

Custom Properties Dialog Box: Yes

Properties: DataElementCollection, DataElementName, DataElementOutput, Filters, Group On, Label, Name, Parent Group, Sorting

Chart Series Group

Description: Controls the series groupings on the chart. The series comes into play when there is more than one data point for each category grouping.

Custom Properties Dialog Box: Yes

Properties: DataElementCollection, DataElementName, DataElementOutput, Filters, Group On, Label, Name, Parent Group, Sorting

Chart Value

Description: Controls the values placed on the chart

Custom Properties Dialog Box: Yes

Properties: Action, Angle, DataElementName, DataElementOutput, DataLabel, Format, JumpToBookmark, JumpToReport, JumpToReportParameters, JumpToURL, LabelFontStyle, MarkerSize, MarkerType, PlotDataAsLine, Position, SeriesLabel, ShowMarkers, ShowPointLabels, Value

List

Description: A freeform layout area that can be tied to a dataset

Custom Properties Dialog Box: Yes

Properties: BackgroundColor, BackgroundImage, Bookmark, BorderColor, BorderStyle, BorderWidth, Calendar, Color, DataElementName, DataElementOutput, DataInstanceElementOutput, DataInstanceName, DataSetName, Direction, Filters, Font, Format, Grouping, KeepTogether, Label, LabelLocID, Language, LineHeight, Location, Name, NoRows, NumeralLanguage, NumeralVariant, Padding, PageBreakAtEnd, PageBreakAtStart, Parent, Size, Sorting, TextAlign, TextDecoration, ToolTip, ToolTipLogID, UnicodeBiDi, VerticalAlign, Visibility, WritingMode

List Details Group

Description: Grouping at the detail level in a list

Custom Properties Dialog Box: Yes

Properties: DataElementCollection, DataElementName, DataElementOutput, Filters, Group On, Label, Name, PageBreakAtStart, PageBreakAtEnd, Parent Group, Visibility

Matrix

Description: A pivot table for viewing row and column data

Custom Properties Dialog Box: Yes

Properties: BackgroundColor, BackgroundImage, Bookmark, BorderColor, BorderStyle, BorderWidth, Calendar, CellDataElementName, CellDataElementOutput, Color, DataElementName, DataElementOutput, DataSetName, Direction, Filters, Font, Format, GroupsBeforeRowHeaders, KeepTogether, Label, LabelLocID, Language, LayoutDirection, LineHeight, Location, Name, NoRows, NumeralLanguage, NumeralVariant, Padding, PageBreakAtEnd, PageBreakAtStart, Parent, Size, TextAlign, TextDecoration, ToolTip, ToolTipLocID, UnicodeBiDi, VerticalAlign, Visibility, WritingMode

Matrix Column

Description: Defines the appearance of a column in a matrix

Custom Properties Dialog Box: No

Properties: BackgroundColor, BackgroundImage, BorderColor, BorderStyle, BorderWidth, Calendar, Color, Direction, Font, Format, Language, LineHeight, NumeralLanguage, NumeralVariant, Padding, TextAlign, TextDecoration, UnicodeBiDi, VerticalAlign, Width, WritingMode

Matrix Column Group

Description: Defines the data that makes up each column in a matrix

Custom Properties Dialog Box: Yes

Properties: DataElementCollection, DataElementName, DataElementOutput, Filters, FixedHeader, GroupOn, Label, Name, ParentGroup, Sorting, Visibility

Matrix Row

Description: Defines the appearance of a row in a matrix

Custom Properties Dialog Box: No

Properties: BackgroundColor, BackgroundImage, BorderColor, BorderStyle, BorderWidth, Calendar, Color, Direction, Font, Format, Height, Language, LineHeight, NumeralLanguage, NumeralVariant, Padding, TextAlign, TextDecoration, UnicodeBiDi, VerticalAlign, WritingMode

Matrix Row Group

Description: Defines the data that makes up each row in a matrix

Custom Properties Dialog Box: Yes

Properties: DataElementCollection, DataElementName, DataElementOutput, Filters, FixedHeader, GroupOn, Label, Name, PageBreakAtEnd, PageBreakAtStart, ParentGroup, Sorting, Visibility

Matrix Subtotal

Description: Defines the formatting for a subtotal cell in a matrix

Custom Properties Dialog Box: No

Properties: BackgroundColor, BackgroundImage, BorderColor, BorderStyle, BorderWidth, Calendar, Color, DataElementName, DataElementOutput, Direction, Font, Format, Language, LineHeight, NumeralLanguage, NumeralVariant, Padding, Position, TextAlign, TextDecoration, UnicodeBiDi, VerticalAlign, WritingMode

Table

Description: A table for viewing columnar data

Custom Properties Dialog Box: Yes

Properties: BackgroundColor, BackgroundImage, Bookmark, BorderColor, BorderStyle, BorderWidth, Calendar, Color, DataElementName, DataElementOutput, DataSetName, DetailDataCollectionName, DetailDataElementName, DetailDataElementOutput, Direction, Filters, FixedHeader, Font, Format, KeepTogether, Label, LabelLocID, Language, LineHeight, Location, Name, NoRows, NumeralLanguage, NumeralVariant, Padding, PageBreakAtEnd, PageBreakAtStart, Parent, RepeatFooterOnNewPage, RepeatHeaderOnNewPage, Size, Sorting, TextAlign, TextDecoration, ToolTip, ToolTipLocID, UnicodeBiDi, VerticalAlign, Visibility, WritingMode

Table Column

Description: Defines the appearance of a column in a table

Custom Properties Dialog Box: No

Properties: BackgroundColor, BackgroundImage, BorderColor, BorderStyle, BorderWidth, Calendar, Color, Direction, FixedHeader, Font, Format, Language, LineHeight, NumeralLanguage, NumeralVariant, Padding, TextAlign, TextDecoration, UnicodeBiDi, VerticalAlign, Visibility, Width, WritingMode

Table Details Group

Description: Grouping at the detail level in a table

Custom Properties Dialog Box: Yes

Properties: DataElementCollection, DataElementName, DataElementOutput, Filters, GroupOn, Label, Name, PageBreakAtEnd, PageBreakAtStart, ParentGroup, Visibility

Table Group

Description: Defines the data that makes up a group in the table

Custom Properties Dialog Box: Yes

Properties: DataElementCollection, DataElementName, DataElementOutput, Filters, GroupOn, IncludeGroupFooter, IncludeGroupHeader, Label, Name, PageBreakAtEnd, PageBreakAtStart, ParentGroup, RepeatFooterOnNewPage, RepeatHeaderOnNewPage, Sorting, Visibility

Table Row

Description: Defines the appearance of a row in a table

Custom Properties Dialog Box: No

Properties: BackgroundColor, BackgroundImage, BorderColor, BorderStyle, BorderWidth, Calendar, Color, Direction, Font, Format, Grouping, Grouping/Sorting, Height, Language, LineHeight, NumeralLanguage, NumeralVariant, Padding, TextAlign, TextDecoration, UnicodeBiDi, VerticalAlign, Visibility, WritingMode

Notes: The Grouping property appears for the detail table row. The Grouping/Sorting property appears for the other types of table rows. The Grouping/Sorting property displays the correct information, but it displays it in the Details Grouping dialog box rather than the Grouping and Sorting Properties dialog box. (This is a bug.) The RepeatOnNewPage property does not appear for a detail table row.

Report Items

KEY:

  • Property in Properties Window Only

  • Property in Properties Window and Custom Properties Dialog Box

  • Property in Custom Properties Dialog Box Only

Image

Description: Places a graphic on the report

Custom Properties Dialog Box: Yes

Properties: Action, Bookmark, BorderColor, BorderStyle, BorderWidth, JumpToBookmark, JumpToReport, JumpToReportParameters, JumpToURL, Label, LabelLocID, Location, MIMEType, Name, Padding, Parent, RepeatWith, Size, Sizing, Source, ToolTip, ToolTipLocID, Value, Visibility

Line

Description: Places a line on the report

Custom Properties Dialog Box: Yes

Properties: Bookmark, EndPoint, Label, LabelLocID, LineColor, LineStyle, Line Width, Location, Name, Parent, RepeatWith, Visibility

Rectangle

Description: Places a rectangle on the report

Custom Properties Dialog Box: Yes

Properties: BackgroundColor, BackgroundImage, Bookmark, BorderColor, BorderStyle, BorderWidth, DataElementName, DataElementOutput, Label, LabelLocID, LinkToChild, Location, Name, PageBreakAtEnd, PageBreakAtStart, Parent, RepeatWith, Size, ToolTip, ToolTipLocID, Visibility

Subreport

Description: Inserts one report into another

Custom Properties Dialog Box: Yes

Properties: Bookmark, BorderColor, BorderStyle, BorderWidth, Calendar, Color, DataElementName, DataElementOutput, Direction, Font, Format, Label, LabelLocID, Language, LineHeight, Location, MergeTransactions, Name, NoRows, NumeralLanguage, NumeralVariant, Padding, Parameters, Parent, ReportName, Size, TextAlign, TextDecoration, ToolTip, ToolTipLocID, UnicodeBiDi, VerticalAlign, Visibility, WritingMode

Text Box

Description: Places a text box on the report

Custom Properties Dialog Box: Yes

Properties: Action, BackgroundColor, BackgroundImage, Bookmark, BorderColor, BorderStyle, BorderWidth, Calendar, CanGrow, CanShrink, Color, DataElementName, DataElementOutput, DataElementStyle, Direction, Font, Format, HideDuplicates, InitialToggleState, JumpToBookmark, JumpToReport, JumpToReportParameters, JumpToURL, Label, LabelLocID, Language, LineHeight, Location, Name, NumeralLanguage, NumeralVariant, Padding, Parent, RepeatWith, Size, TextAlign, TextDecoration, ToolTip, ToolTipLocID, UnicodeBiDi, UserSort, Value, ValueLocID, VerticalAlign, Visibility, WritingMode




Microsoft SQL Server 2005 Reporting Services
MicrosoftВ® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))
ISBN: 0735622507
EAN: 2147483647
Year: 2007
Pages: 115

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net