Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- dBsee 4.6 - The Library - Norton Guide http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]

   On the virtual record it is possible to define groupings that identify
   logical groups of data that the system manages.

   A group is identified by an expression that must assume the same value for
   all the records of the group ("group break"). For example, the expression
   Cli->City divides the clients into groups formed of people that live
   in the same city.

   When a report system of type Listing is created, it is possible to
   define up to 9 different groupings. In each case, for all the available
   report systems, it is possible to add and delete groupings by using the
   Objects environment.

   It is possible to indicate, for each grouping, the expression on which the
   break will be made. During the reporting, a Header and Footer is
   associated to each group.

Example:

   For instance, a report of Clients of a company, divided into the State or
   Nation that a client comes from, and then subdivided into the City, can be
   created. The grouping so obtained, therefore, divides the clients in large
   groups (Italy, USA, etc.), each of those subdivided into smaller groups
   (Milan and Rome for Italy, LA and NY for the US, etc.).

   In the Header and Footer of each group, it is possible to insert
   information that will be printed respectively before and after the list of
   records belonging to that group. For example, before each group the city
   that it refers to is printed, and after each group, the total number of
   clients in that group.

   To define a report as the one described above, in design define the report
   and insert the following information:

   The following list of controls are inserted on the report form (see
   figure):

   (1) Corresponds to symbol Cli->StaCli

   (2) Corresponds to symbol Cli->TownCli

   (3) Corresponds to symbol Cli->NameCli

   (4) Corresponds to symbol Cli->AddCli

   (5) Represents the computed variable of type counter used for
       calculating the total number of clients residing within the same city.
       During its definition, it is necessary to define that it belongs to
       file Cli, and that the group to which it belongs, is the one
       identified by the expression Cli->TownCli (Level 2).

   (6) Represents the computed variable of type counter used for
       calculating the total number of clients residing within the same
       state. During its definition, it is necessary to define that it
       belongs to file Cli, and that the group to which it belongs, is
       the one identified by the expression Cli->StaCli (Level 1).

   (7) Represents the computed variable of type counter used for
       calculating the total number of clients printed on the report. During
       its definition, it is necessary to define that it belongs to file
       Cli, and that the group to which it belongs, is group 0.

   The report being defined must be ordered by the client's state and city.
   The index to associate to the report is the one organised by
   StaCli+TownCli.

   The report printed will have a sample output like in the following:

     
     Page nr.             1
     -----------------------------------------------------
     Clients listing
     
     Resident in the state of:  France
               in the city of:  Lyon
     
                       Larousse Pierre    Rue Voltaire, 6
                       Piani Joseph       Avenue Jardin, 9
     
                           Total resident  2
     
               in the city of:  Paris
     
                       Matrand Francois   P.ce De Gaulle
     
                           Total resident  1
     
              Total resident in the state  3
     
     Resident in the state of:  Italy
     
               in the city of:  Milan
     
                       Carli Vincenzo     Via Spiga 4
                       Rossi Vittorio     Piazza Cavour 18
                       Bianchi Carlo      Via Tartini 15
                       Perazzi Guido      Piazza Fontana 7
     
                           Total resident  4
     
               in the city of:  Turin
     
                       De Mauri Giuseppe  Piazza Garibaldi
                       Antinori Guido     Via Catania, 15
                       Bianchi Luigi      Via De Amicis, 11
     
                           Total resident  3
     
              Total resident in the state  7
     
     Page nr.             2
     -----------------------------------------------------
     
     Resident in the state of:  Netherlands
     
               in the city of:  Amsterdam
     
                       Fietsemaker Joop   Victor Hugo Str.
                       Jonk Wim           Raadhuisplein 2
                       Van Hanegem Henk   2de Dreef 99bis
     
                           Total resident  3
     
               in the city of:  Apeldoorn
     
                       Hals Frans         Hoofdstraat 32
                       Wittebrood Bart    W. Druckerstr. 162
     
                           Total resident  2
     
              Total resident in the state  5
     
                            Total Clients  15
     

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson