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

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.

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.

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.

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.

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.

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