page break

pab006 · December 16th, 2003, 08:36 AM

Hi,
Ive created a table that groups together records into a particular order. For printing purposes is it possible to force the system to print each "group" on a seperate sheet of paper, even though it will appear as one list on the screen. Is it is possible can some one tell me how?

many thanks

Jonax · December 16th, 2003, 08:42 AM

Yup, have a look here:
http://p2p.wrox.com/topic.asp?TOPIC_ID=7160

pab006 · December 16th, 2003, 10:36 AM

Ive tried this, it creates the break after each record. The record are displayed in this format

number name type
1 fred electrical
2 bob electrical
3 ted mechanical
4 geaorge mecahnical
5 ste mechanical

each time the type changes i need this prinitng on a seprate page. Is this possible, or do i have to group the records in a different way on the screen/ within asp

Jonax · December 16th, 2003, 11:29 AM

It certainly is possible - show me your code and I'll fix it for you...

planoie · December 16th, 2003, 11:35 AM

Perhaps you are setting the break after each new "number" which would certainly make it break for every record.

Peter
------------------------------------------------------
Work smarter, not harder.

pab006 · December 16th, 2003, 12:17 PM

Here is the code that displays my results

Below is a list of faulty machines for week <%= week_no %>. Carry out <a class="report" href="maintenance_report.asp">another search</a>.

 <table border="1"align="center" cellspacing="0" cellpadding="2" bordercolordark="#CCCCCC" bordercolorlight="#FFFFFF" width="600">
 <tr>
 <td align="center">Date</td>
 <td align="center">Clock No.</td>
 <td align="center">Shift</td>
 <td align="center">Machine</td>
 <td align="center">Fault Type</strong</td>
 <td align="center">Fault Description</strong</td>
 <td align="center" width="100">Comment</td>
 </tr>
 <%
 Do While Not RSlist.EOF
 %>
 <tr>
 <td align="center"><%= Rslist("MaintenanceDate") %></td>
 <td align="center">. <%= Rslist("Surname") %>"><%= Rslist("ClockNo") %></td>
 <td align="center"><%= Rslist("Shift") %></td>
 <td align="center"><%= Rslist("MachineNo") %></td>
 <td align="center"><%= Rslist("FaultType") %></td>
 <td align="center"><%= Rslist("Fault") %></td>
 <td align="left"><%= Rslist("Comments") %></td>
 </tr>
 <%
 RSlist.Movenext
 Loop

 Rslist.close
 %>
 </table>
thanks

pab006 · December 16th, 2003, 12:17 PM

forgot to add, ive taken the page break out of this code, so its back to how it began. any help is greatly appreciated

Jonax · December 16th, 2003, 12:26 PM

Code:

<%
dim sLastType
%>
<p class="centered">Below is a list of faulty machines for week <%= week_no %>.<br />Carry out <a class="report" href="maintenance_report.asp">another search</a>.</p>

    <table border="1"align="center" cellspacing="0" cellpadding="2" bordercolordark="#CCCCCC" bordercolorlight="#FFFFFF" width="600">
      <tr>
        <td align="center"><strong>Date</strong></td>
        <td align="center"><strong>Clock No.</strong></td>
        <td align="center"><strong>Shift</strong></td>
        <td align="center"><strong>Machine</strong></td>
        <td align="center"><strong>Fault Type</strong</td>
        <td align="center"><strong>Fault Description</strong</td>
        <td align="center" width="100"><strong>Comment</strong></td>
      </tr>
    <%
       Do While Not RSlist.EOF
        If sLastType <> "" AND sLastType <> Rslist("FaultType") then
            response.write "<tr style=""page-break-before: always;"">"
            sLastType = Rslist("FaultType")
        Else
            response.write "<tr>"
        End if
    %>
      <tr>
        <td align="center"><%= Rslist("MaintenanceDate") %></td>
        <td align="center"><span class="help" title="<%= Rslist("Initial") %>. <%= Rslist("Surname") %>"><%= Rslist("ClockNo") %></span></td>
        <td align="center"><%= Rslist("Shift") %></td>
        <td align="center"><%= Rslist("MachineNo") %></td>
        <td align="center"><%= Rslist("FaultType") %></td>
        <td align="center"><%= Rslist("Fault") %></td>
        <td align="left"><%= Rslist("Comments") %></td>
      </tr> 
      <%
          RSlist.Movenext
        Loop

        Rslist.close
      %>
    </table>

Jonax · December 16th, 2003, 12:28 PM

BTW: I'm assuming your results are sorted by the Fault Type...

pab006 · December 16th, 2003, 12:37 PM

yes, thats great, thankyou for all your help,