A DataSet is a source of information for the report. You can refer to the Fields in a DataSet in expressions in the report.
- 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.
- 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.
- 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.
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.
- 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.
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.
- 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.
- 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.
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.