Properties in Report Builder 2.0

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.

Properties

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 None The chart area is not aligned with another chart area. Vertical The chart area is vertically aligned. Horizontal The chart area has a vertical alignment orientation. All The 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. Rotate15 Rotate in 15 degree increments. Rotate30 Rotate in 30 degree increments. Rotate45 Rotate in 45 degree increments. Rotate90 Rotate 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. Triangle An arrow with a triangle on the end is displayed on the axis labels. SharpTriangle An arrow with a sharp triangle on the end is displayed on the axis labels. Lines An 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. NoRepeat Displays the image only once; the image does not repeat. RepeatX Repeats the image horizontally in the background. RepeatY Repeats 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 Start Page break before the group or report item. End Page break after the group or report item. StartAndEnd Page break both before and after the report item Between Page 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. StoredProcedure Indicates that the value is the name of a stored procedure to execute. The stored procedure must return a single result set. TableDirect Indicates 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 True Eliminates the space around report items on the design surface. This also eliminates unused space at the end of a report. False Preserves 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 Output Indicates the item appears in the output. NoOutput Indicates the item should not appear in the output. ContentsOnly Applies 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, Y X, Y, Size High, Low, Close Open, 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. RTL Text 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 True The item should initially be hidden on the report. False The 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 True The toggle image is a minus sign (-), for expanded. False The 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). RTL Dynamic 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. 2 0123456789 3 Traditional 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. 4 ko, ja, zh-CHS, zh-CHT only. 5 ko, ja, zh-CHS, zh-CHT only. 6 ko, ja, zh-CHS-zh-CHT only (wide versions of regular digits). 7 ko 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. Fit Resizes the image to match the height and width of the Image property. FitProportional Resizes the image to match the height and width of the Image property, preserving the aspect ratio. Clip Clips 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 External Value 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. Embedded Value contains a constant or an expression that evaluates to the name of an embedded image within the report. Database Value 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. Embed Opens an additional level of embedding. BiDi-Override Same 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 External Value contains a string or an expression that evaluates to a string that contains the path to the image. Embedded Value contains A string or an expression that evaluates to a string that contains the name of an embedded image within the report. Database Value 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-tb Text is written horizontally. tb-rl Text 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

See Also

Concepts

Designing the Report Layout (Report Builder 2.0)