Exploring Page Reports

Page reports can be of two types - an FPL, fixed page layout report, and a CPL, continuous page layout report. You can convert FPL reports to CPL and CPL reports to FPL - see Report Menu for details. FPL and CPL reports have some differences in report elements, so a Report Explorer shows different nodes for an FPL and a CPL.

When you have a page report open in the ActiveReports Designer, an FPL type is displayed by default and you can see nodes like the following.

Document Outline
- Each report page
  - Each control on the page, for example:
  - BandedList
  - Matrix
  - Table
Data Sources
- DataSource (right-click to add a data source; you can have more than one)
  - DataSet (right-click the DataSource to add a data set)
    - Fields (drag onto the report or onto a data region)
  - Another DataSet (you can have more than one)
Parameters (right-click to open a dialog and add a parameter)
EmbeddedImages (right-click to browse for an image to add)
CommonValues (drag onto the report to display the value in a textbox)

To have a CPL open in the ActiveReports Designer, you should open a page report - an FPL by default, and then convert it to a CPL.

Show To convert an FPL to a CPL

In the File menu, select Open to open an existing page report in the ActiveReports Designer, or select New... and then Page Report to create a new page report.
In the Report menu, click Convert to CPL Report.

After you have an FPL converted to a CPL, you can see nodes like the following:

Document Outline
Body (default, cannot be removed)
Page Header and Footer (can be added)
- Each control, for example:
- TextBox
- Picture
- PageBreak
- SubReport
Data Sources
- DataSource (right-click to add a data source; you can have more than one)
  - DataSet (right-click the DataSource to add a data set)
    - Fields (drag onto the report or onto a data region)
  - Another DataSet (you can have more than one)
Parameters (right-click to open a dialog and add a parameter)
EmbeddedImages (right-click to browse for an image to add)
CommonValues (drag onto the report to display the value in a textbox)

In the Report Explorer, in addition to removing controls, adding, editing or removing parameters, adding a data source, and dragging fields onto the report, you can also share a data source; add datasets; add, edit, or remove embedded images; and drag common values like page numbers, current date, or report name onto the report as a textbox. You can also select the report or any element in the report to display in the Properties window, where you can modify its properties.

Show To add a DataSource

In the Report Explorer, right-click the Data Sources node and select Add Data Source. The Report Data Source dialog appears, open to the General page.
On the General page, drop down the Type list and select Microsoft OleDb Provider.
Under Connection, on the Connection Properties tab, drop down the OLE DB Provider list and select Microsoft.Jet.OLEDB.4.0.
In the Server or file name box, enter the path and file name to your Access database, for example,
C:\Program Files (x86)\ComponentOne\ActiveReports 6\Data\NWIND.MDB.
Under Log on to server, select the radio button next to Use Windows NT integrated security.
Click the Accept button. The new data source is added to the Data Sources node. To use fields from the data source, add a data set.

Show To share a DataSource

In the Report Explorer, expand the DataSources node, right-click the node for the data source that you want to share, and select Share Data Source. The Save Shared Data Source File dialog appears.
Navigate to the folder where you want to save the file, enter a name for the file, and click Save.
The type of data source as well as the connection string are saved to a file of type RDSX that you can use in other reports.

Show To add a DataSet

In the Report Explorer, expand the DataSources node, right-click the node for the data source that you want to use, and select Add DataSet. The DataSet dialog appears.
In the list to the left, select Query to show the Query page.

In the Query box to the right, enter a SQL query to pull the data you want for your report.

Example Query	Copy Code
SELECT * FROM Customers

Click the Accept button to create the data set. The data fields appear in the data set node.

Show To bind a DataSet field to a TextBox control

In the Report Explorer, expand the DataSources node, then the node for the data source, then the DataSet that you want to use.
From the DataSet node, click the DataSet field that you want to bind to a TextBox control, drag it onto the report surface or onto a data region and drop it.
A TextBox control is created and bound to the field with the proper expression in the Value property. For example, if you drag the City field onto the report, the Value property of the TextBox contains the expression =Fields!City.Value.

Show To add parameters

In the Report Explorer, right-click the Parameters node and select Add Parameter. The Report Parameters dialog appears.
On the General tab of the dialog, enter text for prompting users for a value.
On the Available Values tab, you can select values from a DataSet to populate a list from which users can select a value.
On the Default Values tab, you can provide default values to use if the user does not select a value.
Click Accept to save the parameter. The new parameter appears in the Report Explorer under the Parameters node.
From the Report Explorer, drag the parameter to report design area to create a TextBox that is bound to the parameter. When you run the report, the value that the user supplies in the prompt dialog displays in the bound TextBox on the report.