Contents

 
Home
ASPRunner Professional 9.0 manual
Prev Page Next Page
 
 

Creating web report

 

 

To create new report, click Create Report button on the start page and follow the steps to define report settings.

The Back and Next buttons allow you to jump to previous and next page correspondingly. Use Jump to... button to jump to any other page. The Save button saves the report and move you to the web reports menu (start page). Use the SQL Query button to view resulting SQL query and query results. The Preview button allow you to see how you report will look.

Below you can find the description of the report creation steps:

Expand All   Collapse All

On this page you can choose a table, view or SQL query as a data source for your report. Note that tables that are not added to the project from a database are not available for selection.

Tables from the database

· All tables added to the project are available for selection. User tables (custom views) are not available.
· When viewing a report, all user permissions (static and dynamic permissions, advanced security option) and "view/edit" field settings do not work.
· While creating a report you will be able to create table relations (SQL joins) to query data from two or more tables and add additional search conditions using WHERE clause.

Tables from the project

· All tables added to the project and custom views created in ASPRunnerPro are available for selection.
· When viewing a report, user permissions and "view/edit" field settings work as usual.
· While creating a report you will not be able to create table relations (SQL joins) to query data from two or more tables and add additional search conditions using WHERE clause. The SQL queries defined in ASPRunnerPro will be used to query data for report.
· Tables for selection are displayed as Caption (table title), e.g. Cars (carscars).

SQL queries

On the SQL queries tab a user with admin permissions can create new custom SQL query using the New query button and edit the existing SQL queries using the SQL Query button. For more information about custom SQL queries, see Custom SQL.

webreports_tables

yellowbulbNote: this page is available if you selected a table from the database as report data source.

On this page you can create table relations (SQL joins) to query data from two or more tables, based on a relationship between certain fields in these tables. You can add Inner Join, Left Join, Right Join and Full Outer Join.

To add an SQL join, choose tables and fields to be joined and click Add Relation. The JOIN clause will be added below the SELECT clause. Note that you can add several table relations.

webreports_relations

Use SQL Query button to view resulting SQL query and query results.

webreports_sql

Use the Remove Relation button to delete the selected table relation.

yellowbulbNote: this page is available if you selected a table from the database as report data source.

On this page you can add additional search conditions using WHERE clause. Select a field and type search criteria in the textboxes on the right. Search criterion should be added as <operator><value>. E.g. ='USA'; =2009; <>'red'; >10.

webreports_conditions

Use the SQL Query button to view resulting SQL query and query results.

webreports_sql1

On this page you can add group fields to group the results by one or more columns. The following picture explains how each option works.

webreports_groupfileds

If you clear the Details and summary check box, only summary will be shown in the report.

Besides standard intervals (new group starts when group field value changes) you can use other interval types. Available interval types are different for each data type. Here is the example of text group field using first letter as an interval.

webreports_group_letter_interval

Use the SQL Query button to view resulting SQL query and query results.

On this page you can choose what fields to display in the report and specify field labels. Also you can apply aggregate functions like MIN, MAX, SUM and AVERAGE. The results of these calculations will be displayed after each group and at the end of page/report. Note than you can't modify settings for group fields. Use arrows on the left of the field names to change the fields order.

webreports_totals

On this page you can choose report layout. If you use grouping you can choose between Stepped, Block, Outline and Align layouts. If you don't use grouping you can use only Tabular layout.

Print-friendly page option enables/disables the following features: printing the whole report or its page in print-friendly version, opening a report as Microsoft Word or Microsoft Excel document.

Use Number of lines per page option to determine where to insert the page break, when you print the whole report.

webreports_misc

On this page you can define sort fields to sort the records in the report. Note than you can't modify settings for group fields.

webreports_sort

Use the SQL Query button to view resulting SQL query and query results.

On this page you can define font settings and background color to be used in the report. Firstly, select report element and then define style settings for it. Using apply to dropdown list box you can apply changes made to a group (row), field (column) or all text in the report. Use Reset to default button to return to default settings.

webreports_style_editor

On this page you can define the report name and title. If your project uses security, you have also an option to make a report private. Private reports are not accessible by anyone but owner. Non-private (public) ones will appear under "shared" section on the start page.

webreports_settings

yellowbulbNote: this page is available if you enabled dynamic permissions in ASPRunnerPro and a report is not marked as private on the previous step.

On this page you can assign user group permissions to view/edit/delete a report.

webreports_permissions

Converted from CHM to HTML with chm2web Standard 2.85 (unicode)