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:
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:
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:
|
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:
|
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:
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:
|
CalloutLineColor |
Specifies the color of the callout line. |
CalloutLineStyle |
. Specifies the style of the callout line. Valid values are:
|
CalloutLineWidth |
Defines the width of the callout line. |
CalloutStyle |
. Defines the style to use when drawing the callout lines. Valid values are:
|
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:
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:
|
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:
|
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:
|
ChartMinorTickMarks |
Specifies the position of the minor tick marks on the axis. Valid values are:
|
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:
|
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:
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:
|
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:
|
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:
|
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:
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:
|
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:
FontStyle applies only to text box and chart report items. |
FontWeight |
Specifies the thickness of the font for the item. Valid values are:
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:
|
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:
|
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:
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:
|
IntervalType |
Defines the units for the Interval property. |
Top
K
KanatypeSensitivity |
Indicates whether the data is kanatype-sensitive. Valid values are:
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:
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:
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:
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:
|
Layout, Legend |
Determines the arrangement of labels within the legend. Valid values are:
|
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:
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:
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:
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:
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:
|
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:
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:
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:
For non-pie charts, Outside reverts to Top. |
Position, ChartLegend2 |
Specifies the position of the legend. Valid values are:
|
Position, ChartTitle2 |
Specifies the position of the title. Valid values are:
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
Textbox |
Defines a text box to be drawn in the report. |
TextDecoration |
Specifies text formatting for a report item. Valid values are:
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:
|
TitleSeparator |
Specifies the type of separator to use for the legend title. Valid values are:
|
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:
|
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:
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 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:
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:
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