ActiveReports 14
ActiveReports 14 User Guide / Concepts / ActiveReports Designer / Report Explorer / Exploring Page and RDL Reports
In This Topic
    Exploring Page and RDL Reports
    In This Topic

    When you have a Page or RDL report open in the ActiveReports Designer, you can see nodes like the following in the Report Explorer.

    In the Report Explorer, you can

    To add a DataSource

    1. 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.
    2. On the General page, drop down the Type list and select Microsoft OleDb Provider.
    3. Under Connection, on the Connection Properties tab, drop down the OLE DB Provider list and select Microsoft.Jet.OLEDB.4.0.
    4. In the Server or file name box, enter the path and file name to your Access database, for example, ..\Samples14\Data\NWIND.mdb.
    5. 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.

    To share a DataSource

    1. 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.
    2. Navigate to the folder where you want to save the file, enter a name for the file, and click Save.
    3. 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.

    To add a DataSet

    1. 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.
    2. In the list to the left, select Query to show the Query page.
    3. 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
      
    4. Click the Accept button to create the data set. The data fields appear in the data set node.

    To bind a DataSet field to a TextBox control

    1. In the Report Explorer, expand the DataSources node, then the node for the data source, then the DataSet that you want to use.
    2. 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.
    3. 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.

    To add parameters

    1. In the Report Explorer, right-click the Parameters node and select Add Parameter. The Report Parameters dialog appears.
    2. On the General tab of the dialog, enter text for prompting users for a value.
    3. On the Available Values tab, you can select values from a DataSet to populate a list from which users can select a value.
    4. On the Default Values tab, you can provide default values to use if the user does not select a value.
    5. Click Accept to save the parameter. The new parameter appears in the Report Explorer under the Parameters node.
    6. 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.
    See Also