Top  | Previous | Next

Row Selector

reporting_RowSelector

Description

The row selector is a component that acts like a visual filter for datasets. It takes one dataset, chops it up into various ranges based on its configuration, and lets the user choose the splices. Then it creates a virtual dataset that only contains the rows that match the selected splices.

 

The most common way to splice the data is time. You could feed the row selector an input dataset that represents a large time range, and have it break it up by Month, Day, and then Shift, for example. Then you could power a report with the output dataset, and that would let the user dynamically create reports for any time range via an intuitive interface.

 

To configure the row selector, first you set up the appropriate bindings for its input dataset. Then you use its Customizer to alter the levels that it uses to break up the data. In the customizer, you add various filters that act upon columns in the input dataset, sorting them by various criteria. For example, you could choose a date column, and have it break that up by quarter. Then below that, you could have it use a discrete filter on a product code. This would let the user choose quarterly results for each product. Each level of filter you create in the customizer becomes a level in the selection hierarchy. Note that the output data is completely unchanged other than the fact that rows that don't match the current user selection aren't present.

 

This component is very handy for driving the Report Viewer, Table, and Classic Chart components, among others.

Properties

Appearance

Font

Font of text of this component

Scripting name

font

Data type

Font

Foreground Color

The foreground color of the component.

Scripting name

foreground

Data type

Color

Background Color

The background color of the component.

Scripting name

background

Data type

Color

Selection Background

The background color of the selected node.

Scripting name

selectionBackground

Data type

Color

All Data Node Text

Text for the 'All Data' node, if it is displayed

Scripting name

allDataNodeText

Data type

String

Flags

expert

Unknown Node Text

Text for any 'Unknown' nodes (nodes where the data didn't match filter)

Scripting name

unknownNodeText

Data type

String

Flags

expert

Unknown Node Icon

Icon for any 'Unknown' nodes (nodes where data didn't match filter)

Scripting name

unknownIconPath

Data type

String

Flags

expert

Behavior

Show All Data Node

Should the 'All Data' (root) node be shown or hidden?

Scripting name

showAllDataNode

Data type

boolean

Show Root Handles

Should root-level nodes have collapse handles?

Scripting name

showRootHandles

Data type

boolean

Flags

expert

Show Node Size

If true, the number of rows in each node will be shown

Scripting name

showNodeSize

Data type

boolean

Flags

expert

Common

Name

The name of this component.

Scripting name

name

Data type

String

Flags

bindable

Visible

If disabled, the component will be hidden.

Scripting name

visible

Data type

boolean

Border

The border surrounding this component. NOTE that the border is unaffected by rotation.

Scripting name

border

Data type

Border

Mouseover Text

The text that is displayed in the tooltip which pops up on mouseover of this component.

Scripting name

toolTipText

Data type

String

Opaque

If false, backgrounds are not drawn. If true, backgrounds are drawn.

Scripting name

opaque

Data type

boolean

Cursor

The mouse cursor to use when hovering over this component.

Scripting name

cursorCode

Data type

int

Values

0

Default

1

Crosshair

2

Text

3

Wait

12

Hand

13

Move

4

SW Resize

5

SE Resize

6

NW Resize

7

NE Resize

8

N Resize

9

S Resize

10

W Resize

11

E Resize

Data

Data In

The input of the row selection tree. The filter tree changes based on this DataSet.

Scripting name

dataIn

Data type

Dataset

Data Out

The output of the row selection tree. Changes based on user selection in the filter tree.

Scripting name

dataOut

Data type

Dataset

Flags

bindable

Uncategorized

Properties Loading

The number of properties currently being loaded

Scripting name

propertiesLoading

Data type

int

Flags

bindable | read-only

Scripting

Events

The following event sets are fired by this component. See Component Event Handlers to learn more.

mouse
mouseMotion
propertyChange

 

Scripting Functions

This component has no special scripting functions.