Seal Report Quick Start The ultimate open database reporting tool

Seal Report Logo
Build a report from a simple SQL statement (2 minutes)

Build a report from a simple SQL statement (2 minutes)

This guide shows how to create and execute a report from a simple SQL statement and a database connection.

  1. 01.

    In the Start menu, point to "Programs->Seal Report" and then click Report Designer.

  2. 02.

    Click on New (top-left in the toolbar)

  3. 03.

    In the left tree view, right-click on the root node named "Sources" and select [Add Data Source] in the contextual menu.
    A new source is created and the source connection is displayed.

  4. 04.

    Edit the Connection String property with the OLE DB Wizard and verify the connection is working using the [Check Connection] helper or [F7].

  5. 05.

    In the left tree view, click on the Table node named "SealMasterTable". The table is displayed.

  6. 06.

    Press [F8] to edit the Select SQL Statement for the Master table of the source.
    The SQL Editor Dialog appears.

  7. 07.

    In the text box, type your SQL statement (e.g. "select * from products") and click [OK].

  8. 08.

    In the left tree view, click on the Model node called "model". The model is displayed.

  9. 09.

    In the model definition, select the Data Source called "Data Source" that you have previously created.

  10. 10.

    In the elements tree view, expand the "Master" node, then drag and drop the elements you want to see in the Row panel.

  11. 11.

    If necessary, drag and drop elements in the restrictions panel to filter data.

  12. 12.

    Click [Execute] or press [F5].
    The report is executed.

  13. 13.

    Click [Close] then [Save] to save the report in the repository.

Build a first repository Data Source and Reports based on your database schema (5 minutes)

Build a first repository Data Source and then Reports based on your database schema (5 minutes)

This guide shows how to create a first Data Source describing your database metadata. Based on this Data Source, reports can be easily built and executed using dynamic SQL generation.

Step 1: Create your first Data Source.

  1. 01.

    In the Start menu, point to "Programs->Seal Report" and then click Server Manager.

  2. 02.

    On the File menu, click [New->Data Source].
    A new Data Source is created and the connection is selected.

  3. 03.

    Edit the Connection String property with the OLE DB Wizard and check the connection configured using the [Check Connection] helper or [F7].

  4. 04.

    In the left tree view, right-click on the root node called "Tables" and select [Add Tables from Catalog...] in the contextual menu.
    A dialog box appears.

  5. 05.

    Select the tables in your Data Source and click [OK].
    Tables, columns and joins have been automatically added.

  6. 06.

    Click [Save] to save the Data Source in the repository.

Step 2: Create, execute and store your first reports.

  1. 01.

    On the Start menu, point to "Programs->Seal Report" and then click Report Designer.

  2. 02.

    Click on [New] (top-left in the toolbar).

  3. 03.

    In the left tree view, click on the Model node called "model".
    The model is displayed.

  4. 04.

    In the model definition, select the Data Source you have previously created.

  5. 05.

    In the elements tree view, expand the nodes with the table names, then drag and drop the elements you want to see in the Row panel.

  6. 06.

    If necessary, drag and drop elements in the restrictions panel to filter data.

  7. 07.

    Click [Execute] or press [F5].
    The report is executed.

  8. 08.

    Click [Close] then [Save] to save the report in the repository.