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