Export (0) Print
Expand All
Expand Minimize

Properties in Report Builder 2.0

SQL Server 2008

Properties are used to control the appearance and functionality of report items, such as data regions, text boxes, and graphic elements, as well as the entire report. Properties can be set in the Properties pane. The set of properties that appears in the Properties pane is specific to the report element that you have selected on the design surface, and changes whenever you change your selection.

To open the Properties pane, from the View menu, click Properties, or right-click the design surface and select Properties from the shortcut menu. To change the value of a property, click in the text box next to the property and select a new value or type a valid value.

Some properties accept expressions. Click the ellipsis () to open the Expression dialog box and type a valid expression. For more information about expressions, see Understanding Simple and Complex Expressions (Report Builder 2.0).

Some properties can be set both in the Properties pane and in a dialog box. Dialog boxes provide an alternative way of setting some properties. Properties that contain enumeration values can also contain expressions that evaluate to one of the valid values. Properties can be set directly in the report definition (.rdl) file by using a text editor. Properties are Report Definition Language (RDL) elements. For more information about RDL, see Report Definition Language Reference in SQL Server Books Online on msdn.microsoft.com.

ABCDEFGHI J KLMNOPQRSTUVW X Y Z

A

AccentSensitivity

Indicates whether the data is accent-sensitive. Valid values are:

  • Auto (default)

  • True

  • False

If Auto is specified, the report server attempts to get accent-sensitivity from the data processing extension. If the extension cannot provide this information, the value of the AccentSensitivity property is set to False.

Action

Defines a hyperlink, a bookmark link, or a drillthrough action.

The Action property must contain one and only one of the following child elements: Hyperlink, Drillthrough, or BookmarkLink. For more information, see Adding Interactive Features (Report Builder 2.0).

ActionInfo

Defines a list of actions associated with a report item.

Actions

Defines an ordered list of actions associated with a report item. The Actions list is limited to one action. If the Actions list contains more than one action, only the first action is used.

AlignOrientation   

Specifies in which direction the chart area should be aligned with another chart area. Valid values are:

ValueDescription
NoneThe chart area is not aligned with another chart area.
VerticalThe chart area is vertically aligned.
HorizontalThe chart area has a vertical alignment orientation.
AllThe chart area is horizontally and vertically aligned.

This property is ignored if the AlignWithChartArea property is not set.

AlignWithChartArea   

Specifies the name of a chart area with which to align this chart area.

Use this property to align or synchronize two or more chart areas horizontally or vertically.

AlllowBlank

Indicates whether the value for the parameter can be an empty string. The AllowBlank property is ignored if the value of the parameter's DataType property is not String.

AllowLabelRotation   

Indicates the increment by which axis labels can be rotated to fit within the chart. Valid values are:

ValueDescription
None (default)Rotation is not allowed.
Rotate15Rotate in 15 degree increments.
Rotate30Rotate in 30 degree increments.
Rotate45Rotate in 45 degree increments.
Rotate90Rotate in 90 degree increments.

AllowOutSidePlotArea   

Determines whether the data point labels can be drawn outside of the chart area.

AltReportItem

Contains the report item to render in cases where the custom report item is not supported by the server or the renderer.

Angle   

Defines the angle at which to display axis labels. Valid values are between -90 and 90.

Arrows   

Defines the type of arrows to be displayed for axis labels. Valid values are:

ValueDescription
None (default)No arrows are displayed on the axis labels.
TriangleAn arrow with a triangle on the end is displayed on the axis labels.
SharpTriangleAn arrow with a sharp triangle on the end is displayed on the axis labels.
LinesAn line arrow is displayed on the axis labels.

Author

Contains the name of the person who created the report.

AutoFitTextDisabled   

Indicates whether the text will be automatically resized to fit in the legend area. Valid values are:

ValueDescription
True Text will not be automatically resized to fit in the legend area.
False Text will be automatically resized to fit in the legend area.

AutoRefresh

Specifies the rate, in seconds, at which a report refreshes.

The value for the AutoRefresh property must be between 0 and 2147483647. If the value is omitted, or if the value is zero, the page will not refresh automatically. Currently, the HTML rendering extension is the only Reporting Services rendering extension that uses AutoRefresh. However, independent software vendors (ISVs) may develop rendering extensions that support AutoRefresh.

AxisLabel   

Contains the label to use on the axis for the data point.

Top

B

BackgroundColor

Specifies the background color of the item.

The BackgroundColor property contains an expression that evaluates to either a color name or a hex HTML color string in the form #HHHHHH. If this property is omitted, the background is transparent.

Applies only to Rectangle, Textbox, Tablix, Chart, Body, and PageSection.

BackgroundGradientEndColor

Specifies the end color of the background gradient.

The BackgroundGradientEndColor property contains an expression that evaluates to either a color name or a hex HTML color string in the form #HHHHHH. If BackgroundGradientEndColor is omitted, the end color of the background gradient is transparent.

Applies only to items in a Chart data region. Does not apply to items in Line, Rectangle, Textbox, Image, Subreport, Tablix, Body, and PageSection.

BackgroundGradientType

Specifies the type of background gradient for a chart. Valid values are:

  • None (default)

  • LeftRight

  • TopBottom

  • Center

  • DiagonalLeft

  • DiagonalRight

  • HorizontalCenter

  • VerticalCenter

If BackgroundGradientType is omitted, the item has no background gradient.

BackgroundImage

Provides information about the background image.

If the BackgroundImage property is omitted, there is no background image.

Applies only to Rectangle, Textbox, Tablix, Body, and PageSection report items. BackgroundImage does not apply to Line, Image, Subreport, and Chart report items.

BackgroundRepeat

Indicates how the background image fills the available space. Valid values are:

ValueDescription
Repeat (default) Repeats the image horizontally and vertically in the background.
NoRepeatDisplays the image only once; the image does not repeat.
RepeatXRepeats the image horizontally in the background.
RepeatYRepeats the image vertically in the background.

Applies only to Rectangle, Textbox, Tablix, and Body report items.

Bookmark

Provides a bookmark that users can jump to using a link defined as a bookmark action.

The Bookmark property is used to provide an anchor that a user can jump to using a link defined in the BookmarkLink property for another item.

BookmarkLink

Contains the ID of a bookmark to jump to within the report.

The value for the BookmarkLink property must evaluate to the ID of a bookmark within the report. If no matching ID is found, the link is not included in the rendered report. If the bookmark is hidden, the report server displays the beginning of the page that contains the bookmark. If multiple bookmarks with the same ID are found, the report server displays the first bookmark found with that ID.

The Action property, which is the parent of BookmarkLink, must contain one and only one child property: Hyperlink, Drillthrough, or BookmarkLink. If you use either Hyperlink or Drillthrough as a child of Action, you cannot use BookmarkLink.

Border

Defines the default border properties for a report item.

To set the properties for a specific border, use TopBorder, BottomBorder, LeftBorder, or RightBorder. For borders that share the same location, the following rules apply:

  • If one report item is contained by another report item, the container report item borders are used.

  • If two report items are peers, the ZIndex property controls which border is drawn last. If the ZIndex property is identical, the rightmost border for vertical borders and the bottommost border for horizontal borders is drawn last.

BottomBorder

Defines the border properties for the bottom border of a report item.

Property values defined for BottomBorder override properties defined for the default values on a report item border. For more information about the rules that apply when a border is shared with another report item, see Border.

BottomMargin

Specifies the width of the bottom margin of the report.

The string for the BottomMargin property must contain a number (with a period character used as an optional decimal separator). The number must be followed by a designator for a CSS length unit such as cm, mm, in, pt, or pc. A space between the number and the designator is optional. For more information about size designators, see CSS Length Units Reference at msdn.microsoft.com.

The maximum value for BottomMargin is 160 inches. The minimum value is 0 inches.

BreakLineType   

Specifies the type of line used to display a scale break. Valid values are:

  • Ragged (default)

  • None

  • Straight

  • Wave

BreakLocation

Specifies where the page should break. Valid values are:

ValueDescription
StartPage break before the group or report item.
EndPage break after the group or report item.
StartAndEndPage break both before and after the report item
BetweenPage break between each instance of the group (does not apply to report items)

Top

C

Calendar

Specifies the calendar to use to format dates. Valid values are:

  • Gregorian (default)

  • Gregorian Arabic

  • Gregorian Middle East French

  • Gregorian Transliterated English

  • Gregorian Transliterated French

  • Gregorian US English

  • Hebrew

  • Hijiri

  • Japanese

  • Korea

  • Taiwan

  • Thai

  • Buddhist

The Calendar property applies only to Chart and Textbox report items. Calendar does not apply to Line, Rectangle, Image, Subreport, Tablix, and Body report items.

CalloutBackColor   

Specifies the fill color of the box around the data point label text.

This property is applied only when the CalloutStyle is set to Box.

CalloutLineAnchor   

. Specifies the shape to draw on the point end of the callout line. Valid values are:

  • Arrow (default)

  • None

  • Diamond

  • Round

  • Square

CalloutLineColor   

Specifies the color of the callout line.

CalloutLineStyle   

. Specifies the style of the callout line.

Valid values are:

  • Solid (default)

  • None

  • Dotted

  • Dashed

  • Double

  • DashDot

  • DashDotDot

CalloutLineWidth   

Defines the width of the callout line.

CalloutStyle   

. Defines the style to use when drawing the callout lines. Valid values are:

  • Underline (default)

  • None

  • Box

CanGrow

Indicates whether the size of the text box can increase vertically according to its content.

CanShrink

Indicates whether the size of the text box can decrease according to its content.

Caption

Contains the text of the chart or axis title.

CaseSensitivity

Indicates whether the data is case-sensitive. Valid values are:

  • Auto (default)

  • True

  • False

If Auto is specified, the report server attempts to get case sensitivity from the data processing extension. If the extension cannot provide this information, the value of CaseSensitivity is set to False.

CategoryAxisName   

Defines the name of the category axis against which to plot this series. If this value is not set, the series will be plotted against the first category axis.

CellContents

Defines the report item contained in a body, header, or corner cell of a Tablix data region.

CellType   

Defines the type of cell in the legend. Valid values are:

  • Text

  • SeriesSymbol

  • Image

Chart   

Defines a chart data region to be included in the report.

ChartAlignType   

Indicates which aspects of the chart area should be aligned with the target chart area.

This property is ignored if the AlignWithChartArea property is not set.

ChartAnnotation   

Defines an annotation to be drawn within a chart.

The ChartAnnotation property itself is not used. Instead, a specific annotation property is used wherever ChartAnnotation is allowed.

ChartAnnotations   

Defines a set of annotations for the chart.

ChartArea   

Defines a chart to be drawn within a Chart data region.

ChartAreaName   

Defines the name of the chart area in which to plot a series.

The ChartAreaName property defaults to the first chart area in the chart.

ChartAreas   

Defines a set of chart areas for a Chart data region.

ChartAxis   

Defines properties for labels, titles, and gridlines on an axis in a chart.

ChartAxisScaleBreak   

Defines scale break behavior and style on the axis.

ChartAxisTitle   

Defines a title for an axis.

ChartBorderSkin   

Defines a border skin type for the chart. Valid values are:

  • None

  • Emboss

  • Raised

  • Sunkien

  • FrameThin1

  • FrameThin2

  • FrameThin3

  • FrameThin4

  • FrameThin5

  • FrameThin6

  • FrameThin7

  • FrameThin8

ChartBorderSkinType   

Defines a border skin for the chart.

ChartCategoryHierarchy   

Defines the hierarchy of category members for the chart.

ChartCodeParameters   

Defines a parameter for the code in the chart.

ChartData   

Defines the segmentation of the data into multiple series.

ChartDataLabel   

Indicates the values should be marked with data labels.

ChartDataPoint   

Defines a single data point for a chart.

There must be one ChartDataPoint property for each static category in a ChartSeries property. If the chart series does not contain static categories, the ChartDataPoints property must contain one and only one ChartDataPoint property. The data values within the child ChartDataValues property can be a single value expression (in the case of bar or line charts) or multiple value expressions (in the case of stock and bubble charts).

ChartDataPointInLegend   

Defines how the data point appears when displayed in a legend.

ChartDataPoints   

Defines the data points for a chart series.

ChartDataPointValues   

Defines a set of data values for a data point in the chart.

Each series type has a different set of mandatory and optional data values. Data values not used for the series type are ignored.

ChartDerivedSeries   

Defines a derived series which is calculated from a formula applied to another series.

ChartDerivedSeriesCollection   

Derived series which are calculated from formulas applied to other series.

ChartEmptyPoints   

Defines the behavior for empty points in the series.

ChartFormulaParameter   

Defines a parameter to a formula for a derived series.

ChartFormulaParameters   

Defines a list of parameters to a formula for a derived series.

ChartLegend   

Defines properties that can be used to display instances of the series groups in a chart legend.

ChartLegends   

Defines a set of legend areas for the chart.

ChartLegendTitle   

Defines a title for the chart legend.

ChartMajorGridLines   

Specifies that major gridlines should be displayed for the axis.

ChartMarker2   

Defines a marker for displayed chart data values.

ChartMember   

Defines a category or series member for a chart.

ChartMembers   

Defines a ordered list of members for a Chart hierarchy.

ChartMinorGridLines   

Defines the style properties for minor gridlines along an axis in the chart.

ChartMinorTickMarks   

Specifies the position of the major tick marks on the axis. Valid values are:

  • None (default)

  • Inside

  • Outside

  • Cross

ChartMinorTickMarks   

Specifies the position of the minor tick marks on the axis. Valid values are:

  • None (default)

  • Inside

  • Outside

  • Cross

ChartNoDataMessage   

Defines the title to display if the chart contains no data.

ChartNoMoveDirections   

Contains a set of properties that indicate which directions a smart label is not allowed to move.

ChartSeries   

Contains a set of data points for a series.

ChartSeriesCollection   

Contains a list of data points for each series in the chart.

ChartSeriesHierarchy   

Defines the hierarchy of series members for a chart.

ChartSmartLabel   

Defines the behavior of smart labels.

ChartStripLine   

Defines a custom strip line for an axis.

ChartStripLines   

Defines a list of custom strip lines for an axis.

ChartThreeDProperties   

Defines the three-dimensional properties of a chart.

ChartTitle   

Defines a title for a chart.

ChartTitles   

Defines the set of titles for the chart.

ChartValueAxes   

Defines the list of data axes, plotted along the Y axis by default.

ChartValueAxis   

Defines the value axis of the chart.

Clustered   

Indicates whether the value series are displayed along distinct rows in a three-dimensional chart.

The Clustered property applies only to bar and column charts.

Code   

Contains definitions for custom functions to be used in the report.

Functions contained within the Code element must be written in Visual Basic .NET and must be instance methods. For information about writing custom code and using the functions contained within the Code element in a report, see Using Custom Code References in Expressions (Report Builder 2.0).

The code from the Code element of a report and from your custom assemblies is instantiated into a Code object when the report is run. In some cases, you may need to override the default OnInit method for this object to initialize your custom classes with values from the global collections in the report. For information about initializing the Code object using OnInit, see "Initializing Custom Assembly Objects" on MSDN.

CodeLanguage   

Specifies the language used for event handler functions for the chart.

CollapsibleSpaceThreshold   

Defines the percent of empty space allowed on the axis before a scale break is triggered.

This property must have a value greater than 0.

Collation

Specifies the locale that the report server uses to sort data.

If no collation is specified within the DataSet property, the report server attempts to derive the collation code from the data processing extension. If the server cannot get this information from the extension, the collation is set to the Language property of the report.

Color

Defines the foreground color of the item. The Color property contains an expression that evaluates to either a color name or a hex HTML color string in the form #HHHHHH. For information about color values, see the Color Table topic at msdn.microsoft.com.

Color applies only to text box, subtotal, title, and legend report items.

ColSpan

Specifies the number of columns that the cell spans.

Columns can only span more than one Tablix cell for a column group in which all common ancestors of the cells to span are in static rows. You cannot merge a cell that is part of a dynamic column group with a cell that is part of static column group.

If the CellContents property is in a TablixHeader element, the value for ColSpan is ignored.

Columns

Specifies the default number of columns in the report.

A value of 2 or more in the Columns property divides the report page into multiple columns. The Columns property must contain a value between 1 and 1000.

ColumnSeparator   

Indicates what type of separator to use for the legend columns. Valid values are:

  • None (default)

  • Line

  • ThickLine

  • DoubleLine

  • DashLine

  • DotLine

  • GradientLine

  • ThickGradientLine

ColumnSeparatorColor   

Specifies the color to use for the column separator.

ColumnSpacing

Specifies the spacing between columns.

The string for the ColumnSpacing property must contain a number (with a period character used as an optional decimal separator). The number must be followed by a designator for a CSS length unit such as cm, mm, in, pt, or pc. A space between the number and the designator is optional. For more information about size designators, see CSS Length Units Reference at msdn.microsoft.com.

The maximum value for ColumnSpacing is 160 inches. The minimum value is 0 inches.

ColumnType   

Defines the type of column for the legend column.

CommandText

Specifies the query that the report server executes to retrieve data for the report.

The CommandText property contains an expression that evaluates to a statement that the data source can use to retrieve data (for example, a Transact-SQL query). The type of query contained in the CommandText property is specified in the CommandType property.

CommandType

Indicates the type of query that is contained in the CommandText property. Valid values are:

ValueDescription
Text (default)Indicates that the value is a text string to pass to the data source, for example, a Transact-SQL query.
StoredProcedureIndicates that the value is the name of a stored procedure to execute. The stored procedure must return a single result set.
TableDirectIndicates that the value is the name of a table from which to retrieve data. All data from the table is returned.

ConnectionProperties

Provides information about the data source.

The DataSource element, which is the parent of ConnectionProperties, must contain either a ConnectionProperties element or a DataSourceReference element, but it cannot contain both.

Credential information is not stored within a report definition. Credentials are stored and managed separately on the report server.

ConnectionString

Contains the connection string for the data source.

ConsumeContainerWhitespace

Indicates whether the space between report items in a rectangle or the report body should be preserved as report items expand.

ValueDescription
TrueEliminates the space around report items on the design surface. This also eliminates unused space at the end of a report.
FalsePreserves space as shown on the report design surface and at the end of a report.

CrossAt   

Specifies the value at which the axis crosses the other axis.

The CrossAt property contains an expression string that evaluates to a variant. If CrossAt is omitted, the value is determined by the chart control.

CustomData

Represents the data to display in a custom report item.

The CustomData element defines the data to be handed to a custom report item and the way that data should be grouped, sorted, filtered and aggregated. A custom report item with a CustomData element is considered to be a data region. This affects such things as restricting placement within the report (for example, custom report items not allowed in detail rows, page header or page footer), available scopes for expressions, and the use of the RepeatWith property.

CustomPaletteColors   

Defines the colors to use for a custom palette.

CustomProperties

Allows report design tools to pass information to custom report renderers and custom report items.

CustomProperty

Represents a custom property used in a report, report item, or group.

A CustomPropertyName or Value property within a CustomData property with no data rows will evaluate to null if it is based on an expression. Custom properties with expressions that need to be evaluated, even in the case of no rows, should be placed on the CustomReportItem element instead.

CustomReportItem

You can insert any XML structure into the CustomReportItem element. The Type attribute and this XML structure can be processed by a custom application or server.

Use the ReportItems element to define a collection of report items to display when the application or server does not support the custom report item.

Top

D

DataCell

Defines the set of data values to pass to a custom report item for a specific combination of leaf-node groupings.

DataColumnHierarchy

Defines the hierarchy of column groups for the data.

DataElementName

Contains the name of the data element or attribute for a report item or the name of the top-level element for a report rendered using a data rendering extension like the XML rendering extension.

When the DataElementName property is used as a child of DataPoint, the default value for this property is the name of the corresponding static series or category. If there are no static series or categories, the default value of DataElementName is Value.

DataElementOutput

Indicates whether the item appears in output rendered by the XML rendering extension or the CSV rendering extension. DataElementOutput controls which report item data appears when a report is rendered by a data-only renderer (CSV or XML). Valid values are:

ValueDescription
OutputIndicates the item appears in the output.
NoOutputIndicates the item should not appear in the output.
ContentsOnlyApplies to XML only. Indicates the item does not appear in the XML, but the contents of the item are rendered as part of the containing report item. ContentsOnly can only be used with lists.
Auto (default)If the item is a text box with a constant value, such as a label, the item does not appear (NoOutput). If the item is a rectangle, the output is the same as it is for ContentsOnly. If the item is a data region, the item appears if it is part of a dynamic member or a static member with a header (Output). The item does not appear if it is a static member without a header (ContentsOnly). For all other report items, the item appears in the output (Output).

DataElementStyle

The DataElementStyle property within the Textbox element must contain one of the following string values:

  • Auto (default)

  • Attribute

  • Element

A value of Auto indicates that the text box uses the same data element style as the report.

DataField

Specifies the name of the field in the query. DataField names do not have to be unique.

The parent Field property must have one and only one child property: either DataField or Value.

DataLabel

Specifies the data labels to display for data values.

DataMember

Specifies a member of a custom data hierarchy.

DataMembers

Specifies a list of members of a custom data hierarchy.

DataProvider

Specifies the data processing extension to be used for the data source.

The value for the DataProvider property must be the name of a registered data extension; for example, SQL, OLEDB, or ODBC. For more information, see Data Sources Supported by Reporting Services (Report Builder 2.0).

DataRegion

A DataRegion is a report layout element bound to a report dataset identified by DataSetName. When a report runs, the data region displays data from the report dataset.

When the query associated with the report dataset for this data region returns no data, the NoRowsMessage appears in place of the data region.

DataRow

Specifies the columns of data within each row to pass to a custom report item.

DataRowHierarchy

Specifies the hierarchy of row groups for the data.

DataRows

Specifies the rows of data to pass to a custom report item.

DataSchema

Specifies the namespace to use in a report rendered using a data rendering extension like the XML rendering extension.

DataSet

Contains information about a set of data to display as a part of the report.

The value of the Name attribute for the DataSet element must be unique within the report.

DataSetName

Specifies which dataset to use for the data region.

If the report contains more than one dataset, the DataSetName property is required for top-level data regions. Nested data regions use the dataset of the top-level data region. If the report contains only one dataset, the data region uses that dataset.

DataSetName, DataSetReference

Specifies which dataset to use for the dataset reference.

DataSetReference

Specifies a dataset that returns a set of valid values or default values for a report parameter.

DataSets

Contains information about the sets of data to display as a part of the report.

DataSource

Describes a data source in the report. The name of the data source must be unique within the report.

The DataSource element must contain either a ConnectionProperties property or a DataSourceReference property, but it cannot contain both.

DataSourceName

Specifies the name of the data source for the query.

DataSourceReference

Specifies the path to a shared data source.

The DataSourceReference property can contain a full folder path (for example, /SampleReports/AdventureWorks) or a relative path (for example, AdventureWorks). Relative paths start in the same folder as the report. The shared data source and the report definition file must be on the same report server. If report server is running in SharePoint integrated mode, the data source path must be a URL to a library or library folder (for example, http://TestServer/TestSite/Documents).

The DataSource element, which is the parent of DataSourceReference, must contain either a ConnectionProperties property or a DataSourceReference property, but it cannot contain both.

DataSources

Specifies the data sources for a report.

DataTransform

Contains the location and file name of a transformation to apply to a rendered report. The transformation location can be a full folder path (for example, /xsl/xfrm.xsl) or a relative path (for example, xfrm.xsl).

DataType

Specifies the data type of a report parameter. Valid values are:

  • Boolean

  • DateTime

  • Integer

  • Float

  • String

DataValue

Defines a single value for a data point in a Chart or a data value to pass to a custom report item.

DataValues

Contains a set of data values for the y-axis.

The number and order of data values within each data point depends on the chart type. The DataValues property must contain the following number of DataValue properties in the following order:

ScatterBubbleStockCandlestick
X, YX, Y, SizeHigh, Low, CloseOpen, High, Low, Close

All other charts require a single data value for each data point.

DefaultValue

Specifies the default value to use for a parameter. If no value is provided, the value for the parameter is Null. If one of the default values is not valid, the entire set of default values is treated as not valid. Only one default value is allowed for Boolean parameters.

When using the DataSetReference property, the default is the first value in the field specified by the ValueField property.

If the sibling Prompt property is omitted, a DefaultValue is required if the value for the sibling Nullable property is False or the values within the sibling Values property do not include Null.

DeferVariableEvaluation

Indicates that report Variables do not need to be evaluated for the entire report when report processing begins.

Variables are evaluated only as needed. Deferred evaluation can improve performance but must not be used if any variables are time-dependent.

DepthRatio   

Specifies the ratio, in percent, of depth to width.

DerivedSeriesFormula   

Defines the formula to apply to the data values from the source series.

Description Element

Contains a description for the report.

When the report is published, the text contained within the Description element is uploaded as a part of the metadata of the report. The description is then visible in Report Manager next to the name of the report.

Direction, SortExpression

Indicates whether the items are sorted in ascending or descending order. Valid values are:

  • Ascending (default)

  • Descending

Direction, Style

Specifies the direction of text. Valid values are:

ValueDescription
LTR (default)Text is written left-to-right.
RTLText is written right-to-left.

The Direction property applies only to text boxes.

Docking   

Specifies the docking location for the title. Valid values are:

  • Top (default)

  • Bottom

  • Right

  • Left

DockOffset   

Defines the offset from the dock location, as a percentage of the chart size.

DockOutsideChartArea   

Indicates whether the title should be docked outside the chart area or inside the chart area.

This property is ignored if the DockToChartArea property is not defined.

DockToChartArea   

Specifies the name of the chart area on which to draw the chart property.

If the DockToChartArea property is omitted (or does not match any chart area name), the chart is drawn relative to the chart rather than a specific chart area.

DocumentMapLabel, Group

Specifies an instance of the group within the document map.

DocumentMapLabel, ReportItem

Specifies an instance of a report item within the document map.

DownLeft   

Indicates whether the smart label can move directly down-left.

DownRight   

Indicates whether the smart label can move directly down-right.

DrawingStyle

Specifies the shape of columns or bars in a three-dimensional chart. Valid values are:

  • Cube (default)

  • Cylinder

  • Emboss

  • LightToDark

  • Wedge

DrawingStyle applies only to bar and column charts.

DrawingStyle

Defines the how bars on a chart are drawn. By default, the drawing style is Default, meaning that the bars do not have any drawing style applied. Only applicable to 2D column and bar charts. Valid values are:

  • Expression

  • Cylinder

  • Emboss

  • LightToDark

  • Wedge

  • Default

DrawSideBySide

Determines if data points that have the same X value are drawn side by side, or if data points are drawn using the same X value. If Auto then the chart type automatically determines if this is true or false. Note that setting this attribute to true only has an effect if two or more series in a chart area have DrawSideBySide set to true.

Drillthrough

Specifies a reference to a report to be opened through a drillthrough action.

The Action property, which is the parent of the Drillthrough property, must contain one and only one child property: Hyperlink, Drillthrough, or BookmarkLink.

DynamicHeight   

Defines the height to which the chart can increase or decrease vertically.

DynamicHeight must be a string constant or expression that evaluates to a Size property. This property defines the initial height used by the report processor for automatically adjusting the report layout as report items dynamically increase and decrease in height.

DynamicWidth   

Defines the width to which the chart can increase or decrease horizontally.

DynamicWidth must be a string constant or expression that evaluates to a Size property. This property defines the initial width used by the report processor for automatically adjusting the report layout as report items dynamically increase and decrease in width.

Top

E

EmbeddedImage

Contains an image that is embedded within the report.

EmbeddedImages

Contains the EmbeddedImage objects for the report.

EmptyPointValue

Defines how the empty points are defined. If this property is set to Average, empty points are drawn as the average of the points before and after it. If this property is set to Zero, all empty points are drawn at zero.

Enabled, ChartAxisScaleBreak   

Indicates whether a scale break should be calculated. If there is sufficient difference between data points in the series, a scale break will be drawn.

Enabled, ChartThreeDProperties2   

Indicates whether the chart is three-dimensional. Valid values are:

ValueDescription
True The chart is three-dimensional.
False (default)The chart is two-dimensional.

End   

Indicates the end or close value for the data point.

This property is optional in stock, candlestick and box plot charts.

EqualiSpacedItems   

Indicates whether all legend items are equally spaced.

EquallySizedAxesFont   

Indicates whether the same font size should be used for all axes (if the font size is automatic).

Top

F

Field

Describes each field in the dataset.

The field name is the name of the field as it is referred to within the report. The data field is the name of the field that is returned from the query. Field names have to be unique within the containing Fields collection. Data fields do not have to be unique, and multiple fields can use the same data field name.

The Field property must have one and only one child property: either DataField or Value.

Fields

Contains the fields in the DataSet.

The Fields property is a collection of field mappings between the data source schema metadata and the dataset field collection. The data provider provides a default set of fields based on the query. You can also add calculated fields to the Fields collection.

Filter

Contains a set of FilterExpression, FilterValues, and Operator properties that exclude rows of data from a dataset or data region, or group instances from a group.

FilterExpression

Contains an expression that is evaluated for each row of data or group and compared to a filter value.

The FilterExpression property cannot contain references to report items. When used in a dataset or data region, FilterExpression cannot contain aggregate functions, and when used in a group, it cannot contain the RunningValue or RowNumber functions.

Filters

Contains a collection of Filter objects to apply to a dataset, data region, or group.

FilterValue

Contains a value or expression, or an array of values or expressions, to compare to in a filter expression.

The FilterValue value is compared to the value in the FilterExpression property using the value from the Operator property. All three properties form the filter equation: FilterExpression, Operator, and FilterValue.

The FilterValue property cannot contain references to report items, such as text box names. It must refer to data values. When used to filter a dataset or data region, FilterValue cannot contain aggregate functions. When used to filter a group, FilterValue cannot contain the RunningValue or RowNumber function.

FilterValues

Contains a collection of values to compare to the filter expression.

FixedColumnHeaders

Indicates the column headers should be displayed on the page even when the user scrolls part of the Tablix data region off the page.

FixedData

Indicates the entire member should be displayed on the page even when the user scrolls part of the Tablix data region off the page.

FixedRowHeaders

Indicates the row headers should be displayed on the page even when the user scrolls part of the Tablix data region off the page.

FontFamily

Specifies the name of the font for the item.

The FontFamily property applies only to text box and chart report items.

FontSize

Specifies the point size of the font for the item.

The minimum value for the FontSize property is 1 pt. The maximum value is 200 pt.

FontSize applies only to text box and chart report items.

FontStyle

Specifies the style of the font for the item. Valid values are:

  • Normal (default)

  • Italic

FontStyle applies only to text box and chart report items.

FontWeight

Specifies the thickness of the font for the item. Valid values are:

  • Normal (default)

  • Thin

  • ExtraLight

  • Light

  • Medium

  • SemiBold

  • Bold

  • ExtraBold

  • Heavy

FontWeight applies only to text box and chart report items.

Format

Specifies a Microsoft .NET Framework formatting string for the item.

The Format property must contain a .NET Framework formatting string. For information about .NET Framework formatting strings, see Formatting Types on msdn.microsoft.com.

Locale-dependent currency formatting (format code C) and locale-dependent date formatting are based on the language setting for the report item.

Format applies only to text box and chart report items.

Top

G

GapDepth   

Specifies the percent depth gap between three-dimensional bars and columns.

Group

Contains all the expressions by which to group the data. Includes the group name.

GroupExpression

Contains an expression by which to group the data.

References to report items, such as text box names, are not allowed in a group expression.

GroupExpressions

Contains an ordered list of expressions by which to group the data.

GroupsBeforeRowHeaders

Specifies the number of instances of the outermost column group that can appear outside the row headers.

The minimum value for the GroupsBeforeRowHeaders property is 0. The maximum value is 2147573647.

Top

H

HeaderSeparator   

Defines what type of separator to use for the legend header. Valid values are:

  • None

  • Line

  • ThickLine

  • DoubleLine

  • DashLine

  • DotLine

  • GradientLine

  • ThickGradientLine

HeaderSeparatorColor   

Specifies the color to use for the legend header separator.

Height

Specifies the height of the item.

The maximum size for Height is 160 inches. The minimum size is 0 inches.

Only lines can have a negative size. Height combined with width determines the endpoint of the line.

If the Height property is omitted, the default is the value of Height for the containing item minus the value of the sibling Top property, except for Tablix report items. For a Tablix, the default is derived from the sizes of the columns, rows, and cells.

Setting a report item height property equal to 0 does not hide the report item when rendered. To hide a report item, set the Hidden property to True.

HeightRatio

Specifies the ratio of height to width. Used for 3-D charts.

Hidden

Indicates whether the item should initially be visible on the report.

ValueDescription
TrueThe item should initially be hidden on the report.
FalseThe item should initially be visible on the report.

The value for the Hidden property for a ReportParameter must not be an expression.

HideDuplicates

Specifies that an item is hidden when its current value is the same as its value in the previous row.

The value for the HideDuplicates property is the name of a dataset or group. When the value of HideDuplicates is the name of a dataset, the text box value is hidden if the value is the same as the value in the previous row. When the value of HideDuplicates is the name of a group, each time there is a new instance of the group, the first instance of the text box is displayed, even if the value is the same as the value from the last instance of the text box from the previous group instance.

Duplicates are not hidden in the first row of a group or page.

HideEndabels   

Indicates whether labels should be hidden at the ends of an axis.

HideIfNoRows

Indicates whether this static member should be hidden if the data region does not contain rows of data.

This value is ignored for dynamic members. If HideIfNoRows is set, Visibility properties including ToggleItem are ignored.

HideInLegend   

Indicates whether the series is shown in the legend.

HideLabels   

Indicates whether the axis labels are hidden.

High   

Specifies the high value for the data point.

This property is optional in range charts.

HistogramSegmentIntervalNumber

If ShowColumnAs is Histogram then this property defines the numberof intervals that the data range is divided into. The property only has effect when HistogramSegmenetIntervalWidth is not set.

HistogramSegmentIntervalWidth

If ShowColumnAs is Histogram then this property defines the histogram interval width. Setting this value to zero will reslt in automatic width calculation based on the data range.

HistogramShowPercentOnSecondaryYAxis

If ShowColumnAs is Histogram, this property indicates the percent frequency that should be displayed using the secondary Y axis.

Hyperlink

Specifies the URL of the target object.

Top

I

Image

Specifies an image to be displayed in the report.

ImageData

Contains encoded image data. The image data within this property must be Base-64 encoded.

Inclination   

Specifies the angle of inclination.

IncludeZero, ChartAxis   

Indicates whether the axis includes zero.

This property does not apply if the Minimum property is set.

IncludeZero, ChartAxisScaleBreak   

Indicates whether to prohibit a scale break from spanning zero. Valid values are:

  • Auto (default)

  • True

  • False

InitialState

Specifies the initial state of a visibility toggle image.

ValueDescription
TrueThe toggle image is a minus sign (-), for expanded.
FalseThe toggle image is a plus sign (+), for collapsed.

The InitialState property is used with the ToggleImage and Visibility properties to hide an item. For more information, see Hiding Report Items Conditionally (Report Builder 2.0).

InstanceName

Specifies the name of the variable to which the class is assigned. This name is used in expressions within the report.

The value for InstanceName must be a case-insensitive identifier that is compliant with the Common Language Specification (CLS).

IntegratedSecurity

Specifies whether the data source uses integrated security to connect.

InteractiveHeight

pecifies the default page size of a report that is rendered in the HTML or GDI rendering extensions.

There is no maximum size for InteractiveHeight. A value of 0 is used to specify unlimited height. The default value is specified by the PageHeight property.

InteractiveWidth

pecifies the default width of a report that is rendered in the HTML or GDI rendering extensions.

There is no maximum size for InteractiveWidth. A value of 0 is used to specify infinite width. The default value is specified by the PageWidth property.

Interlaced   

Indicates whether alternating dark stripes are drawn between grid lines.

ValueDescription
True Strip lines are drawn between every other interval.
False (default)No strip lines are drawn.

InterlacedColor   

Defines the color of the interlaced strip lines.

InterlacedRows   

Indicates whether legend rows use interlaced colors.

InterlacedRowsColor   

Specifies the background color to use for interlaced legend rows.

If this property is not set, the chart area background color will be used.

InterpretSubtotalsAsDetails

Indicates whether subtotal rows returned from a data provider that supports server subtotals should be interpreted as detail rows instead. Valid values are:

  • Auto (default)

  • True

  • False

If Auto is specified, subtotal rows will be treated as details if the report does not use the Aggregate function to access any fields in this dataset.

Interval   

Defines the interval for the chart element.

IntervalOffsetType   

Defines the unit for the IntervalOffset property. Valid values are:

  • Auto (default)

  • Number

  • Years

  • Months

  • Weeks

  • Days

  • Hours

  • Minutes

  • Seconds

  • Milliseconds

IntervalType   

Defines the units for the Interval property.

Top

K

KanatypeSensitivity

Indicates whether the data is kanatype-sensitive. Valid values are:

  • Auto (default)

  • True

  • False

If Auto is specified, the report server attempts to get information about kanatype sensitivity from the data processing extension. If the extension cannot provide this information, the default value of the KanatypeSensitivity property is False.

KeepTogether

Indicates whether all sections of the data region are kept together on one page.

Renderers may be constrained by physical page sizes or margins that will prevent the KeepTogether behavior.

KeepWithGroup

Specifies that during rendering, this static member stays on the same page with the closest target peer dynamic member as indicated by the value. Valid values are:

  • None (default)

  • Before

  • After

Each peer member between this member and the target dynamic member must have the same value for KeepWithGroup as this member.

The value must be None on dynamic members or members with dynamic descendants.

Hidden instances of dynamic members are ignored when determining the closest member.

Renderers may be constrained by physical page sizes or margins that will prevent the KeepWithGroup behavior.

Top

L

Label, ChartDataLabel   

Provides a label for the data point.

Label, ChartMember

Provides a label for items in a chart.

Label, ParameterValue

Contains the label to display to the user for the parameter.

The value that is passed as the actual parameter is stored in the sibling Value property. The Label property displays a friendly string to the user.

The Label property contains an expression that evaluates to a string. If the expression is the empty string, the corresponding Value property is used as the label.

If the Value property contains an expression that evaluates to an array, the Label property expression must also return an array with same number of items.

LabelField

Contains the name of the field that displays a list of friendly names to display to the user for valid values for a parameter.

If no value is specified for the LabelField property, the value for the sibling ValueField property is used.

When the DataSetReference property is a child of the DefaultValue property, LabelField is not used.

LabelInterval   

Defines the interval between labels.

If LabelInterval is not set, its value will be default to the value of the IntervalOffset property.

LabelIntervalOffset   

Defines the offset from the axis minimum for the first label.

LabelIntervalOffsetType      

Specifies the unit value for the LabelIntervalOffset property. Valid values are:

  • Default (default)

  • Auto

  • Number

  • Years

  • Months

  • Weeks

  • Days

  • Hours

  • Minutes

If LabelIntervalOffsetType is not set, its value defaults to the value of the IntervalOffsetType property.

LabelIntervalType      

Specifies the unit value for the LabelInterval offset. Valid values are:

  • Default (default)

  • Auto

  • Number

  • Years

  • Months

  • Weeks

  • Days

  • Hours

  • Minutes

If LabelIntervalType is not set, its value will be default to the value of the IntervalType property.

LabelsAutoFitDisabled   

Indicates whether axis labels are automatically adjusted to fit.

Language, Report

Indicates the primary language of the text in the report. The default report language is the language of the report server.

The Language property must contain an expression that evaluates to a language code as defined in the Internet Engineering Task Force (IETF) RFC1766 specification. The language code is a string composed of one or more parts. The first part is a two-character designation of the basic language. For example, "en" for English or "fr" for French. The second part is separated by a hyphen and designates the variation or dialect of the language. For example, "en-us" represents United States English.

Language, Style

Indicates the primary language of the text.

The Language property must contain an expression that evaluates to a language code as defined in the Internet Engineering Task Force (IETF) RFC1766 specification. The language code is a string composed of one or more parts. The first part is a two-character designation of the basic language. For example, "en" for English or "fr" for French. The second part is separated by a hyphen and designates the variation or dialect of the language. For example, "en-us" represents United States English.

Language applies only to chart and text box report items.

Layout   

Defines the arrangement of labels within the legend. Valid values are:

  • AutoTable (default)

  • WideTable

  • TallTable

  • Column

  • Row

Layout, Legend

Determines the arrangement of labels within the legend. Valid values are:

  • Column (default)

  • Row

  • Table

LayoutDirection, Tablix

Indicates the overall direction of the Tablix layout. Valid values are:

ValueDescription
LTR (default)Dynamic Tablix columns grow left-to-right (with headers on the left).
RTLDynamic Tablix columns grow right-to-left (with headers on the right) and the order of peer groups is reversed.

Left

Specifies the distance of the item from the left edge of the containing item.

The string for the Left property must evaluate to a Size. For more information about size designators, see CSS Length Units Reference on msdn.microsoft.com.

The maximum size for Left is 160 inches. The minimum size is 0 inches.

LeftBorder

Defines the border properties for the left border of a report item.

Property values defined for the LeftBorder override properties defined for the default values on a report item border. For more information about the rules that apply when a border is shared with another report item, see Border.

LeftMargin

Specifies the width of the left margin of the Page.

The string for the LeftMargin property must evaluate to a Size. For more information about size designators, see CSS Length Units Reference on msdn.microsoft.com.

The maximum size for LeftMargin is 160 inches. The minimum size is 0 inches.

LegendName   

Defines the name of the legend in which the given series should appear.

LegendText   

Defines the label for a series in the legend.

If the LegendText property is not defined, the Label properties from the ChartSeriesHierarchy are used as the legend text, concatenated with "-" between each pair.

Line

Defines a line to be drawn in the report.

To draw lines with endpoints above or to the left of the origin, use negative values in both or either of the Width and Height properties. When you use negative values, the sum of Top and Height and the sum of Left and Width cannot be less than zero.

LineHeight

Specifies the height of a line of text.

LineHeight contains an expression that evaluates to a point size. The minimum value for the LineHeight property is 1 point. The maximum value is 1000 points. The default size is determined by the report renderer.

LineHeight applies only to text box report items.

LinkToChild

Contains the name of a child report item that is the target location for the document map label.

You can use the LinkToChild property to cause the document map to point to a child of the report item. When a user clicks on the string defined by the sibling Label property, the report jumps to the child item defined by LinkToChild. If LinkToChild is not present, clicking on DocumentMapLabel causes the report to jump to the parent report item.

LinkToChild is ignored if DocumentMapLabel is not present.

Location

Indicates whether the axis is drawn on the default side for a given type of Chart. Valid values are:

  • Default (default)

  • Opposite

For example, the default side for the value axis on a line chart is the left side.

LogBase   

Defines the base to use for logarithmic scale.

LogScale   

Indicates whether the axis is logarithmic.

The LogScale property is ignored for x-axes in which the value for the child Scalar property is False.

Low   

Defines the low value for the data point.

The Low property is optional in range charts. If the property is omitted, the Y value is used.

Top

M

Margin   

Indicates whether the chart contains an axis margin. Valid values are:

  • Auto (default)

  • True

  • False

The size of the margin is determined by the scale and number of data points in the chart.

MarkerOverlapped   

Indicates whether data point labels are allowed to overlap data point markers.

MarkerOverlapping   

Gets or sets a Boolean value that specifies whether the point labels are allowed to overlap a point marker.

MarksAlwaysAtPlotEdge   

Indicates whether the tick marks render on the edge of the plot area or with the axis.

MaxAutoSize   

Defines the maximum size for the legend, as a percent of the chart size.

MaxFontSize   

Defines the maximum font size when auto-fitting labels.

Maximum   

Indicates the maximum value of the axis.

The Maximum property contains an expression string that evaluates to a variant. If Maximum is omitted, the axis is scaled automatically.

MaxMovingDistance   

Defines the maximum distance from the data point that labels can be moved if labels overlap.

MaxNumberOfBreaks   

Defines the maximum number of scale breaks that can be applied.

MaxPixelPointWidth

Gets or sets the maximum pixel point width of the data point.

Mean   

Specifies the mean value for a data point.

This property is optional for range and box plot charts.

Median   

Specifies the median value for the data point.

This property is optional when using range and box plot charts.

MergeTransactions

Indicates whether transactions in the subreport are merged with transactions in the parent report if both reports use the same data sources.

MIMEType

Contains an expression that identifies the MIME type of the image. Valid values are:

  • image/bmp

  • image/jpeg

  • image/gif

  • image/png

  • image/x-png

MIMEType is required if the value of the Source property is Database. If the value of Source is not Database, MIMEType is ignored.

MinFontSize   

Defines the minimum size for auto-sized legend text.

Minimum   

Specifies the minimum value of the axis.

The Minimum property contains an expression string that evaluates to a variant. If Minimum is omitted, the axis is scaled automatically.

MinMovingDistance   

Defines the minimum distance from the data point that labels can be moved if labels overlap.

MinPixelPointWidth

Gets or sets the minimum pixel point width of the data point.

MultiValue

Indicates that the report parameter can take a set of values.

Multivalue parameters are accessed in expressions as zero-based arrays in the Value and Label properties, for example Parameters!Cities.Value(0) and Parameters!Cities.Label(0)).

This property is ignored for Boolean parameters.

Top

N

Name

Contains a unique identifier for the object.

Name is case-sensitive and must be a Common Language Specification (CLS) compliant identifier. For example, spaces are not allowed. Names must be unique within each RDL property type. Each Dataset, Group, and DataRegion must also be unique in order to specify a scope as a parameter to an aggregate function.

Name, Custom Property

Contains the name for a custom property.

Nullable

Indicates whether the value for the parameter can be null.

If the value of the Nullable property is False, and the sibling Prompt property is omitted, the sibling DefaultValue property is required.

The value cannot be set to true if the ReportParameter is a multivalue parameter.

NumeralLanguage

Specifies the language to use to format numbers.

The Language property is a sibling of NumeralLanguage. The Language property must contain an expression that evaluates to a language code as defined in the Internet Engineering Task Force (IETF) RFC1766 specification. The language code is a string composed of one or more parts. The first part is a two-character designation of the basic language. For example, "en" for English or "fr" for French. The second part is separated by a hyphen and designates the variation or dialect of the language. For example, "en-us" represents United States English.

NumeralLanguage applies only to text box and chart report items.

NumeralVarient

Specifies the formatting code to use to format numbers. Valid values are:

ValueDescription
1 (default)Follow Unicode context rules.
20123456789
3Traditional digits. Currently supported for language codes: ar, bn, bo, fa, gu, hi, kn, kok, lo, mr, ms, or, pa, sa, ta, te, th, ur, and variants.
4ko, ja, zh-CHS, zh-CHT only.
5ko, ja, zh-CHS, zh-CHT only.
6ko, ja, zh-CHS-zh-CHT only (wide versions of regular digits).
7ko only.

NumeralVariant applies only to text box and chart report items.

Top

O

OffsetLabels   

Indicates whether the labels can be offset.

Omit

Indicates that the parameter is ignored when a user opens a report using a drillthrough link on another report.

When a user opens a report using a drillthrough action, and the Drillthrough property of the originating report contains parameters that contain an Omit property value of True, those parameters are skipped when the target report is run.

If the target report name (contained in the ReportName property within the Drillthrough property) is not an expression, Omit is not used.

OmitBorderOnPageBreak

Indicates that the borders should not appear at locations where the item spans multiple pages.

When the value is set to true, repeated background images will continue rather than restart after a page break.

Operator

Specifies the operator to use to compare the values in the FilterExpression and FilterValues properties. Valid values are:

  • Equal

  • Like

  • NotEqual

  • GreaterThan

  • GreaterThanOrEqual

  • LessThan

  • LessThanOrEqual

  • TopN

  • BottomN

  • TopPercent

  • BottomPercent

  • In

  • Between

Like uses the same special characters as the Like operator in Microsoft Visual Basic.NET. For more information, see the Visual Basic .NET documentation on msdn.microsoft.com.

Top

P

PaddingBottom

Specifies the amount of padding between the bottom edge of the report item and its contents. The value of the PaddingBottom property must be between 0pt and 1000pt.

PaddingBottom applies only to text box and image report items.

PaddingLeft

Specifies the amount of padding between the left edge of the report item and its contents. The value of the PaddingLeft property must be between 0pt and 1000pt.

PaddingLeft applies only to text box and image report items.

PaddingRight

Specifies the amount of padding between the right edge of the report item and its contents. The value of the PaddingRight property must be between 0pt and 1000pt.

PaddingRight applies only to text box and image report items.

PaddingTop

Specifies the amount of padding between the top edge of the report item and its contents. The value of the PaddingTop property must be between 0pt and 1000pt.

The value of the PaddingTop property must evaluate to a Size. For more information about size designators, see CSS Length Units Reference on msdn.microsoft.com.

PaddingTop applies only to text box and image report items.

Page

Contains page layout information for the report.

PageBreak

Defines page break behavior for a group or report item.

PageFooter

Contains the report items to be rendered at the bottom of each page of the report.

PageHeader

Contains the report items to be rendered at the top of each page of the report.

PageHeight

Specifies the default height of a report that is rendered in a physical page-oriented rendering extension.

The maximum size for PageHeight is 160 inches. The minimum size must be greater than 0 inches.

PageWidth

Specifies the default width of a report that is rendered in a physical page-oriented rendering extension.

The maximum size for PageWidth is 160 inches. The minimum size must be greater than 0 inches.

Palette   

Specifies the color palette for a chart. Valid values are:

  • Default (default)

  • EarthTones

  • Excel

  • GrayScale

  • Light

  • Pastel

  • SemiTransparent

  • Berry

  • Chocolate

  • Fire

  • SeaGreen

  • BrightPastel

Parameter

Contains a parameter to pass to a subreport or drillthrough report.

Parameters

Contains a list of report parameters to pass to a subreport or drillthrough report.

Parameter directives (rc: and rs: parameters) are not supported for drillthrough actions.

ParameterValue

Provides an individual hard-coded parameter value.

For the Value parameter:

  • Use "true" and "false" for Boolean parameters.

  • Use ISO 8601 values for date/time parameters.

  • Use a period (.) as the optional decimal separator for float parameters.

If a label value is not supplied, the Value parameter is used as the label. If no Value parameter is supplied, then an empty string is used.

If the Value expression returns an array, the Label expression must return an array with the same number of items.

If the Value expression does not return an array, the Label expression must not return an array.

ParameterValues

Provides a list of values to display so that users can choose a value for this parameter.

Parent

Identifies the parent group in a recursive hierarchy.

The Parent property is used to create a recursive hierarchy. A recursive hierarchy can be created from a set of data that contains fields that refer to other fields in the same set of data. For example, a table containing a list of employees may contain both an employee ID and a manager ID. By grouping the data by employee ID and identifying the manager ID as the parent, you can create a hierarchy of employees.

The expression within the Parent property evaluates to a variant. Parent can only be used in groups with a single group expression.

Perspective

Indicates the percent of perspective.

The Perspective property applies only when the value of the sibling ProjectionMode property is Perspective.

PixelPointWidth

Gets or sets the width of data points, in pixels.

PlotType

Indicates whether the series is plotted as a line on a column chart. Valid values are:

  • Auto (default)

  • Line

If Auto is selected, the series is plotted based on the primary chart type; for example, the plot type for a column chart is columns.

PointWidth

Specifies the width of columns and bars in a chart. as a percentage of the available bar or column width.

A value of 100 indicates a width that is 100 percent of the available column or bar width. A value less than 100 creates a space between columns or bars; a value greater than 100 causes columns or bars to overlap.

PointWidth

Gets or sets the max pixel point width of the

Position, BackgroundImage   

Specifies where a background image with BackgroundRepeat set to Clip should be drawn. This property is used for only background images within a chart.

ValueDescription
DefaultUse the default position of Center.
TopDraw image at top center.
TopLeftDraw image at top left.
TopRightDraw image at top right.
LeftDraw image at left center.
CenterDraw image in center.
RightDraw image at right center.
BottomRightDraw image at bottom right.
BottomDraw image at bottom center.
BottomLeftDraw image at bottom left.

Position, ChartAlignType   

Speficies which aspects of the chart area should be aligned with the target chart area. This property is ignored if AlignWithChartArea is not specified.

Position, ChartAxisTitle   

Defines a title for the axis.

Position, ChartDataLabel2   

Specifies the position of the data label. Valid values are:

  • Auto (default)

  • Top

  • TopLeft

  • TopRight

  • Left

  • Center

  • Right

  • BottomRight

  • Bottom

  • BottomLeft

  • Outside

For non-pie charts, Outside reverts to Top.

Position, ChartLegend2   

Specifies the position of the legend. Valid values are:

  • TopRight (default)

  • TopLeft

  • TopCenter

  • LeftTop

  • LeftCenter

  • LeftBottom

  • RightCenter

  • RightBottom

  • BottomRight

  • BottomCenter

  • BottomLeft

Position, ChartTitle2   

Specifies the position of the title. Valid values are:

  • Center (default)

  • Near

  • Far

Position is not used for the chart title.

PreventFontGrow   

Indicates whether the axis label font size can be increased to fit within the chart.

PreventFontShrink   

Indicates whether the axis label font size can be reduced to fit within the chart.

PreventLabelOffset   

Indicates whether the axis labels can be staggered to fit within the chart.

PreventWordWrap   

Indicates the axis labels will not be word-wrapped to fit within the chart.

PrintOnFirstPage

Indicates whether the page section is rendered on the first page on the report. The PrintOnFirstPage property is ignored when used in the page footer of a single-page report.

PrintOnLastPage

Indicates whether the page section is rendered on the last page on the report. The PrintOnLastPage property is ignored when used in the page header of a single-page report.

ProjectionMode   

Specifies the projection mode for the three-dimensional chart. Valid values are:

  • Perspective (default)

  • Oblique

Prompt, ConnectionProperties

Contains the text the user interface displays when prompting the user for database credentials.

Prompt, ReportParameter

Designates the text that the user interface displays when prompting the user for parameter values.

If the Prompt property is omitted, the user is not prompted for a value for this parameter, nor can the parameter be accessed any other way (for example, through URL access or in a subreport or drillthrough report).

Top

Q

Query

Contains information about the dataset query.

QueryParameter

Contains information about an individual parameter that is passed to the data source as part of a query.

QueryParameters

Lists the parameters to pass to the data source as part of the query.

Top

R

Rectangle

Defines a rectangle to be drawn in the report. A rectangle can be a graphical property or a container for other report items.

As a graphical property, a rectangle renders on the page using the Style properties.

As a container, a rectangle can contain one or more report items.

RepeatColumnHeaders

Indicates that data region column headers should be repeated on each page that the data region appears.

RepeatOnNewPage

Indicates whether to repeat this static member on every page that has at least one complete instance of the dynamic member referred to by KeepWithGroup or a descendant of that member.

RepeatRowHeaders

Indicates that data region row headers should be repeated on each page on that the data region appears.

RepeatWith

Provides the name of the data region with which to repeat the report item if the data region spans multiple pages.

The data region named in this property must be in the same ReportItems collection as the parent item of this property.

RepeatWith cannot be used within a data region, subreport, or rectangle that contains a data region or subreport. RepeatWith cannot be used in a page header or page footer.

Report

Contains properties, data, and layout information for the report. The Report element is the top-level element of Report Definition Language (RDL).

ReportElement

Defines a virtual report element of a report that is used to define a property inheritance relationship with other report elements but does not itself appear in an RDL report.

ReportItem

Defines a virtual report item in a report. A report item can be a line, rectangle, text box, image, subreport, data region, or custom report item.

The ReportItem element itself is not used in an RDL report. Wherever a ReportItem element can occur, a specific type of report item is used. Types of report items are one of the following: Line, Rectangle, Image, Subreport, Textbox, Rectangle, CustomReportItem or a data region. A data region can be a Tablix or Chart.

Default values for the Top and Left are set to 0. The default value for Height is the height of the container minus Top. The default value for Width is the width of the container minus Left. Negative values for Width are only valid for Line.

ReportItems

Contains the report items that define the contents of a report region.

ReportItems must contain at least one child property.

When ReportItems is used within a PageHeader or PageFooter property, ReportItems cannot contain a Subreport, Tablix, or Chart.

ReportName

Contains name of the target report.

The ReportName property specifies the local report name, a relative path to the report, a full path to the report, or a URL to a report. A relative path starts in the same folder as the current report. For a report server running in SharePoint integrated mode, the report name must be a SharePoint path.

ReportName cannot contain an empty string.

ReportParameter

Describes an individual parameter in the report. The Name attribute for the ReportParameter property must be unique within the ReportParameters parent property.

ReportParameters

Contains an ordered list of parameters in the report.

Reversed   

Indicates whether the axis direction is reversed.

RightBorder

Defines the border properties for the right border of a report item.

Property values defined for the RightBorder override properties defined for the default values on a report item border. For more information about the rules that apply when a border is shared with another report item, see Border.

RightMargin

Specifies the width of the right margin of the report.

The string for the RightMargin property must evaluate to a Size. For more information about size designators, see CSS Length Units Reference on msdn.microsoft.com.

The maximum value for RightMargin is 160 in. The minimum size is 0 in.

Rotation, ChartDataLabel   

Defines the angle of rotation for label text.

Rotation, ChartThreeDProperties   

Specifies the angle of rotation.

RowSpan

Specifies the number of rows that the cell spans.

RowSpan must be 1 for CellContents inside a TablixCell.

RowSpan is ignored for CellContents inside a TablixHeader.

Top

S

Scalar   

Indicates whether the values on the axis are scalar.

ValueDescription
True The axis displays a set of values on a continuous scale. For example, if the dataset contains data for January, March, July, November, and December, a non-scalar axis displays only those months, while a scalar axis displays all of the months in the year.
False (default)The values on the axis are not scalar, that is, the axis displays only the values present in the data.

Scalar cannot be True if the axis has more than one grouping, has a static grouping, or has a grouping with more than one group expression. Scalar only affects axes in which the data contains numeric or date values.

Separator   

Specifies the type of separator to use for a legend custom item. Valid values are:

  • None (default)

  • Line

  • ThickLine

  • DoubleLine

  • DashLine

  • DotLine

  • GradientLine

  • ThickGradientLine

SeparatorColor   

Specifies which color to use for the separator.

SeriesSymbolWidth   

Defines the size of the series symbol as a percentage of the font size.

Shading   

Defines the shading of the three-dimensional chart. Valid values are:

  • None (default)

  • Simple

  • Real

ShowColumnAs

Series will be formatted as Normal, Histogram or Pareto after binding data to the series. This attribute will be ignored if series grouping or nested category grouping is used.

ShowGridLines

Indicates whether gridlines are displayed in the chart.

ShowOverlapped   

Indicates whether labels are displayed when overlapping issues cannot be resolved.

Size

Indicates the size of the marker.

The string for the Size property must contain a number (with a period character used as an optional decimal separator). The number must be followed by a designator for a CSS length unit such as cm, mm, in, pt, or pc. A space between the number and the designator is optional. For more information about size designators, see CSS Length Units Reference.

Size   

Specifies the size value for the data point.

Sizing

Determines the appearance of the image if the image does not fit the height and width of the Image property. Valid values are:

ValueDescription
AutoSize (default)Grows or shrinks borders of the image item to fit the image.
FitResizes the image to match the height and width of the Image property.
FitProportionalResizes the image to match the height and width of the Image property, preserving the aspect ratio.
ClipClips the image to fit the height and width of the Image property.

Rendering extensions that do not support the values FitProportional or Clip render as Fit instead.

SortExpression

Contains the expression by which to sort the data.

Only standard aggregate functions, like Sum, can be used in a sort expression.

Aggregate functions are evaluated using the default scope defined in the SortExpressionScope property. You can also specify a scope parameter for the aggregate function, but it must be equal to or contain the SortExpressionScope.

References to report items cannot be used in a sort expression.

SortExpressions

Defines an ordered list of expressions to use during a sort.

Each sort expression is applied in sequence from the ordered list to the data specified by the parent property.

SortExpressionScope

Contains the name of the scope (data region or group) in which to evaluate a sort expression.

If omitted, the expression will be evaluated and the sort will be performed independently in each detail scope within the SortTarget.

The value must be a scope that is equal to or contained within the current scope. If the text box has no current scope (for example, it is not contained in any data region), SortExpressionScope must be equal to or contained within the SortTarget property.

The data set for the SortExpressionScope must be the same as the data set for the SortTarget property.

Sorting takes place within the group containing the SortExpressionScope. For example, in a table with a country group and a city group with UserSort property on each header and SortExpressionScope of the corresponding group, the country sort will sort the country groups within the table, and the city sort will sort the city groups within each country group (without rearranging the country groups).

SortTarget

Specifies the name of the data region, group, or dataset for a sort.

If omitted, the sort will apply to the instance of the current scope.

The sort target must be within the current scope, an ancestor scope, or a peer scope which is a data region.

A Tablix group is only a valid SortTarget from within Tablix group scopes on the same Tablix axis. You cannot sort a row group from within a column group expression or sort a column group from within a row group expression.

Source

Specifies the source of the image specified in the Value property.

The Source property is a sibling of the Value property. The value of Source indicates the value of the Value property. Valid values are:

Value of Source propertyDescription
ExternalValue contains a constant or an expression that evaluates to a relative path to the image on the report server. For example, /images/logo.gif, logo.gif, or http://reportserver/images/logo.gif.For a report server running in SharePoint integrated mode, the image name must be a fully qualified SharePoint path.
EmbeddedValue contains a constant or an expression that evaluates to the name of an embedded image within the report.
DatabaseValue contains an expression for a field in the database that evaluates to the binary data for an image.

SourceChartSeriesName   

Defines the name of the series from which to derive.

Spacing   

Defines the amount of space to leave for a scale break, as a percent of the chart size.

Start   

Specifies the start/open value for the data point.

This property is optional for stock, candlestick and box plot chart types.

StripWidth   

Defines the width of the strip line.

StripWidthType   

Defines the unit for the strip line width. Valid values are:

  • Auto (default)

  • Number

  • Years

  • Months

  • Weeks

  • Days

  • Hours

  • Minutes

  • Seconds

  • Milliseconds

Style   

Contains information about the style of an item.

In a data region, such as Table, Matrix, List, or Chart, text style properties apply only to the text box that appears when the data region contains no rows. If the data region contains data, text style properties are ignored. In this case, text style is determined by the style properties for the text boxes contained within the data region.

When Style is used within the Subtotal property, Style overrides the style of any top-level items in the subtotal column or row. At the intersection of a row and a column, the style of the row overrides the style of the column.

When Style is used within the Axis property, text style properties apply to the axis labels, and line properties apply to axis lines.

Style, Line

Specifies the style of a line or border. Valid values are:

  • None (default)

  • Dotted

  • Dashed

  • Solid

  • Double

Subreport

Contains information about a report that is included within another report.

A Subreport element is a type of ReportItem element.

Subreports can be nested. Subreports may not be contained in a PageSection property. The subreport Style property applies to the text box that contains the subreport.

When a subreport fails to execute during report processing, the report renderer displays the error message on the report page in the same location as the subreport would have been rendered.

The NoRowsMessage text displays in the subreport when no data is available for any subreport dataset used in the Body element of the subreport.

If no parameters are specified and the report contains no toggle properties, the subreport runs only once, even if the subreport is contained within a data region item such as a Tablix.

When the ReportParameter property UsedInQuery is set to Auto (the default), a reference to a subreport sets the value to True.

You can use the MergeTransactions property to merge transactions that are used in the subreport with the transactions in the parent report if the data sources are the same.

The following Report properties do not apply to Subreport: Description, Author, AutoRefresh, Width, Page, DataTransform, DataSchema. The following ReportItem properties do not apply to Subreport: Action, RepeatWith.

Subtype   

Indicates the subtype of the chart.

The Subtype property must contain a string appropriate to the chart type, defined by the Type property.

Top

T

Tablix

Defines a Tablix data region. A Tablix element contains a TablixBody, a TablixRowHierarchy, and a TablixColumnHierarchy property. A Tablix element may contain a TablixCorner property.

The TablixBody property contains one or more TablixRows elements and one or more TablixColumns elements.

TablixBody

Defines the layout and structure of the section of the Tablix data region that contains the data elements.

TablixCell

Defines the contents of each cell in the body section of a Tablix data region.

When you toggle visibility for a TablixCell, use the scope of the Tablix that contains it. You cannot toggle the visibility of a TablixCell based on report items in the TablixHeader for a TablixRow or TablixColumn.

TablixCells

Defines the ordered list of cells in a row of the body section of a Tablix data region.

TablixColumn

Defines a column in the body section of a Tablix data region.

TablixColumnHierarchy

Defines the hierarchy for a set of members for the columns in a Tablix data region.

TablixColumns

Defines the set of columns in the body section of a Tablix data region.

There must be as many TablixColumn elements as there are leaf-node TablixMembers in each TablixColumnHierarchy. A leaf-node TablixMember has no child groups.

TablixCorner

Defines the layout and structure of the corner section of a Tablix data region.

TablixCornerCell

Defines the contents of each corner cell in a Tablix data region. The width of each column for the corner cell is the width of the corresponding row header.

TablixCornerRow

Defines the list of cells in a row of the corner section of a Tablix data region.

TablixCornerRows

Defines the list of rows in the corner section of a Tablix data region.

TablixHeader

Defines the layout and contents of each Tablix member in a Tablix column hierarchy or Tablix row hierarchy in a Tablix data region.

TablixMember

Defines a Tablix member in an ordered list of members for a Tablix row hierarchy or Tablix column hierarchy in a Tablix data region. A Tablix member can contain a nested Tablix members list.

TablixMembers

Defines an ordered list of members in the row hierarchy or column hierarchy in a Tablix data region.

TablixRow

Defines the list of Tablix cells and the height of the row in the Tablix body section of a Tablix data region.

TablixRowHierarch

Defines the hierarchy for a set of members for the rows in a Tablix data region.

TablixRows

Defines the set of rows in the body section of a Tablix data region.

TextAlign

Specifies the horizontal alignment of the text in a text box. Valid values are:

  • General (default)

  • Left

  • Center

  • Right

Textbox

Defines a text box to be drawn in the report.

TextDecoration

Specifies text formatting for a report item. Valid values are:

  • None (default)

  • Underline

  • Overline

  • LineThrough

TextDecoration applies only to text box, subtotal, Chart title, and Chart legend.

TextWrapThreshold   

Defines the number of characters after which to wrap the legend text.

When legend text exceeds the value defined by this property then text will be automatically wrapped on the next whitespace. Text will not be wrapped if there are no whitespace characters in the text.

Set this property to zero to disable text wrapping.

Timeout

Specifies the number of seconds the query runs before timing out. The value for the Timeout property must be between 0 and 2147483647. If the value is omitted or is 0, the query does not time out.

Title

Contains the title of the item.

TitleAngle   

Specifies the angle at which to display the a strip line title. Valid values are:

  • 0

  • 90

  • 180

  • 270

TitleSeparator   

Specifies the type of separator to use for the legend title. Valid values are:

  • None (default)

  • Line

  • ThickLine

  • DoubleLine

  • DotLine

  • GradientLine

  • ThickGradientLine

ToggleImage

Indicates that a toggle image is displayed as a part of the text box.

The toggle image displays a minus sign (-) when a report item is expanded and a plus sign (+) when it is collapsed. The ToggleImage property is used in conjunction with the Visibility property on any report items that can be hidden. For more information, see Hiding Report Items Conditionally (Report Builder 2.0). Drilldown reports are created using toggle images.

ToggleItem

Specifies the text box that users click to show or hide the current item.

When a user clicks the text box specified in the ToggleItem property, the parent of the Visibility property ("current item") is alternately shown or hidden. If ToggleItem is not specified, the current item does not toggle.

The value of ToggleItem must be a text box in the same grouping scope as the current item, or in any containing grouping scope. It can be a text box within the current item only if the current grouping scope contains a value for the Parent property.

ToggleItem cannot be used in a page header or footer, nor can it refer to items within them.

ToolTip

Contains a short description of the item, which is displayed when users hover over them item.

The HTML rendering extension provided with Reporting Services uses the ToolTip property to display TITLE and ALT attribute values. Other rendering extensions can use this property in other ways.

Top

Specifies the distance of the item from the top of the containing item.

.

The maximum value for Top is 160 in. The minimum value is 0 in.

TopBorder

Defines the border properties for the top border of a report item.

Property values defined for the TopBorder override properties defined for the default values on a report item border. For more information about the rules that apply when a border is shared with another report item, see Border.

For more information about the report layout, see Formatting Report Items (Report Builder 2.0).

TopMargin

Specifies the width of the top margin of the report. The maximum value for TopMargin is 160 in. The minimum value is 0 in.

Transaction

Indicates whether the datasets that use this data source run in a single transaction.

Type, ChartMarker   

Defines the marker type for values. Valid values are:

  • None (default)

  • Square

  • Circle

  • Diamond

  • Triangle

  • Cross

  • Star4

  • Star5

  • Star6

  • Star10

  • Auto

Type, CustomReportItem

Specifies the type of custom report item for use by report design tools or the report server.

An unsupported Type generates a warning by either the report design tools or the report server. When the Type is unknown, the AltReportItem property is used in place of the CustomReportItem.

Top

U

UnicodeBiDi

Indicates the level of bi-directional embedding. Valid values are:

ValueDescription
Normal (default)Does not open an additional level of embedding.
EmbedOpens an additional level of embedding.
BiDi-OverrideSame as the Embed value, except that reordering is sequenced according to the direction property of the text, as specified in the Direction Element, Style property. This value overrides the implicit bidirectional algorithm.

UnicodeBiDi applies only to text box items.

For more information about UnicodeBiDi, see the "UnicodeBidi Property" topic at msdn.microsoft.com.

Up   

Indicates whether the smart label can move directly up.

UpLeft   

Indicates whether the smart label can move directly up-left.

UpRight   

Indicates whether the smart label can move directly up-right.

UsedInQuery

Indicates whether a report parameter is used in queries within the report. Valid values are:

  • True

  • False

  • Auto (default)

If Auto is specified, the report server attempts to detect whether the parameter is used in a query.

You use the UsedInQuery to determine whether queries containing parameters that are associated with the report parameter are executed if the report parameter changes. This impacts whether the parameter can be changed in snapshot reports.

UserDefined

This property can be defined by the user, to be used as a parameter to any other string property in the chart.

UserSort

Indicates that a sort button is displayed as a part of this text box in the rendered report. UserSort is applied to the text box that contains the column header.

The UserSort button allows the user to select a sort direction (ascending or descending) for columns in a rendered report. For more information about interactive sorting, see Sorting Data in a Report (Report Builder 2.0).

UseValueAsLabel   

Indicates whether the Y value of the data point is used as the label.

Top

V

Valid values are:ues

Provides a list of valid values for a parameter.

The Valid values are:ues property must have only one child property: either DataSetReference or ParameterValues. Valid values are:ues is ignored for Boolean parameters.

Value, CustomProperty

Contains the value for a custom property. The Value property can contain a string or an expression that evaluates to a variant.

Value, DataLabel

Contains the value for data labels.

The Value property contains an expression that evaluates to a variant. If Value is omitted, data values are used for labels.

Value, DataValue

Contains the value of the data point. The Value property contains an expression that evaluates to a variant.

Value, Field

Contains an expression that evaluates to the value of the field.

The expression within the Value property evaluates to a variant and cannot contain aggregates or references to report items.

The Field property must have one and only one child property: either DataField or Value.

Value, Image or BackgroundImage

Identifies the source of the image.

The contents of the Value property and the data type it returns depends on the value of the Source property, which is a sibling to Value. Valid values are:

Value of Source element Description
ExternalValue contains a string or an expression that evaluates to a string that contains the path to the image.
EmbeddedValue contains A string or an expression that evaluates to a string that contains the name of an embedded image within the report.
DatabaseValue contains an expression for a field in the database that evaluates to the binary data for an image.

Value, Parameter

Contains the value for an individual parameter that is passed to a subreport or drillthrough report.

The Value property contains an expression that evaluates to a variant.

Value, ParameterValue

Contains a possible value for the parameter.

The Value property contains the actual parameter value to be passed. The sibling property, Label, contains a user-friendly parameter name.

The Value property contains an expression that evaluates to a variant. The following rules apply for non-string parameters:

  • For Boolean parameters, use True and False.

  • For DateTime parameters, use the International Organization for Standardization (ISO) 8601 standard.

For Float parameters, use a period character as the optional decimal separator.

Value, QueryParameter

Contains a query parameter value used to filter data from the data source.

The Value property contains an expression that evaluates to a variant . The expression can include report parameters but it cannot contain references to report items, fields in the report dataset, or aggregate functions. For more information, see Using Query Parameters with Specific Data Sources (Report Builder 2.0).

Value, Textbox

Contains the value of the text box. This value can be a field name, a constant, or another expression.

Value, Values

Contains an individual value or expression to be used as a default for the parameter.

The expression for the Value property evaluates to a variant. It cannot refer to fields, items in the report, or any parameters that occur after the current parameter.

ValueAxisName   

Defines the name of the value axis on which to plot the data point.

ValueField

Contains the name of the field that contains the valid values or the default value of the parameter.

Values

Contains the hard-coded default values for a parameter. Only one default value is allowed for Boolean parameters.

DefaultValue can have one and only one child property: DataSetReference or Values.

Variable

Defines a named expression to be evaluated within the group or report.

VariableAutoInterval   

Indicates whether an automatic interval is calculated on available size or on the data range.

Variables

Defines a set of variables to be evaluated within the group or report.

VerticleAlign

Describes the vertical alignment of the text of the item. Valid values are:

  • Top (default)

  • Middle

  • Bottom

VerticalAlign applies only to text box, subtotal, title, and legend report items.

Visibility

Indicates whether the item is displayed in the rendered report.

Visible

Indicates whether the item is displayed in the chart.

Top

W

WallThickness   

Specifies the percent of thickness of the outer walls of the three-dimensional chart.

Width

Indicates the width of the item. The value for the Width property must be a valid Size.

The maximum value for Width is 160 in. The minimum value is 0 in.

Only lines can have a negative width. Height combined with width determines the endpoint of the line.

If the Width property is omitted, the default is the value of Width for the containing item minus the value of the sibling Left property, except for a Tablix data region. For a Tablix, the default is derived from the sum of the widths of the columns, rows, and cells.

Setting a report item width to 0 does not hide the report item when rendered. To hide a report item, set the visibility property Hidden to true.

WidthSensitivitiy

Indicates whether the data is width-sensitive. Valid values are:

  • Auto (default)

  • True

  • False

If Auto is specified, the report server attempts to get information about width sensitivity from the data processing extension. If the extension cannot provide this information, the default value of WidthSensitivity is False.

WritingMode

Indicates whether the text is written horizontally or vertically. Valid values are:

ValueDescription
lr-tbText is written horizontally.
tb-rlText is written vertically.

WritingMode applies only to text box report items.

Top

Z

ZIndex

Indicates the drawing order of the item within the containing object. Items with lower indices are drawn first, appearing behind items with higher indices.

The minimum value for the ZIndex property is 0. The maximum value is 2147483647.

Top

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft