Report Card

Figure 1: Creating A New Module

1. Module Name: Give a name to your module.
2. Select "Report Card" module and click Create.

Figure 2: Report Card SQL Query module

If it doesn not exist or not yet created, Report Card module requires a specialize SQL Query module condition. Report Card SQL Query module MUST contain a WHERE filter condition and a POST/GET Form variable option set to query data from a database table to populate the Report Card. You wont be able to proceed with configuring your Report Card module if the SQL Query module condition is not available

See link below how to create your SQL Query module

  • Creating SQL Query module
  • Figure 3: Configuring your New Report Card module

    Optionally, you can give your Report a title, then select the SQL Query to use to query the report data. Notice only compatible SQL Queries will be listed.

    Figure 4: Adding and Configuring Report Card Components

    Add and Edit your Report Card components from the "+ Add and Edit" Card Components buttons. Report Card currently support only four (4) types of component.

  • Header
  • Text
  • Paragraph
  • Image
  • Figure 5: Static Component Values

  • STATIC VALUES: Component value is to be set statically.
  • Figure 6: Dynamic Component Values

  • DYNAMIC VALUES: Component value will be queried from the database table.
  • Figure 7: Report Card Example Component Configuration

    Optionally, component can have labels and can be statically set or dynamic queried from a database table.

    Figure 8: Dynamic Component Values

  • DYNAMIC VALUES: Component value will be queried from the database table.
  • Figure 9: Example Single Pane Report Card Layout

    Components are assembled using a single pane layout.

    Figure 10: Double Pane Report Card Configuration

    Report card can be configured to a double pane layout with fieldlabel orientation option of Left or Top. See figure below..

    Figure 11: Example Double Pane Report Card Layout

    Components are assembled using a double pane layout.