[求助]在asp中怎样实现分页打印？ - 编程论坛

#2

islet2005-09-16 10:03

网页的打印一般是打印网页里面的内容下一页的内容没在本页显示没法打印要想打印全部可以做一个显示全部的页面供打印使用或者声称excle报表让客户自己编辑打印

#3

windy2yuyu2005-09-16 10:14

呵呵，，，这个我也知道，但老板要求这样我也没办法啊。
还有就是那个分页的问题，我用的是一种原始的方法
PageSize =10
PageCount=(PageCount+PageSize-1)\PageSize
Page = CLng(Request("Page"))
'分页显示
If not Page >1 Then Page = 1
If Page > PageCount Then Page = PageCount
i=page+(page-1)*9
rs.AbsolutePage = Page
For iPage = 1 To PageSize
按这个分出来的很正常，
但是我把pagesize改为其他的比如pagesize=15
然后i=page+(page-1)*14
这就不行了，他非要每页都显示15个记录，如果不足15个他会到前面挑几个在后面补足，
这是杂回事捏？？？

#4

islet2005-09-16 10:19

你把最后一页重新改一下读后15条记录

判断如果是最后一页就读你修改的

#5

windy2yuyu2005-09-16 11:07

楼主，不懂你的意思是什么啊，？

#6

islet2005-09-16 11:12

判断一下是不是最后一页
如果是就不读原来的程序
做一个查询后15条数据的页面来代替它

#7

windy2yuyu2005-09-16 11:35

那不是跟我的问题一样的吗，最后一页一定要15条，不足15条还要补足。。。。
我就是不要他补足啊

#8

islet2005-09-16 11:40

[QUOTE]他非要每页都显示15个记录，如果不足15个他会到前面挑几个在后面补足，[/QUOTE]

那我理解错了我还以为“他”是你老板呢

我看看你的分页怎么做的行不

#9

windy2yuyu2005-09-16 13:44

我是这样分的， PageCount=0 sql="select * from proj_info where projyear like '"& pyear &"' and ifshenhe3 like '"& tongguo &"' and projname like '%%"& pname &"%%' and entername like '"& uname &"' and usercode like '"& ucity &"' and projsort like '"& psort &"' and ifshenhe1 like '"& ifsh1 &"' order by id" set rs=conn.execute(sql) while not rs.eof PageCount=PageCount+1 rs.movenext wend sql="select * from proj_info where projyear like '"& pyear &"' and ifshenhe3 like '"& tongguo &"' and projname like '"& pname &"' and entername like '"& uname &"' and usercode like '"& ucity &"' and projsort like '"& psort &"' and ifshenhe1 like '"& ifsh1 &"' order by id" set rs=server.createobject("adodb.recordset") rs.open sql,conn,3,2 on error resume next

PageSize =15 PageCount=(PageCount+PageSize-1)\PageSize Page = CLng(Request("Page")) '分页显示 If not Page >1 Then Page = 1 If Page > PageCount Then Page = PageCount i=page+(page-1)*14 rs.AbsolutePage = Page For iPage = 1 To PageSize %> <tr height="30"> <td><div align="center"><%=i%></div></td> <td><div align="center"><%=rs("projyear")%></div></td> <td width="220"><%=rs("entername")%></td> <td width="220"><%=rs("projname")%></td> <td><div align="center"><%=rs("projsort")%></div></td> <td><div align="center"><%=rs("shenqsum")%></div></td> <td><div align="center"><%=rs("cpifusum")%></div></td> <td><div align="center"><%=rs("ppifusum")%></div></td> <td><div align="center"><%=rs("city")%></div></td> </tr> <% rs.MoveNext If rs.EOF Then Exit For i=i+1 Next %> </table> <div ALIGN="right"> <table> <form ACTION="<%=Myself%>?ifsh1=<%=ifsh1%>&pyear=<%=pyear%>&pname=<%=pname%>&tongguo=<%=tongguo%>&uname=<%=uname%>&ucity=<%=ucity%>&psort=<%=psort%>%>" METHOD="GET"><tr><td><p></td> </tr> <td> <p ALIGN="right"><%If Page <> 1 Then ' 如果不是位于第一页%> <a href="<%=Myself%>?Page=1&ifsh1=<%=ifsh1%>&pyear=<%=pyear%>&pname=<%=pname%>&tongguo=<%=tongguo%>&uname=<%=uname%>&ucity=<%=ucity%>&psort=<%=psort%>"> 第一页</a> <a HREF="<%=Myself%>?Page=<%=(Page-1)%>&ifsh1=<%=ifsh1%>&pyear=<%=pyear%>&pname=<%=pname%>&tongguo=<%=tongguo%>&uname=<%=uname%>&ucity=<%=ucity%>&psort=<%=psort%>"> 上一页</a> <%End If If Page <> PageCount Then ' 如果不是位于最后一页 %> a HREF="<%=Myself%>?Page=<%=(Page+1)%>&ifsh1=<%=ifsh1%>&pyear=<%=pyear%>&pname=<%=pname%>&tongguo=<%=tongguo%>&uname=<%=uname%>&ucity=<%=ucity%>&psort=<%=psort%>"> 下一页</a> <a HREF="<%=Myself%>?Page=<%=PageCount%>&ifsh1=<%=ifsh1%>&pyear=<%=pyear%>&pname=<%=pname%>&tongguo=<%=tongguo%>&uname=<%=uname%>&ucity=<%=ucity%>&psort=<%=psort%>"> 最后一页</a> <% End If %> </p> </td> </tr> </table>

#10

tang6882005-09-18 16:29

哈哈,这个我的办法最好,其实你只要对IE进行一下设置就可以很方便地解决你的问题
不必这么麻烦的,还写一大堆的东东.
你只需要这么做
在IE中点文件,点打印,在打印的对话框中选选项,进入选项的对话框后把"打印链接的所有文件"前的钩给打上就可以了
注意
这样会把所有的页面都打出了,如果你只想打几页,请在程序中把你要打的东东选出就可以了

#11

tang6882005-09-18 16:32

如果你要让你的用户也知道的话就做一个帮助页面吧

#12

griefforyou2005-09-18 21:45

可以用CSS样式来控制哪些内容是要打印的，哪些是不打印的，也可以在页面中相应位置插入分页符强制分页打印
[CODE]<html><HEAD><TITLE>报表打印</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<STYLE>
.page { page-break-after: always }
@media print {
.notPrint { visibility:hidden; }
}
</STYLE>
</HEAD>
<BODY leftMargin=0 topMargin=0 onload=JavaScript:InitTable()>
<TABLE height=50 width=639 align=center border=0>
<TBODY>
<TR>
<TH align=middle><FONT size=4>会计档案 (凭证) 统计台帐</FONT></TD></TD></TR></TBODY></TABLE>
<TABLE id=TempTable style="FONT-SIZE: 13px" borderColor=#000000 cellSpacing=0 width=639 align=center bgColor=#ffffff border=1>
<TBODY>
<TR id=statTableHead1 align=middle height=40>
<TD width="12%" rowSpan=2>时间</TD>
<TD width="9%" rowSpan=2>年度</TD>
<TD colSpan=2>现金</TD>
<TD colSpan=2>银行</TD>
<TD colSpan=2>转帐</TD>
<TD colSpan=2>合计</TD>
<TD width="15%" rowSpan=2>备注</TD></TR>
<TR id=statTableHead2 align=middle height=40>
<TD width="8%">新收</TD>
<TD width="8%">累计</TD>
<TD width="8%">新收</TD>
<TD width="8%">累计</TD>
<TD width="8%">新收</TD>
<TD width="8%">累计</TD>
<TD width="8%">新收</TD>
<TD width="8%">累计</TD></TR>
<TR id=statTableBody1 align=middle height=40>
<TD>1</TD>
<TD>1997</TD>
<TD>11</TD>
<TD>11</TD>
<TD>22</TD>
<TD>22</TD>
<TD>33</TD>
<TD>33</TD>
<TD>66</TD>
<TD>66</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody2 align=middle height=40>
<TD>2</TD>
<TD>1998</TD>
<TD>21</TD>
<TD>32</TD>
<TD>12</TD>
<TD>34</TD>
<TD>16</TD>
<TD>49</TD>
<TD>47</TD>
<TD>113</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody3 align=middle height=40>
<TD>3</TD>
<TD>1999</TD>
<TD>14</TD>
<TD>46</TD>
<TD>34</TD>
<TD>68</TD>
<TD>32</TD>
<TD>81</TD>
<TD>80</TD>
<TD>193</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody4 align=middle height=40>
<TD>1</TD>
<TD>1997</TD>
<TD>11</TD>
<TD>11</TD>
<TD>22</TD>
<TD>22</TD>
<TD>33</TD>
<TD>33</TD>
<TD>66</TD>
<TD>66</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody5 align=middle height=40>
<TD>2</TD>
<TD>1998</TD>
<TD>21</TD>
<TD>32</TD>
<TD>12</TD>
<TD>34</TD>
<TD>16</TD>
<TD>49</TD>
<TD>47</TD>
<TD>113</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody6 align=middle height=40>
<TD>3</TD>
<TD>1999</TD>
<TD>14</TD>
<TD>46</TD>
<TD>34</TD>
<TD>68</TD>
<TD>32</TD>
<TD>81</TD>
<TD>80</TD>
<TD>193</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody7 align=middle height=40>
<TD>1</TD>
<TD>1997</TD>
<TD>11</TD>
<TD>11</TD>
<TD>22</TD>
<TD>22</TD>
<TD>33</TD>
<TD>33</TD>
<TD>66</TD>
<TD>66</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody8 align=middle height=40>
<TD>2</TD>
<TD>1998</TD>
<TD>21</TD>
<TD>32</TD>
<TD>12</TD>
<TD>34</TD>
<TD>16</TD>
<TD>49</TD>
<TD>47</TD>
<TD>113</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody9 align=middle height=40>
<TD>3</TD>
<TD>1999</TD>
<TD>14</TD>
<TD>46</TD>
<TD>34</TD>
<TD>68</TD>
<TD>32</TD>
<TD>81</TD>
<TD>80</TD>
<TD>193</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody10 align=middle height=40>
<TD>1</TD>
<TD>1997</TD>
<TD>11</TD>
<TD>11</TD>
<TD>22</TD>
<TD>22</TD>
<TD>33</TD>
<TD>33</TD>
<TD>66</TD>
<TD>66</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody11 align=middle height=40>
<TD>2</TD>
<TD>1998</TD>
<TD>21</TD>
<TD>32</TD>
<TD>12</TD>
<TD>34</TD>
<TD>16</TD>
<TD>49</TD>
<TD>47</TD>
<TD>113</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody12 align=middle height=40>
<TD>3</TD>
<TD>1999</TD>
<TD>14</TD>
<TD>46</TD>
<TD>34</TD>
<TD>68</TD>
<TD>32</TD>
<TD>81</TD>
<TD>80</TD>
<TD>193</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody13 align=middle height=40>
<TD>1</TD>
<TD>1997</TD>
<TD>11</TD>
<TD>11</TD>
<TD>22</TD>
<TD>22</TD>
<TD>33</TD>
<TD>33</TD>
<TD>66</TD>
<TD>66</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody14 align=middle height=40>
<TD>2</TD>
<TD>1998</TD>
<TD>21</TD>
<TD>32</TD>
<TD>12</TD>
<TD>34</TD>
<TD>16</TD>
<TD>49</TD>
<TD>47</TD>
<TD>113</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody15 align=middle height=40>
<TD>3</TD>
<TD>1999</TD>
<TD>14</TD>
<TD>46</TD>
<TD>34</TD>
<TD>68</TD>
<TD>32</TD>
<TD>81</TD>
<TD>80</TD>
<TD>193</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody16 align=middle height=40>
<TD>1</TD>
<TD>1997</TD>
<TD>11</TD>
<TD>11</TD>
<TD>22</TD>
<TD>22</TD>
<TD>33</TD>
<TD>33</TD>
<TD>66</TD>
<TD>66</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody17 align=middle height=40>
<TD>2</TD>
<TD>1998</TD>
<TD>21</TD>
<TD>32</TD>
<TD>12</TD>
<TD>34</TD>
<TD>16</TD>
<TD>49</TD>
<TD>47</TD>
<TD>113</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody18 align=middle height=40>
<TD>3</TD>
<TD>1999</TD>
<TD>14</TD>
<TD>46</TD>
<TD>34</TD>
<TD>68</TD>
<TD>32</TD>
<TD>81</TD>
<TD>80</TD>
<TD>193</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody19 align=middle height=40>
<TD>1</TD>
<TD>1997</TD>
<TD>11</TD>
<TD>11</TD>
<TD>22</TD>
<TD>22</TD>
<TD>33</TD>
<TD>33</TD>
<TD>66</TD>
<TD>66</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody20 align=middle height=40>
<TD>2</TD>
<TD>1998</TD>
<TD>21</TD>
<TD>32</TD>
<TD>12</TD>
<TD>34</TD>
<TD>16</TD>
<TD>49</TD>
<TD>47</TD>
<TD>113</TD>
<TD>&nbsp; </TD></TR></TBODY></TABLE>
<TABLE class=page style="FONT-SIZE: 13px" height=30 cellSpacing=0 cellPadding=0 width=639 align=center border=0>
<TBODY>
<TR>
<TD align=middle>第 1 页 </TD></TR></TBODY></TABLE>
<TABLE height=50 width=639 align=center border=0>
<TBODY>
<TR>
<TH align=middle><FONT size=4>会计档案 (凭证) 统计台帐</FONT></TD></TD></TR></TBODY></TABLE>
<TABLE id=TempTable style="FONT-SIZE: 13px" borderColor=#000000 cellSpacing=0 width=639 align=center bgColor=#ffffff border=1>
<TBODY>
<TR id=statTableHead1 align=middle height=40>
<TD width="12%" rowSpan=2>时间</TD>
<TD width="9%" rowSpan=2>年度</TD>
<TD colSpan=2>现金</TD>
<TD colSpan=2>银行</TD>
<TD colSpan=2>转帐</TD>
<TD colSpan=2>合计</TD>
<TD width="15%" rowSpan=2>备注</TD></TR>
<TR id=statTableHead2 align=middle height=40>
<TD width="8%">新收</TD>
<TD width="8%">累计</TD>
<TD width="8%">新收</TD>
<TD width="8%">累计</TD>
<TD width="8%">新收</TD>
<TD width="8%">累计</TD>
<TD width="8%">新收</TD>
<TD width="8%">累计</TD></TR>
<TR id=statTableBody21 align=middle height=40>
<TD>3</TD>
<TD>1999</TD>
<TD>14</TD>
<TD>46</TD>
<TD>34</TD>
<TD>68</TD>
<TD>32</TD>
<TD>81</TD>
<TD>80</TD>
<TD>193</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody22 align=middle height=40>
<TD>1</TD>
<TD>1997</TD>
<TD>11</TD>
<TD>11</TD>
<TD>22</TD>
<TD>22</TD>
<TD>33</TD>
<TD>33</TD>
<TD>66</TD>
<TD>66</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody23 align=middle height=40>
<TD>2</TD>
<TD>1998</TD>
<TD>21</TD>
<TD>32</TD>
<TD>12</TD>
<TD>34</TD>
<TD>16</TD>
<TD>49</TD>
<TD>47</TD>
<TD>113</TD>
<TD>&nbsp; </TD></TR>
<TR id=statTableBody24 align=middle height=40>
<TD>3</TD>
<TD>1999</TD>
<TD>14</TD>
<TD>46</TD>
<TD>34</TD>
<TD>68</TD>
<TD>32</TD>
<TD>81</TD>
<TD>80</TD>
<TD>193</TD>
<TD>&nbsp; </TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 13px" height=30 cellSpacing=0 cellPadding=0 width=639 align=center border=0>
<TBODY>
<TR>
<TD align=middle>第 2 页 </TD></TR></TBODY></TABLE>
<DIV class=notPrint id=TempTableDiv>&nbsp;</DIV></BODY></html>[/CODE]

#13

windy2yuyu2005-09-19 08:18

嘿嘿，，，，谢谢两位，俺先试试啊

#14

windy2yuyu2005-09-19 08:43

我的数据都是从数据库里面查出来的，要进入页面的时候才能生成，而不是早就在那的啊，

#15

windy2yuyu2005-09-19 09:08

以下是引用tang688在2005-9-18 16:29:36的发言： 哈哈,这个我的办法最好,其实你只要对IE进行一下设置就可以很方便地解决你的问题不必这么麻烦的,还写一大堆的东东. 你只需要这么做在IE中点文件,点打印,在打印的对话框中选选项,进入选项的对话框后把"打印链接的所有文件"前的钩给打上就可以了注意这样会把所有的页面都打出了,如果你只想打几页,请在程序中把你要打的东东选出就可以了

呵呵，你这个方法对付静态的页面有用，但我这个是动态的，你没看到就是不存在啊，这怎么搞呢

#16

greatyollow2007-10-06 12:35

楼上讲了这么多,我一句也没看明白

我也学整了一个分页程序,显示正确,就是不知道怎么才能让它一页一页打出来.

朋友们,提点思路.