Creating/Editing a table scope

  1. The name of the scope. This is the class (or type) name of the view.
  2. The root is the entry point from where you can start to define a report template. If you leave the name empty, then the scope can only be used as a sub-scope of other scopes.
  3. The primary key of this table. (Optional)
  4. Whether this is a table that contains only a single row. Singletons are treated specially in ReportWeaver to simplify the report design process.

To specify the tables/views/queries that make up your scope, please use the Link Panel:

  1. This is the list of the tables in your database. Drag it from the list to the graphic pane on the right to add it to your scope. (Tables or related scopes that are not connected via a link will be removed from the scope on exit.
  2. This is the list of the scopes in your schema. Reference the other scope by dragging it onto the graphic pane.
  3. This is a scope element, which is based on a table, a view or a query.
  4. These are the links to the other elements of the scope.
  5. This is a link with cardinality one. This means, that there is one Customer related to an Invoice.
  6. This is a link with cardinality many. This means, that there are many OrderItems in an Invoice.

To create a link, drag the source scope element on to the target element.

  1. Dropping the OrderItems here (on the Products element) will create a link. Reportweaver will show the link-dialog, where you can specify the details of your link.

In the members tab you can select the columns, that you want to show in your scope. You can also specify the links to other scopes/tables/queries/views.

  1. The available columns in the table.
  2. The fields that you have chosen. They will be available in the report design.
  3. This adds the selected columns on the left to your scope on the right.
  4. Removes the selected fields on the right from the scope.
  5. Adds a special member, under which you can group the details of a master detail query.
  6. Adds a link to another scope (table/query/view). This allows you to access several joint tables in a report. Linking scopes
  7. Edits the properties of the selected link. Linking scopes
  8. Shortcut that adds all columns to the scope.
  9. Here a branch has been created. The Invoices view of this example contains the data from the Order and the OrderDetails table. The branch specifies which fields come from the order details. For a simple first report this is not needed.