fyiReporting Software, LLC
Home
Products
Downloads
Forum
Release Notes
Report Topics
DataSets
Data Sources
Expressions
Overview
Functions
Report Parameters
Report Items
Chart
Image
List
Matrix
Rectangle
Subreport
Table
Textbox
Designer
Overview
How do I?
Create a New Report
Create a Table
Graph data
Cross tabulate data
Do Labels
Options
Menus
File
Edit
View
Data
Format
Tools
Window
Help
Error Handling
Examples
ASP.NET
Code Examples
RDL Examples
Desktop Server
Command Line Utility

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.

The position of the report item only show when not part of a Table or Matrix. Positions can have the following units

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.

The Text Processing options only appear for the Textbox report item.

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.

The Action properties control action should be taken on a mouse click of the report item.

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.

Visibility controls whether the item shows in the 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

Copyright © 2005-2007 fyiReporting Software, LLC.   All Rights Reserved.