Database Reports

Sophisticated Web reports require complex HTML coding and extensive testing to insure that the pages function properly.  In order to reduce the time and effort needed to create Web-based reports, Chesapeake Data Systems has develop a methodology that combines electronic specifications (that describe the report layout and selection criteria requirements) with an extensive program library. This approach allows organizations to implement reports on the Web much more quickly than when using traditional development methods.

The Web reports that we develop have all of the features that you need for a sophisticated Web-based application:

1.      Reports are based on “SQL query strings” that define the fields to be retrieved

2.      “Filter” forms are based on the fields contained in the “SQL query strings”. 

The analyst can specify the following each Filter form:

A.     The captions for the fields

B.     The order in which the fields are displayed

C.    The ways in which data is entered (single values, comb boxes, range of values, etc.)

D.    The code that sets the initial values for fields on the Filter form

The lower part of the Filter Form contains data entry fields that allow the user to specify several aspects of a displayed report:

A.     Report Subtitle

B.     Maximum number of records to show

C.    Print the count of the number of records the report

D.    Print the selection criteria on the report

E.     Show Totals Only

3.      Report layouts that specify where and how the data is to be placed a Web page.  The layout, which is done as an HTML page can include:

A.     Text and data formatting (as provided by HTML coding standards)

B.     Control breaks, control headers, control footers, and control totals (sums and counts)

C.    Report headers and footers

D.    Page headers and footers

E.     Field formatting (currency, number, Boolean, etc)