fyiReporting Software, LLC
Table
- DataSet Name
- The DataSet that provides the source of data for this table.
- No Rows Message
- If there are no rows in the DataSet (after filtering is applied) then this message will be used in place of the table.
- Page Breaks
- You can force page breaks before or after the table.
- Include Table Rows
- You can optionally include header, footer and detail rows for this table.
- XML Render Details In Contents
- If checked the contents of detail rows will be output when XML rendering the table.
- Detail Element Name
- The element name used when rendering the Detail element.
- Detail Collection Name
- The element name surrounding all the Detail elements.
Filters allow rows to be removed from the DataSet. For example, you might be interested in only the Top 10 sales for a department.
- Filter Expression
- The filter expression is the left side of the filter operation. This is typically a Field expression. For example, =Fields!deptSales.Value.
- Operator
- The following operators are supported: Equal, Like, NotEqual, GreaterThan, GreaterThanOrEqual, LessThan, LessThanOrEqual, TopN, BottomN, TopPercent, BottomPercent, In, and Between. For the Top 10 example you would use TopN.
- Value
- For most operators this is a single expression. For 'In' you specify a list of value expressions separated by comma (e.g. 'v1', 'v2', 'v3'). For 'Between' you specify two value expressions, the beginning and ending values (e.g. 5, 10 ). For the Top 10 example you would use 10.
Grouping allows you to create a hierarchical table. A group allows you to show group headers and footers whenever the value defined by group expressions change value.
- Name
- A name that must be unique amoung all groups and datasets.
- Group By
- One or more expressions that define the group.
- Label
- A label to identify the group within the UI. Not currently used.
- Parent
- An expression that defines the parent group in a recursive hierarchy. See the example report EmployeeOrg.rdl in the examples.
- Page Break at Start
- Force a new page at the start of each group value.
- Page Break at End
- Force a new page at end of each group value.
Sorting defines the order of the rows within the report item.
- Sort Expression
- The expression that is evaluated when performing the sort. For example, =Fields!dept.Value
- Sort Ascending
- When checked the order will be ascending (increasing) in value. Otherwise it will be descending (decreasing) in value.
- Delete button
- Deletes the current sort item.
- Up button
- Moves the current sort item up in th list.
- Down button
- Moves the current sort item down in the list.
Visibility controls whether the item shows in the report.
- Hidden
- Controls the visibility of the column. When true the column is hidden.
- Toggle Item
- The Textbox report item that toggles the visibility. Not currently supported for table columns.
- Column Width
- The width of the column.
- Fixed Header
- Fixed headers on not currently supported by any renderer.
Visibility controls whether the table row shows in the report.
- Hidden
- Controls the visibility of the table row. When true the table row is hidden.
- Toggle Item
- The Textbox report item that toggles the visibility.
- Row Height
- The height of the row.
- Name
- The name of the report item must be unique within all report items.
- Span Table Columns
- This property only shows when a report item is located within a TableCell. Spanning allows a report item to cover more than 1 column in the table.
- in -> inches (1 inch = 2.54 cm)
- cm -> centimeters (.01 meters)
- mm -> millimeters (.001 meters)
- pt -> points (1 point = 1/72.27 inches)
- pc -> Picas (1 pica = 12 points)
- Left
- Location of the left side of the report item
- Top
- Location of the top side of the report item
- Width
- Width of the report item. Matrixes and Tables should not have widths specified as they are calculated.
- Height
- Height of the report item. Matrixes and Tables should not have height specified as they are calculated.
- Z Index
- Order of the rendering of the object. Z Index isn't relevent unless there are overlapping report items.
- Can Grow
- The height of the textbox will dynamically grow if the contained text requires it.
- Can Shrink
- Not currently supported by the RDL runtime engine.
- Hide Duplicates
- If the previous instance of this report item on the current page and current group is the same as this one hide this Textbox.
- XML element style
- Choices are Auto, attribute-normal, element-noremal.
- Toggle Image
- Does this item need a toggle image? true/false
- Style
- Valid values are None, Dotted, Dashed, Solid, Double, Groove, Ridge, Inset, WindowInset, Outset. However not all renderers support all border styles. Example: None, =iif(Fields!salary.Value > 100000, "Solid", "None")
- Color
- Color of the border. Example: blue, =iif(Fields!salary.Value > 100000, "red", "black")
- Width
- Width of the border. Example: 1pt
- Default
- Sets the default to use when a side isn't specified.
- Left, Right, Top, Bottom
- The cooresponding edge of the border you want to set.
- Background Color
- The background color of the report item. Examples: red, green, =iif(Fields!salary.Value > 100000, "green", "black")
- Background Gradient
- Only enabled for charts. Possible values: None (Default), LeftRight, TopBottom, Center, DiagonalLeft, DiagonalRight, HorizontalCenter, VerticalCenter.
- Background End Color
- Only enable for charts. Specifies the endding color for the gradient.
- Padding
- Size expressions that control the spacing around the report item. Examples: 2pt, =iif(Fields!salary.Value > 100000, "2pt", "4pt")
- XML DataElementName
- When rendering in XML this name will be used instead of the report item name.
- XML DataElementOutput
- Output indicates report item should render, NoOutput report item should not render.
- None
- Take no action
- Hyperlink
- Link to the specified (or calculated) URL.
- BookmarkLink
- Link to the specified (or calculated) ID of a bookmark within the report.
- Drillthrough
- Link to the specified report passing the specified parameters as report parameters in the linked report.
- Hidden
- Controls the initial visibility. When True the report item is hidden.
- Toggle Item
- The Textbox report item that toggles the visibility.
- Bookmark
- The ID of the report item in the report. Example: =Fields!prodname.Value
The position of the report item only show when not part of a Table or Matrix.
Positions can have the following units
The Text Processing options only appear for the Textbox report item.
The Action properties control action should be taken on a mouse click of the report item.
Visibility controls whether the item shows in the report.