Ariacom Business Reports® Quick Start Guides

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 an ODBC database connection string.
  1. On the Start menu, point to "Programs > Ariacom Business Reports" and then click "Report Manager".
  2. In the left tree view, expand the node "Main". The public folder of the business domain appears.
  3. Click on the "New Report" icon (top-left in the toolbar ) or type "Ins". The ODBC Connection string Wizard appears.
  4. Define and test your ODBC connection string and click "OK". The "Report Editor" dialog appears.
  5. Type your report name and click "Next".
  6. In the Select "SQL Statement" box, type your SQL statement (e.g. "select * from employees") and click "Next".
  7. In the Available Elements panel, expand the "Elements" node, then drag and drop the elements you want to see in the report them in the "Row" area Selected Elements panel.
  8. If necessary, use the Restrictions panel to filter data.
  9. Click "Execute", the report is executed.
  10. Click "Close" then "Save". The report is saved in the repository.

Build a first Business Domain and Reports based on your database schema (10 minutes)
This guide shows how to create a first Business Domain describing your database metadata.
Based on this Business Domain, reports can be easily built and executed using dynamic SQL generation.
Step 1: Create your first Business Domain.
  1. On the Start menu, point to "Programs > Ariacom Business Reports" and then click "Business Domain Manager".
  2. On the File menu, click Business Domain Wizard (or Ctrl+W). The Business Domain Wizard dialog box appears.
  3. Select your database type in the list and click "Next".
  4. Enter the information required for the database connection string and click "Next".
  5. Select the tables or the views you want to query and then Click ">".
  6. The tables are listed in the right list. Click "Next".
  7. Enter your the business domain name and click "Finish".
  8. An information dialog box appears to acknowledge the creation of the domain, and to propose the edition of a report on the domain. Click "No".
  9. On the File menu, click "Save" and save the file on the disk.
Step 2: Create, execute and store your first reports.
  1. On the Start menu, point to "Programs > Ariacom Business Reports" and then click "Report Manager".
  2. In the left tree view, expand the node corresponding to the Business Domain previously created. The "Domain Login" dialog box appears.
  3. In the "User Name" box, type "su" and click "OK". The public folders of the business domains appear.
  4. Click on the "New Report" icon (top-left in the toolbar ) or type "Ins". The "Report Editor" dialog appears.
  5. Type your report name and click "Next".
  6. In the Available Elements panel, expand the nodes corresponding to your table names, then drag and drop the elements you want to see in the report in the "Row" area of the Selected Elements panel.
  7. If necessary, use the Restrictions panel to filter data.
  8. Click "Execute", the report is executed.
  9. Click "Close" then "Save". The report is saved in the repository.

Go further: Make the tutorial installed with the product
On the "Start" menu, point to "Programs > Ariacom Business Reports > Documentation" and then click "Tutorial".
Consult also the "Report Manager" and the "Business Domain Manager" Help Files.