Skip to content

Editing Report Diagrams

Report blocks are ordered in a master/detail structure.

Adding blocks to the report structure

Each block is created by either adding it at the report level or as a child block to another block. New blocks are added by simply selecting Add Block from the context menu of the Blocks or Child Blocks lists.

Adding contents to a block

Attributes and parameters to a block are automatically added when a SQL statement is entered and the Apply button is pressed.

Note:   Use column aliases in the SELECT statement to get proper attribute naming.
Example: SELECT substr(date) short_date FROM...

Note:   Use parameters with an trailing underscore to get proper parameter naming.
Example: ... WHERE order_id = my_order_...

Diagram Toolbar

Figure:  Report Diagram Toolbar

Report diagram toolbar contains different tools to modify and add artifacts to the Report diagram.

  1. Report Block
    From the diagram toolbar, select the Report block icon and click once in the diagram editor to add a Report Block
  2. Block Aggregate
    From the diagram toolbar, select the Block Aggregate icon and click once on a blank area in the diagram editor to add a Block Aggregate. Then drag and drop it starting from report root/report block to a report block. Block aggregates could be used to show aggregates from root nodes to report blocks (not vice versa)or aggregates between report blocks
  3. Note
    From the diagram toolbar, select the Note icon and click once on a blank area in the diagram editor to add an Note. Note is used to add a comment to any element in the diagram.
  4. Note Link
    From the diagram toolbar, select the Note Link icon and click once in the diagram editor to add a Note Link. The Note Link should be added starting from a Note, i.e drag the Note Link from a Note to the desired diagram element.

Context Menu Options Available In Report Diagram Objects

Report

  • Open file
    Opens the model file [ReportName].report in the model editor
  • Add Attribute
    Adds a new Report Attribute to the Report
  • Add Parameter
    Adds a new Report Parameter to the Report
  • Properties
    Bring into view the Properties window of the IDE.

Report Block

  • Add Attribute
    Adds a new Report Attribute to the Report
  • Add Parameter
    Adds a new Report Parameter to the Report
  • Delete from model
    Removes the Report Block model from the Report. Also removes the report block object from the diagram.
  • Properties
    Bring into view the Properties window of the IDE.

Report / Block Attribute

  • Delete from model
    Removes the Report Block Aggregate from the Report / Block. Also removes the report block aggregate object from the diagram.
  • Properties
    Bring into view the Properties window of the IDE.

Report / Block Parameter

  • Delete from model
    Removes the Parameter model from the Report / Block.
  • Properties
    Bring into view the Properties window of the IDE.

Block Aggregate

  • Delete from model
    Removes the Block Aggregate model from the Report / Block.
  • Properties
    Bring into view the Properties window of the IDE.

Note

  • Remove from diagram
    Removes the node and links drawn to and from the node form the diagram.
  • Resolve Merged Info
    Resolves the merged state of a diagram object.
  • Remove from diagram
    Removes the link form the diagram.
  • Resolve Merged Info
    Resolves the merged state of a diagram object.