MicrosoftВ® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))
This section describes the properties of the report objects. The property is listed only once, even if it is a property of several objects. If the property can be set in a custom properties dialog box, the explanation notes the tab where this property appears.
Some properties serve as a summary of several properties in the Properties window. BackgroundImage and BorderColor are two examples of these summary properties. A plus (+) sign to the left of a property in the Properties window tells you it is a summary property and has several detail properties beneath it. Click the plus sign to expand the summary property, so you can view and change the value of the detail properties.
In this section, the Detail Properties: entry signals this property is a summary property, which contains several detail properties. The detail properties are explained in the Notes: entry for the summary property.
Properties
Action
Description: Specifies which type of hyperlink action this item will execute.
When to Use: The report item is to cause the Report Viewer to navigate to a bookmark in this report, to another report, or to a website.
Notes: Linking to a bookmark or to another report works only in the Report Viewer or in the HTML and MHTML rendering formats. Linking to a website works only in the Report Viewer and the HTML, MHTML, PDF, and Excel rendering formats.
Property Of: Chart Value, Image, Text Box
Custom Properties Dialog Box Location: Navigation tab (Action tab for a chart value)
Angle
Description: Adjusts the angle of the point labels on a chart.
When to Use: A chart is to include labels on each data point, and the labels need to be rotated to an orientation other than horizontal.
Notes: Rotating data point labels to a 90-degree angle or a −90-degree angle helps fit more information in a tight space.
Property Of: Chart Value
Custom Properties Dialog Box Location: Edit Chart Value dialog box—Point Labels tab
Author
Description: Records the author of the report.
When to Use: The author’s name is to be stored with the report.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—General tab
AutoRefresh
Description: Sets the number of seconds for the report to automatically reexecute when being displayed in the Report Viewer.
When to Use: The report shows constantly changing information and is viewed in the Report Viewer.
Notes: AutoRefresh only works in the Report Viewer in Report Manager. AutoRefresh does not work on the Visual Studio Preview tab or in any of the export formats.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—General tab
BackgroundColor
Description: Sets the fill color for the item.
When to Use: An item is to have its own fill color.
Property Of: Body, Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Page Header, Page Footer, Rectangle, Table, Table Column, Table Row, Text Box
BackgroundImage
Description: Selects a graphic to fill the background of an item.
When to Use: An item is to have its own fill from a graphic.
Notes: The Source detail property specifies whether the image is embedded, external, in a database, or from a URL. The Value detail property contains the name of the image. The MIMEType detail property contains the MIME type of the image. The BackgroundRepeat detail property specifies how the image is repeated, if it does not fill the entire report object.
Property Of: Body, Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Page Header, Page Footer, Rectangle, Table, Table Column, Table Row, Text Box
Detail Properties: Source, Value, MIMEType, BackgroundRepeat
Bookmark
Description: Creates a named bookmark in a report.
When to Use: A Chart Value, Image, or Text Box is to serve as a hyperlink to this report item.
Notes: The Bookmark serves as the target for a hyperlink jump within the same report. Clicking a Chart Value, Image, or Text Box whose JumpToBookmark property matches this report item’s Bookmark property causes the Report Viewer to jump to this report item. Bookmarks work only in the HTML and MHTML rendering formats.
Property Of: Chart, Image, Line, List, Matrix, Rectangle, Subreport, Table, Text Box
Custom Properties Dialog Box Location: Navigation tab
BorderColor
Description: The color of the border around the outside of the report item
When to Use: A non-black border is to be around this report item.
Notes: The value in the Default detail property is used as the value for the Left, Right, Top, and Bottom detail properties, unless a value is specified for the detail property itself. The Left, Right, Top, and Bottom detail properties control the color for the individual sides of the report object.
Property Of: Body, Chart, Image, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Page Header, Page Footer, Rectangle, Subreport, Table, Table Column, Table Row, Text Box
Detail Properties: Default, Left, Right, Top, Bottom
BorderStyle
Description: The style (none, solid, dotted, dashed, and so forth) of the border around the outside of the report item
When to Use: A border is to be around this report item.
Notes: A border is displayed only when the BorderStyle property is set to a value other than None. Some of the more complex border styles, such as double and groove, are not clearly visible unless the corresponding BorderWidth property is set to a value larger than 1 point. The value in the Default detail property is used as the value for the Left, Right, Top, and Bottom detail properties, unless a value is specified for the detail property itself. The Left, Right, Top, and Bottom detail properties control the style for the individual sides of the report object.
Property Of: Body, Chart, Image, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Page Header, Page Footer, Rectangle, Subreport, Table, Table Column, Table Row, Text Box
Detail Properties: Default, Left, Right, Top, Bottom
BorderWidth
Description: The width of the border around the outside of the report item
When to Use: A border is to be around this report item with a width other than 1 point.
Notes: The value in the Default detail property is used as the value for the Left, Right, Top, and Bottom detail properties, unless a value is specified for the detail property itself. The Left, Right, Top, and Bottom detail properties control the width for the individual sides of the report object.
Property Of: Body, Chart, Image, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Page Header, Page Footer, Rectangle, Subreport, Table, Table Column, Table Row, Text Box
Detail Properties: Default, Left, Right, Top, Bottom
Calendar
Description: The calendar to use when dealing with date values in this report item
When to Use: A calendar other than the Gregorian calendar is to be used with date values in this report item.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
CanGrow
Description: Specifies whether a text box can grow vertically to display the entire contents of the Value property.
When to Use: The expected length of the Value property contents is not known or may vary.
Notes: Text boxes can grow in the vertical direction, but not in the horizontal direction.
Property Of: Text Box
Custom Properties Dialog Box Location: Text Box Properties—Format tab
CanShrink
Description: Specifies whether a text box can shrink vertically to remove any blank lines after the content of the Value property is displayed.
When to Use: The expected length of the Value property contents is not known or may vary.
Property Of: Text Box
Custom Properties Dialog Box Location: Text Box Properties—Format tab
CellDataElementName
Description: The name to be used for the element or attribute used to identify the cell data when exporting to the XML-rendering format.
When to Use: The report is to be exported using the XML-rendering format.
Property Of: Matrix
Custom Properties Dialog Box Location: Matrix Properties—Data Output tab
CellDataElementOutput
Description: Specifies whether the cell data is output when exporting to the XML-rendering format.
When to Use: The report is to be exported using the XML-rendering format.
Property Of: Matrix
Custom Properties Dialog Box Location: Matrix Properties—Data Output tab
ChartAreaBorderAndLineStyle
Description: The format of the line surrounding the entire chart item
When to Use: A line is to be around the entire chart item.
Notes: The Style detail property controls the style, the Width detail property controls the width, and the Color detail property controls the color of the line.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—General tab
Detail Properties: Style, Width, Color
ChartAreaFillStyle
Description: The fill behind the entire chart area
When to Use: The Chart item is to have its own fill color.
Notes: The fill can be a single color or a two-color gradient. The Color detail property contains the color of the area or is the first color in a two-color gradient when the Gradient detail property is true. The Gradient detail property specifies whether this is a single-color fill (false) or a two-color gradient (true). The EndColor detail property contains the second color in a two-color gradient.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—General tab
Detail Properties: Color, Gradient, End Color
Classes
Description: The classes (assemblies) referenced by this report, which include nonshared properties or methods.
When to Use: Nonshared properties or methods from an assembly are to be referenced by one or more expressions in the report.
Notes: The ClassName detail property contains a list of classes, contained in external assemblies, referenced by this report. The InstanceName detail property contains the name of an object (or instance) created from this class.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—References tab
Detail Properties: ClassName, InstanceName
Clustered
Description: Specifies that a series in a 3-D chart is to be shown front-to-back, rather than side-to-side.
When to Use: Depth is to be added to a 3-D chart to aid analysis or to add interest.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—3-D Effect tab
Color
Description: The foreground color
When to Use: A foreground color other than black is to be used.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
Columns
Description: The number of columns in the report body
When to Use: The report body is to have multiple columns.
Property Of: Body
ColumnSpacing
Description: The amount of space between multiple columns
When to Use: The report body is to have multiple columns with a separation other than 0.5 inch.
Property Of: Body
CustomCode
Description: Visual Basic functions and subroutines to be embedded in the report
When to Use: The report requires Visual Basic code too complex to put in a property value.
Property Of: Report
Cylinder
Description: Specifies that bars and columns in a 3-D chart are to be cylinders, rather than rectangular solids.
When to Use: Interest and variety is to be added to a 3-D chart.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—3-D Effect tab
DataElementCollection
Description: The name of the element to contain all instances of this group when exporting to the XML-rendering format.
When to Use: This group is to be included when exporting to the XML-rendering format.
Property Of: Chart Category Group, Chart Series Group, List Details Group, Matrix Column Group, Matrix Row Group, Table Details Group, Table Group
Custom Properties Dialog Box Location: Data Output tab
DataElementName
Description: The name to use for the element or attribute when exporting to the XML-rendering format.
When to Use: The report is to be exported using the XML-rendering format.
Property Of: Chart, Chart Category Group, Chart Series Group, Chart Value, List, List Details Group, Matrix, Matrix Column Group, Matrix Row Group, Matrix Subtotal, Rectangle, Report, Subreport, Table, Table Details Group, Table Group, Text Box
Custom Properties Dialog Box Location: Data Output tab
DataElementOutput
Description: Specifies whether this item is output when exporting to the XML-rendering format
When to Use: The report is to be exported using the XML-rendering format.
Property Of: Chart, Chart Category Group, Chart Series Group, Chart Value, List, List Details Group, Matrix, Matrix Column Group, Matrix Row Group, Matrix Subtotal, Rectangle, Subreport, Table, Table Details Group, Table Group, Text Box
Custom Properties Dialog Box Location: Data Output tab
DataElementStyle
Description: Specifies whether this item is output as an element or an attribute when exporting to the XML-rendering format
When to Use: The report is to be exported using the XML-rendering format.
Property Of: Report, Text Box
Custom Properties Dialog Box Location: Data Output tab
DataInstanceElementOutput
Description: Specifies whether the list instances are output when exporting to the XML-rendering format.
When to Use: The report is to be exported using the XML-rendering format.
Property Of: List
Custom Properties Dialog Box Location: List Properties—Data Output tab
DataInstanceName
Description: The name to use for the element when exporting to the XML-rendering format
When to Use: The report is to be exported using the XML-rendering format.
Property Of: List
Custom Properties Dialog Box Location: List Properties—Data Output tab
DataLabel
Description: The label to be used for data points on the chart.
When to Use: The data points on the chart are to be labeled.
Property Of: Chart Value
Custom Properties Dialog Box Location: Edit Chart Value—Point Labels tab
DataSchema
Description: The schema name used when exporting to the XML-rendering format.
When to Use: The report is to be exported using the XML-rendering format.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—Data Output tab
DataSetName
Description: The name of the dataset to be used with the data region.
When to Use: A dataset is to be used with a data region.
Property Of: Chart, List, Matrix, Table
Custom Properties Dialog Box Location: General tab (For chart, it is on the Data tab.)
DataTransform
Description: The name of a transform (XSLT document) to be applied after the report has been exported using the XML-rendering format.
When to Use: The XML document created by the export is to be transformed into another document format.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—Data Output tab
Description
Description: The description of the report
When to Use: The report’s description is to be stored with the report.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—General tab
DescriptionLocID
Description: The localization identifier (language and culture, for example: “en-us”) for a description property
When to Use: The report’s description has been localized.
Property Of: Report
DetailDataCollectionName
Description: The name of the element to contain all instances of this group when exporting to the XML-rendering format.
When to Use: This group is to be included when exporting to the XML-rendering format.
Property Of: Table
Custom Properties Dialog Box Location: Table Properties—Data Output tab
DetailDataElementName
Description: The name to be used for the element or attribute used to identify the detail data when exporting to the XML-rendering format.
When to Use: The report is to be exported using the XML-rendering format.
Property Of: Table
Custom Properties Dialog Box Location: Table Properties—Data Output tab
DetailDataElementOutput
Description: Specifies whether this item is output when exporting to the XML-rendering format.
When to Use: The report is to be exported using the XML-rendering format.
Property Of: Table
Custom Properties Dialog Box Location: Table Properties—Data Output tab
Direction
Description: The writing direction to use with this item, either left-to-right or right-to-left.
When to Use: A character set that is written right-to-left is being used in this item.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
Custom Properties Dialog Box Location: Text Box Properties, Advanced—Format tab (for text box)
DisplayChartWith3-DVisualEffect
Description: Specifies whether to make a chart 3-D.
When to Use: Readability or interest is to be added by making a chart three-dimensional.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—3-D Effect tab
DisplayLegendInsidePlotArea
Description: Specifies whether to display the chart legend inside the chart-plotting area.
When to Use: Space can be saved by placing the chart’s legend in an unused portion of the plotting area.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—Legend tab
DrawGrid
Description: Specifies whether the layout grid is shown on the Layout tab.
When to Use: The layout grid dots are not wanted on the Layout tab.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—General tab
EmbeddedImages
Description: The collection of graphics embedded in the report
When to Use: Images are to be embedded in the report.
Property Of: Report
EndPoint
Description: The coordinates of the end of the line
When to Use: A line is to be positioned on the report.
Notes: The Horizontal and Vertical detail properties specify the location of the end of the line.
Property Of: Line
Detail Properties: Horizontal, Vertical
Filters
Description: One or more expressions to exclude certain records from the dataset
When to Use: The dataset contains records not desired in the data region, and these records cannot or should not be removed by the dataset query.
Notes: The detail properties combine to build a set of filter expressions. Only records in the dataset that satisfy this set of filter expressions are included in the data region or grouping.
Property Of: Chart, Chart Category Group, Chart Series Group, List, List Details Group, Matrix, Matrix Column Group, Matrix Row Group, Table, Table Details Group, Table Group
Custom Properties Dialog Box Location: Filters tab
Detail Properties: Expression, Operator, Value, And/Or
FixedHeader
Description: Flag to freeze a group header on the screen during scrolling
When to Use: The group header should not scroll off the screen.
Property Of: Matrix Column Group, Table, TableColumn
Font
Description: The specification of the font to be used to render text within this item
When to Use: A font other than Normal, Arial, 10 point is desired.
Notes: The FontStyle detail property specifies whether the font is normal or italicized. The FontFamily detail property contains the name of the font. The FontSize detail property specifies the size of the font in points. The FontWeight detail property specifies the thickness of the font and is used to create bold text. (Underlining is controlled by the TextDecoration property.)
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
Detail Properties: FontStyle, FontFamily, FontSize, FontWeight
Format
Description: A formatting string to control the appearance of a value
When to Use: An appearance other than the default appearance of a value is required for better readability.
Property Of: Chart, Chart Value, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
Custom Properties Dialog Box Location: Text Box Properties—Format tab (for text box) or Edit Chart Value—Point Labels tab (for chart value)
GridSpacing
Description: The distance between layout grid points
When to Use: A distance other than 0.125 inch is desired between grid points.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—General tab
Grouping
Description: The grouping information for the detail level of the data region
When to Use: The detail level of this data region is to be a group.
Property Of: List, Table Row
Notes: This property displays the Detail Grouping dialog box.
Grouping/Sorting
Description: The grouping and sorting information for a header-level or footer-level table row
When to Use: Data is to be grouped or sorted.
Property Of: Table Row
Notes: This property displays the Detail Grouping dialog box. (This is the correct dialog box with the correct information, but it has a misleading title. The information in the dialog box applies to the group this table row belongs to. It is not the information for the detail level as the title would suggest.)
GroupOn
Description: The grouping expression
When to Use: Data is to be grouped when displayed by this data region.
Property Of: Chart Category Group, Chart Series Group, List Details Group, Matrix Column Group, Matrix Row Group, Table Details Group, Table Group
Custom Properties Dialog Box Location: General tab
GroupsBeforeRowHeaders
Description: The number of columns to appear to the left of the row headers (reverse this if you’re using a right-to-left matrix)
When to Use: The row headers are to appear in the matrix, rather than to the left (or right) of it.
Property Of: Matrix
Custom Properties Dialog Box Location: Matrix Properties—General tab
Height
Description: The height of the row
When to Use: The row height is to be modified.
Property Of: Matrix Row, Table Row
HideDuplicates
Description: Specifies whether to hide duplicate values when the text box is repeated in a table column
When to Use: The value in the text box is to act as a group header, even though it is within the table detail rather than the group header.
Property Of: Text Box
Custom Properties Dialog Box Location: Table Properties—General tab
HorizontalRotation
Description: The horizontal rotation applied to a 3-D chart
When to Use: The horizontal rotation must be adjusted to provide the user with the optimum view of the chart data.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—3-D Effect tab
IncludeGroupFooter
Description: Specifies whether a footer row is to be included for this group
When to Use: Totals or other concluding information is to be displayed at the end of the table group.
Property Of: Table Group
Custom Properties Dialog Box Location: Grouping and Sorting Properties—General tab
IncludeGroupHeader
Description: Specifies whether a header row is to be included for this group
When to Use: Headers or other introductory information is to be displayed at the beginning of the table group.
Property Of: Table Group
Custom Properties Dialog Box Location: Grouping and Sorting Properties—General tab
InitialToggleState
Description: The initial state of the toggle graphic associated with this text box
When to Use: This text box is being used to control the visibility of another report item.
Property Of: Text Box
Custom Properties Dialog Box Location: Text Box Properties—Visibility tab
InteractiveSize
Description: The default page size of the report when it is viewed in an interactive renderer
When to Use: The page size of the report should be different when viewed in an interactive renderer than when viewed in a printed or fixed-page format.
Property Of: Report
JumpToBookmark
Description: The name of the bookmark to which this report item is to hyperlink
When to Use: This report item is to cause the Report Viewer to navigate to a bookmark in this report.
Notes: Linking to a bookmark works only in the Report Viewer or in the HTML- and MHTML-rendering formats.
Property Of: Chart Value, Image, Text Box
Custom Properties Dialog Box Location: Navigation tab (Action tab for a chart value)
JumpToReport
Description: The name of the report to which this report item is to hyperlink
When to Use: This report item is to cause the Report Viewer to navigate to another report.
Notes: Linking to another report works only in the Report Viewer or in the HTML- and MHTML-rendering formats.
Property Of: Chart Value, Image, Text Box
Custom Properties Dialog Box Location: Navigation tab (Action tab for a chart value)
JumpToReportParameters
Description: The parameters required by the report to which the item is to hyperlink
When to Use: This report item is to cause the Report Viewer to navigate to another report, and the target report requires report parameters.
Notes: The Parameter Name detail property contains a list of parameters for the hyperlinked report. The Parameter Value detail property contains a list of values to be assigned to each of those parameters.
Property Of: Chart Value, Image, Text Box
Custom Properties Dialog Box Location: Navigation tab (Action tab for a chart value)
Detail Properties: Parameter Name, Parameter Value
JumpToURL
Description: The URL to which this report item is to hyperlink
When to Use: This report item is to cause the Report Viewer to navigate to a website.
Notes: Linking to a website works only in the Report Viewer and the HTML-, MHTML-, PDF-, and Excel-rendering formats.
Property Of: Chart Value, Image, Text Box
Custom Properties Dialog Box Location: Navigation tab (Action tab for a chart value)
KeepTogether
Description: Specifies whether to attempt to keep this data region on one page
When to Use: The data region is to be kept on one page for better readability and analysis.
Property Of: List, Matrix, Table
Custom Properties Dialog Box Location: General tab
Label
Description: The document map label for this item
When to Use: The report is to include a document map, and this item is to be linked to one item in the document map.
Notes: The document map works only in the Report Viewer and in the PDF- and Excel-rendering formats.
Property Of: Chart, Chart Category Group, Chart Series Group, Image, Line, List, List Details Group, Matrix, Matrix Column Group, Matrix Row Group, Rectangle, Subreport, Table, Table Details Group, Table Group, Text Box
Custom Properties Dialog Box Location: General tab or Navigation tab
LabelFontStyle
Description: The font style of a chart point label
When to Use: The chart values are to have their own textual labels.
Notes: The FontFamily detail property contains the name of the font. The FontSize detail property specifies the size of the font in points. The FontStyle detail property specifies whether the font is normal or italicized. The FontWeight detail property specifies the thickness of the font and is used to create bold text. The Color detail property specifies the color of the type. The TextDecoration detail property specifies whether the text is underlined, lined through, or overlined.
Property Of: Chart Value
Custom Properties Dialog Box Location: Edit Chart Value—Point Labels tab
Detail Properties: FontFamily, FontSize, FontStyle, FontWeight, Color, TextDecoration
LabelLocID
Description: The localization identifier (language and culture, for example: “en-us”) for a document map label
When to Use: The document map label has been localized.
Property Of: Chart, Image, Line, List, Matrix, Rectangle, Subreport, Table, Text Box
Language
Description: The language being used to display values within this report item
When to Use: The language being used is something other than the default language on the computer.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Report, Subreport, Table, Table Column, Table Row, Text Box
LayoutDirection
Description: The direction in which matrix columns are built, either left-to-right or right-to-left
When to Use: A matrix must be built from right-to-left.
Property Of: Matrix
Custom Properties Dialog Box Location: Matrix Properties—General tab
LegendBorderAndLineStyle
Description: The border and line style for the chart legend
When to Use: The chart legend is to have a nondefault border.
Notes: The Style detail property controls the style of the line. The Width detail property controls the width of the line. The Color detail property controls the color of the line.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—Legend tab
Detail Properties: Style, Width, Color
LegendFillStyle
Description: The fill style for the chart legend
When to Use: The chart legend is to have its own fill style.
Notes: The fill can be a single color or a two-color gradient. The Color detail property contains the color of the area or is the first color in a two-color gradient when the Gradient detail property is true. The Gradient detail property specifies whether this is a single-color fill (false) or a two-color gradient (true). The EndColor detail property contains the second color in a two-color gradient.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—Legend tab
Detail Properties: Color, Gradient, End Color
LegendFontStyle
Description: The font style for the chart legend
When to Use: The chart legend is to have a nondefault font style.
Notes: The FontFamily detail property contains the name of the font. The FontSize detail property specifies the size of the font in points. The FontStyle detail property specifies whether the font is normal or italicized. The FontWeight detail property specifies the thickness of the font and is used to create bold text. The Color detail property specifies the color of the type. The TextDecoration detail property specifies whether the text is underlined, lined through, or overlined.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—Legend tab
Detail Properties: FontFamily, FontSize, FontStyle, FontWeight, Color, TextDecoration
LegendLayout
Description: Specifies whether the chart legend is laid out in columns, rows, or as a table
When to Use: The chart legend is to have a nondefault layout for better readability.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—Legend tab
LegendPosition
Description: The position of the chart legend relative to the plot area
When to Use: The chart legend is to have a nonstandard position.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—Legend tab
LineColor
Description: The color of the line
When to Use: The line is to have a color other than black.
Property Of: Line
LineHeight
Description: The height of a line of text within this report item
When to Use: The report item is to use a nonstandard line height.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
LineStyle
Description: The style of the line (solid, dashed, dotted, and so forth)
When to Use: The line is to have a style other than solid.
Property Of: Line
LineWidth
Description: The width of the line in points
When to Use: The line is to have a width other than 1 point.
Property Of: Line
LinkToChild
Description: The report item within the rectangle that will be the ultimate target of a document map entry that points to the rectangle
When to Use: A rectangle containing several report items is the target of a document map entry.
Property Of: Rectangle
Location
Description: The location of the report item within the layout area
When to Use: Every time an item is placed in a layout area.
Notes: The Left and Top detail properties specify the position of the upperleft corner of the report item in the layout area.
Property Of: Chart, Image, Line, List, Matrix, Rectangle, Subreport, Table, Text Box
Detail Properties: Left, Top
Margins
Description: The size of the margins on the report page
When to Use: The margins are to be something other than 1 inch.
Notes: If the body width plus the left and right margins are greater than the report page width, the report will span more than one page horizontally. The Left, Right, Top, and Bottom detail properties specify the size of each margin in inches.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—Layout tab
Detail Properties: Left, Right, Top, Bottom
MarkerSize
Description: The size of the marker placed for each data value on a chart
When to Use: Each data value is to be highlighted with a shape to mark its position.
Property Of: Chart Value
Custom Properties Dialog Box Location: Edit Chart Value—Appearance tab
MarkerType
Description: The shape used to mark each data value on a chart
When to Use: Each data value is to be highlighted with a shape to mark its position.
Property Of: Chart Value
Custom Properties Dialog Box Location: Edit Chart Value—Appearance tab
MergeTransactions
Description: Combines any transactions from a subreport with the transactions of the parent report
When to Use: The queries in both the parent report and the subreport initiate data modifications that should be committed only if both are successful.
Notes: Both reports must use the same data source.
Property Of: Subreport
MIMEType
Description: The MIME type of the graphic used to populate the image item
When to Use: The MIME type must be selected only when using an external image source such as a database. The MIME type is automatically detected for embedded images.
Property Of: Image
Name
Description: The name of the report item
When to Use: The report item will be referenced by another item in the report (for example, to control visibility).
Notes: Report item names must be unique within a report.
Property Of: Chart, Chart Category Group, Chart Series Group, Image, Line, List, List Details Group, Matrix, Matrix Column Group, Matrix Row Group, Rectangle, Subreport, Table, Table Details Group, Table Group, Text Box
Custom Properties Dialog Box Location: General tab
NoRows
Description: The message displayed in place of a data region when that data region’s dataset contains no rows
When to Use: A data region’s dataset may be empty.
Property Of: Chart, List, Matrix, Subreport, Table
NumeralLanguage
Description: The language to use when applying formatting to numeric output
When to Use: The numeral language is to be something other than the default for the computer.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
NumeralVariant
Description: The variant of the numeral language to use when applying formatting to numeric output
When to Use: The numeral language variant is to be something other than the default for the computer.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
Orthographic
Description: Specifies whether to present a 3-D chart as an orthographic projection
When to Use: An orthographic projection of a 3-D chart is to be used to provide the best view for analysis.
Notes: An orthographic projection represents the three dimensions as perpendicular to one another. The Perspective property is ignored when the Orthographic property is selected.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—3-D Effect tab
Padding
Description: The amount of empty space left around the sides of an item
When to Use: The amount of empty space is to be changed to improve the report’s presentation and readability.
Notes: The Left, Right, Top, and Bottom detail properties specify in points the white space on each side of the report item.
Property Of: Chart, Image, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
Custom Properties Dialog Box Location: Advanced Text Box Properties—Format tab (only for text box)
Detail Properties: Left, Right, Top, Bottom
PageBreakAtEnd
Description: Specifies whether a forced page break is to be inserted at the end of this report item
When to Use: A page break is to be forced to meet report-formatting needs.
Property Of: Chart, List, List Details Group, Matrix, Matrix Row Grouping, Rectangle, Table, Table Details Group, Table Group
Custom Properties Dialog Box Location: General tab
PageBreakAtStart
Description: Specifies whether a forced page break is to be inserted at the beginning of this report item
When to Use: A page break is to be forced to meet report-formatting needs.
Property Of: Chart, List, List Details Group, Matrix, Matrix Row Grouping, Rectangle, Table, Table Details Group, Table Group
Custom Properties Dialog Box Location: General tab
PageSize
Description: The size of the report page
When to Use: The report will be printed or exported to the PDF- or TIFF-rendering formats.
Notes: The Width detail property specifies the width of the report in inches. The Height detail property specifies the height of the report in inches.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—Layout tab
Detail Properties: Width, Height
Palette
Description: The color scheme to use for a chart
When to Use: A nondefault set of colors is to be used when creating a chart.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—General tab
Parameters
Description: The parameter values to be passed to a subreport
When to Use: The subreport is to receive values from the parent report to control the subreport’s content.
Notes: The Parameter Name detail property contains a list of parameters for the selected subreport. The Parameter Value detail property contains a list of values to be assigned to each of those parameters.
Property Of: Subreport
Custom Properties Dialog Box Location: Subreport Properties—Parameters tab
Detail Properties: Parameter Name, Parameter Value
Parent
Description: The report item that contains this item
When to Use: This is a read-only property controlled by the item’s location on the report layout.
Property Of: Chart, Image, Line, List, Matrix, Rectangle, Subreport, Table, Text Box
Parent Group
Description: The group that contains this group
When to Use: This is a read-only property maintained automatically by the group hierarchy.
Property Of: Chart Category Group, Chart Series Group, List Details Group, Matrix Column Group, Matrix Row Group, Table Details Group, Table Group
Custom Properties Dialog Box Location: General tab
Perspective
Description: The amount of perspective applied to a 3-D chart
When to Use: The default perspective of a 3-D chart is to be changed to improve readability or interest.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—3-D Effect tab
PlotAreaBorderAndLineStyle
Description: The format of the line surrounding the chart’s plot area
When to Use: The format of the chart’s plot area is to be changed from the 1-point, solid, black line.
Notes: The Style detail property controls the style of the line. The Width detail property controls the width of the line. The Color detail property controls the color of the line.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—General tab
Detail Properties: Style, Width, Color
PlotAreaFillStyle
Description: The fill behind the chart’s plotting area
When to Use: The chart’s plotting area is to have a fill color other than light gray.
Notes: The fill can be a single-color or a two-color gradient. The Color detail property contains the color of the area or is the first color in a two-color gradient when the Gradient detail property is true. The Gradient detail property specifies whether this is a single-color fill (false) or a two-color gradient (true). The EndColor detail property contains the second color in a two-color gradient.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—General tab
Detail Properties: Color, Gradient, End Color
PlotDataAsLine
Description: Specifies whether the chart data is to be represented by a line
When to Use: The chart data is to be represented by a line.
Property Of: Chart Value
Custom Properties Dialog Box Location: Edit Chart Value—Appearance tab
PointWidth
Description: Specifies the width, in points, of the column on a column chart or a bar on a bar chart
When to Use: The default width of the column or bar must be modified.
Property Of: Chart
Position
Description: The position of the chart value labels or the matrix subtotal
When to Use: The chart value label is to be placed in a position other than directly above the data point, or the matrix subtotal is to be placed above or before the detail, rather than below or after it.
Property Of: Chart Value, Matrix Subtotal
Custom Properties Dialog Box Location: Edit Chart Value—Point Labels tab. (This property does not appear in a custom properties dialog box for a Matrix Subtotal.)
PrintOnFirstPage
Description: Specifies whether the page header or page footer should print on the first page of the report
When to Use: The report contains a page header or footer that is not to be printed on the first page of the report.
Property Of: Page Header, Page Footer
Custom Properties Dialog Box Location: Report Properties—General tab
PrintOnLastPage
Description: Specifies whether the page header or page footer should print on the last page of the report.
When to Use: The report contains a page header or footer that is not to be printed on the last page of the report.
Property Of: Page Header, Page Footer
Custom Properties Dialog Box Location: Report Properties—General tab
References
Description: The custom assemblies referenced by the report
When to Use: A report expression is to make use of a property or method in a custom assembly.
Notes: The AssemblyName detail property contains a list of assemblies that are referenced by the report.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—References tab
Detail Properties: AssemblyName
RepeatFooterOnNewPage
Description: Specifies whether a footer should be repeated on each new page spanned by the table
When to Use: A table or table group contains a footer that is to be repeated on every page spanned by the table.
Property Of: Table, Table Group
Custom Properties Dialog Box Location: General tab
RepeatHeaderOnNewPage
Description: Specifies whether a header should be repeated on each new page spanned by the table
When to Use: A table or table group contains a header that is to be repeated on every page spanned by the table.
Property Of: Table, Table Group
Custom Properties Dialog Box Location: General tab
RepeatOnNewPage
Description: This table row should repeat on each page of the report
When to Use: One or more table rows should repeat on each page of the report for better report clarity.
Property Of: Table Row (Not a property of a detail table row)
RepeatWith
Description: The data region this report item should repeat with across multiple pages
When to Use: This report item is part of a heading that is to be repeated with a data region that spans multiple pages.
Property Of: Image, Line, Rectangle, Text Box
Custom Properties Dialog Box Location: General tab
ReportName
Description: The name of the report to be displayed in this subreport item
When to Use: The report name is always required when using a subreport item.
Property Of: Subreport
Custom Properties Dialog Box Location: Subreport Properties—General tab
ReportParameters
Description: The parameters used by this report
When to Use: User input is to be used in determining the content of this report.
Notes: The AllowNullValue detail property specifies whether each parameter can have a null value. The AllowBlankValue detail property specifies whether each parameter can have a blank value. The Available Values detail property contains a list of the valid values for each property, either as a list of constants or as a reference to a dataset. The DataType detail property specifies the data type of each parameter. The DefaultValues detail property contains a default value for each property, either as a constant value or as a reference to a dataset. The Name detail property contains the name of each property. The Prompt detail property contains the prompt string for each property.
Property Of: Report
Custom Properties Dialog Box Location: Report Parameters
Detail Properties: AllowNullValue, AllowBlank Value, Available Values, DataType, Default Values, Name, Prompt
SeriesLabel
Description: A portion of the label applied to the series on the chart
When to Use: The series label is to include information from the data value.
Notes: The series label is made up of the expression specified in the series grouping concatenated with the expression specified with the chart value.
Property Of: Chart Value
Custom Properties Dialog Box Location: Edit Chart Value—Values tab
Shading
Description: The type of shading used in a 3-D chart
When to Use: Shading other than simple shading is to be used with a 3-D chart to increase readability or enhance interest.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—3-D Effect tab
ShowLegend
Description: Specifies whether to show the chart legend
When to Use: The chart is to include a data series that must be identified by the legend.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—Legend tab
ShowMarkers
Description: Specifies whether to place a marker for each data value on a chart
When to Use: Each data value on a chart is to be highlighted with a shape to mark its position.
Property Of: Chart Value
Custom Properties Dialog Box Location: Edit Chart Value—Appearance tab
ShowPointLabels
Description: Specifies whether to label each data value on a chart
When to Use: Each data value on a chart is to be labeled to improve readability or analysis.
Property Of: Chart Value
Custom Properties Dialog Box Location: Edit Chart Values—Point Labels tab
Size
Description: The size of the report item
When to Use: Every time an item is placed in a layout area
Notes: The Width detail property contains the width of the report object in inches. The Height detail property contains the height of the report object in inches.
Property Of: Body, Chart, Image, List, Matrix, Page Header, Page Footer, Rectangle, Subreport, Table, Text Box
Detail Properties: Width, Height
Sizing
Description: The technique used to size a graphic within an image report item
When to Use: The graphic is to be sized using a technique other than the fit technique.
Notes: The AutoSize technique changes the size of the image report item, so the graphic completely fills it at its normal size. The Fit technique stretches the graphic to fit the dimensions of the image report item. The FitProportional technique shrinks or magnifies the graphic to fit the image report item, but retains its proportions of height to width. The Clip technique displays as much of the graphic, at its normal size, as will fit within the image report item; the remainder is clipped off.
Property Of: Image
SnapToGrid
Description: Specifies whether report-item corner points are aligned with the grid when they are placed on the report layout
When to Use: The report layout is not to be constrained by the grid.
Property Of: Report
Custom Properties Dialog Box Location: Report Properties—General tab
Sorting
Description: The expression used to order the dataset or data grouping
When to Use: The dataset or data grouping is to be presented in a sort order that is not provided by the dataset query.
Notes: The Expression detail property contains a list of expressions used to sort the contents of the data region or grouping. The Direction detail property specifies whether each sort is in ascending order or descending order.
Property Of: Chart Category Group, Chart Series Group, List, Matrix Column Group, Matrix Row Group, Table, Table Group
Custom Properties Dialog Box Location: Sorting tab
Detail Properties: Expression, Direction
Source
Description: The source of the graphic
When to Use: A source must be specified for each image report item.
Notes: A Database image is extracted from a binary large object (BLOB). An Embedded image is stored in the report itself. An External image is stored in the report project and deployed to the Report Manager with the report.
Property Of: Image
Custom Properties Dialog Box Location: Image Wizard
Subtype
Description: The specific type of chart
When to Use: A chart subtype must be specified for all chart types except a bubble chart.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—General tab
TextAlign
Description: The horizontal position of the text within a report item
When to Use: The text is to be centered or right-justified.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
TextDecoration
Description: The decoration (underline, overline, or line through) applied to the text
When to Use: The text is to be underlined, overlined, or struck through.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
Custom Properties Dialog Box Location: Text Box Properties—Font tab (only for text box)
Title
Description: The title of the chart
When to Use: The chart is to be given a title to provide better understanding of the data it contains.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—General tab
TitleFontStyle
Description: The font style of the chart title
When to Use: The chart is to have a title.
Notes: The FontFamily detail property contains the name of the font. The FontSize detail property specifies the size of the font in points. The FontStyle detail property specifies whether the font is normal or italicized. The FontWeight detail property specifies the thickness of the font and is used to create bold text. The Color detail property specifies the color of the type. The TextDecoration detail property specifies whether the text is underlined, lined through, or overlined.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—General tab
Detail Properties: FontFamily, FontSize, FontStyle, FontWeight, Color, TextDecoration
ToolTip
Description: The tool tip displayed for this report item
When to Use: The user is to be provided with additional information concerning a report item when interacting with the report.
Property Of: Chart, Image, List, Matrix, Rectangle, Subreport, Table, Text Box
Custom Properties Dialog Box Location: General tab
ToolTipLocID
Description: The localization identifier (language and culture, for example: “en-us”) for a ToolTip
When to Use: The ToolTip has been localized.
Property Of: Chart, Image, List, Matrix, Rectangle, Subreport, Table, Text Box
Type
Description: The general type of chart
When to Use: A general chart type must be specified for all charts.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—General tab
UnicodeBiDi
Description: The technique used for handling text rendered right-to-left embedded in a line of text rendered left-to-right or vice versa
When to Use: Multiple languages are to be included in the same text box, with one language rendered left-to-right and the other rendered right-to-left.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
UserSort
Description: The properties to facilitate a dynamic sort within the report
When to Use: The report is to include dynamic sorting.
Notes: The SortExpression detail property contains the expression which will be used for sorting. The SortExpressionScope detail property specifies the scope to which the sort is applied. The SortTarget detail property specifies the data region object, grouping, or data set to which the sort is applied.
Property Of: Text Box
Detail Properties: SortExpression, SortExpressionScope, SortTarget
Value
Description: Chart Value—An expression to determine the values to be charted; Image—The name of the graphic to be placed in the image item; Text Box—The text to be displayed in the text box.
When to Use: A value is required for a chart value, an image, or a text box.
Property Of: Chart Value, Image, Text Box
Custom Properties Dialog Box Location: Chart Value: Edit Chart Value—Values tab; Image: Image Wizard; Text Box: Text Box Properties—General tab
ValueLocID
Description: The localization identifier (language and culture, for example: “en-us”) for a value
When to Use: The value has been localized.
Property Of: Text Box
VerticalAlign
Description: The vertical position of the text within a report item
When to Use: The text is to be located in the middle or at the bottom.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
VerticalRotation
Description: The vertical rotation applied to a 3-D chart
When to Use: The vertical rotation must be adjusted to provide the user with the optimum view of the chart data.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—3-D Effect tab
Visibility
Description: Specifies whether a report item is visible on the report
When to Use: The report item is not to be visible on the report, or the report item’s visibility is to be toggled by another report item.
Notes: The Hidden detail property specifies whether this report item is visible or hidden. The ToggleItem detail property is a reference to another report item that will toggle the visibility of this report item.
Property Of: Chart, Image, Line, List, List Details Group, Matrix, Matrix Column Group, Matrix Row Group, Rectangle, Subreport, Table, Table Column, Table Details Group, Table Group, Table Row, Text Box
Custom Properties Dialog Box Location: Visibility tab
Detail Properties: Hidden, ToggleItem
WallThickness
Description: The thickness of the walls surrounding a 3-D chart
When to Use: The thickness of the walls surrounding a 3-D chart is to be adjusted to create the most pleasing chart representation.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—3-D Effect tab
Width
Description: The width of a column
When to Use: The column width is to be adjusted to the appropriate size for the data it contains.
Property Of: Matrix Column, Table Column
WritingMode
Description: Indicates whether the text is written left-to-right/top-to-bottom or top-to-bottom/right-to-left
When to Use: A character set that is written top-to-bottom/right-to-left is to be used.
Property Of: Chart, List, Matrix, Matrix Column, Matrix Row, Matrix Subtotal, Subreport, Table, Table Column, Table Row, Text Box
X-AxisFormatting
Description: The formatting for the x-axis of a chart
When to Use: A chart type with an x-axis is to be rendered.
Notes: The detail properties control the look of each aspect of the x-axis.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—x-axis tab
Detail Properties: CrossAt, FormatCode, FormatCodeStyle, InterlacedStrips, LogarithmicScale, MajorGridlines, MajorGridlinesInterval, MajorGridlinesStyle, MajorTickMark, MinorGridlines, MinorGridlinesInterval, MinorGridlinesStyle, MinorTickMark, NumericOrTime-scaleValues, Reversed, ScaleMaximum, ScaleMinimum, ShowLabels, SideMargins, Title, TitleAlign, TitleStyle
Y-AxisFormatting
Description: The formatting for the y-axis of a chart
When to Use: A chart type with a y-axis is to be rendered.
Notes: The detail properties control the look of each aspect of the y-axis.
Property Of: Chart
Custom Properties Dialog Box Location: Chart Properties—y-axis tab
Detail Properties: CrossAt, FormatCode, FormatCodeStyle, Interlaced Strips, Logarithmic Scale, MajorGridlines, MajorGridlinesInterval, MajorGridlinesStyle, MajorTickMark, MinorGridlines, MinorGridlinesInterval, MinorGridlinesStyle, MinorTickMark, Reversed, ScaleMaximum, ScaleMinimum, ShowLabels, SideMargins, Title, TitleAlign, TitleStyle
Категории