A Simple ASP Example
Triple Level Control Break
|
A Simple ASP Example Triple Level Control Break |
Begin execution...
Opening badge rs with SQLstring= NOTE: Primary sort is location, secondary sort is lastname, third level sort is firstname, fourth level sort is badge id Recordset opened OK Records read=25 Control total check OK -- Number of records read (25) = Sum of third level subtotals (25) Terminating Normally -- 11/23/2009 5:54:30 AM
Click here for the program listing (bcb3.asp)
--->SELECT * FROM badge order by bloc ASC, blastname ASC, bfirstname ASC, bid ASC<------ Badge id Location Last Name First Name A Freen Fred 218 A Freen Fred First Name Count for Fred = 1 Last Name Count for Freen = 1 Frost Jack 125 A Frost Jack First Name Count for Jack = 1 Joan 127 A Frost Joan 197 A Frost Joan First Name Count for Joan = 2 Joe 126 A Frost Joe 128 A Frost Joe First Name Count for Joe = 2 Last Name Count for Frost = 5 mcMahon Bill 311 A mcMahon Bill First Name Count for Bill = 1 Last Name Count for mcMahon = 1 Toast Billie 216 A Toast Billie First Name Count for Billie = 1 Burnt 217 A Toast Burnt First Name Count for Burnt = 1 Mille 109 A Toast Mille 119 A Toast Mille 179 A Toast Mille First Name Count for Mille = 3 Last Name Count for Toast = 5 Location Count for A = 12 B Toast Joe 406 B Toast Joe First Name Count for Joe = 1 Last Name Count for Toast = 1 Usmooch Joe 512 B Usmooch Joe First Name Count for Joe = 1 Ron 526 B Usmooch Ron 527 B Usmooch Ron 528 B Usmooch Ron First Name Count for Ron = 3 Last Name Count for Usmooch = 4 Will Bill 826 B Will Bill First Name Count for Bill = 1 Last Name Count for Will = 1 Location Count for B = 6 C Frost Jamie 927 C Frost Jamie First Name Count for Jamie = 1 Jim 331 C Frost Jim 332 C Frost Jim 333 C Frost Jim 334 C Frost Jim First Name Count for Jim = 4 Julain 133 C Frost Julain First Name Count for Julain = 1 Julie 416 C Frost Julie First Name Count for Julie = 1 Last Name Count for Frost = 7 Location Count for C = 7 GRAND TOTAL = 25
Control total check OK -- Number of records read (25) = Sum of second level subtotals (25)
Control total check OK -- Number of records read (25) = Sum of first level subtotals (25)