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