Skip to content

DataSets

Paulo Soares edited this page May 29, 2018 · 1 revision

DataSets

A DataSet is a source of information for the report. You can refer to the Fields in a DataSet in expressions in the report.

dataset

Name
The name of the DataSet. This can be used within the report in expressions.

Data Source
The name of the DataSource that should contains the connection information for this request.

SQL Select
The is the string that will be passed to the data provider. For a SQL based provider (most databases) this is a SQL Select statment or an Execute stored procedure command.

Timeout
The timeout is applied when running the query.

SQL button
This brings up a dialog with additional information that aids in building the SQL Select statement.

Refresh fields button
Takes the SQL command and obtains the list of columns in the SQL Select.

Fields
This table shows the fields in the query. The name column is the name the field is referred to in the report. The query column is the name the field is referred to in the SQL query. The Value column is used when you want to create a computed column after the query has been run. The TypeName column (scrolled out of view) shows the type of the field.

dataset_query

The query parameters are typically used in your query by put an '@' sign before the parameter name in the query command. Any number of parameters and their values may be specified.

Parameter Name
The name of the parameter.

Value
The value of the parameter at runtime. This is usually an expression. For example, '=Parameters!reportparm.Value' would pass the report parameter 'reportparm' runtime value to the query.

dataset_query

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.

dataset_data

Data allows you to define data to be carried with the report. You can also optionally specify an XML file that provides the data. This feature is an extension to the RDL specification. Other reporting products that support RDL will NOT support this capability. There is a column for each Field that has been defined. The last row enables you to add new rows.

Use XML file for Data
Instead of the data being provided in the report the data is provided via an XML file. The form of the XML is the same as would have been placed in the report via this dialog.

Delete button
Deletes the current row of data.

Up button
Moves the current row up in the list.

Down button
Moves the current row down in the list.

Clear button
Clears out all data.

Load from SQL button
Executes the SQL statement to load the data.

Clone this wiki locally