Using Report

First, if you use Microsoft Access, do not confuse Report in ASP.NET Maker with Report in Access. ASP.NET Maker does not load Reports in Access database. (ADO does not load Access Reports which are not part of database schema and they are Access-specific.) They have nothing to do with each other and they work differently.

Report in ASP.NET Maker can be used with any supported databases, the generated report page is a pure ASP.NET script, no server-side components is required.

A report is created from one existing table, view. If you need to display data from more than one table or view, join them first using a view in your database.

After loading the database, the database objects (tables, views, Custom Views and reports) will be shown in the left pane (the database pane). To create a report, right click the database pane and select [Add Report]. Alternatively, you can click [Edit] in the main menu and then select [Add Report].

The Report Setup window will show up:

 

The Report Setup window has 4 tabs. Go through these tabs one by one to setup your report.

 

General

ASP.NET Maker will give the new Report a temporary name, Report<n>, where n is an integer. If you want to change the name, enter a new name in the [Report name] edit box. Then you can select a table, or a view, or a Custom View form the [Table or View] combobox.

The field in the table will be displayed in the [Available fields] listbox, select fields you want to display by moving them to the [Selected fields] listbox. It is recommended that you select only the fields you required or the report page may be too wide to view without scrolling.

This settings in this tab are mandatory.

 

Grouping Levels

You can optionally add up to 6 grouping levels in either ascending or descending order and choose to show summary for each level. Select the grouping field for each level in the comboboxes and click the button next to the comboboxes to choose the sorting order. To enable summary, check [Show Summary] next to the grouping fields. When any of the [Show Summary] fields is selected, the [Summary Values] tab will appear for you to setup the summary values later. (See below)

If you want to have indentation for each level, enter a value in the [Indent] edit box. The unit is in pixels. (Note that the indent may be squeezed by your browser if the report table is too wide.)

 

Sort Order

You can optionally sort records by up to 6 fields, in either ascending or descending order. Select the sorting fields in the comboboxes. Press the button to change the sort order.

 

Summary Values

If any of the [Show Summary] checkboxes is selected in the [Grouping Levels] tab, this tab will become visible. You can optionally select aggregate values for each selected numeric field. Available summary values are [Sum], [Avg], [Min] and [Max]. These summary values will be shown at the end of the grouping levels with [Show Summary] enabled.

In this tab, you can also choose to show [Detail and Summary] or [Summary only] for your report. If [Detail and Summary] is selected, records belonged to each grouping level will be displayed under the grouping level title, then followed by the summary. [Detail and Summary] is the default.

Finally, you can choose to [Show grand summary] for all records at the end of the report. This options is enabled by default.

 

Press [OK] to finish setup. When a report is created, the field settings will be copied from the source table. But from then on, the Report has its own field settings and is much like other table in ASP.NET Maker.

To edit a Report, right click the Report in the database pane and select [Edit Report]. Alternatively, you can select the Report first, then click [Edit] in the main menu and then select [Edit Report]. Note that the source table of a report cannot be changed.

 

Important
  1. After a report is created, a report works independently from the source table it based on. Changing the structure of the source table does not change the report. If you delete a field in the source table that is used by a report, the report will fail. Similarly, if the report is based on a Custom View and you change the SELECT statement of the Custom View, the report may fail if a field in the report is missing. However, in the latter case, when a Custom View is edited, ASP.NET Maker will check the validity of the SQL. If the SQL fails, both the Custom View and reports that based on the Custom View will be displayed with a cross in the icon, like and . Also, a Report has its own field settings, changing field settings in the source table does not change the field settings in related Reports.
  2. Report does not support exporting to HTML, CSV, XML or PDF. You should export from the source table.
  3. Report does not include BLOB fields or fields that use file upload.
  4. Report is not updatable or searchable, but it supports User ID and User Level. (See Security)

 

 

Also See:


Security

 

 ©2004-2017 e.World Technology Ltd. All rights reserved.