客户端用ASP+rds+VBA参生报表

y691108226

y691108226

2016-01-29 17:36

客户端用ASP+rds+VBA参生报表,客户端用ASP+rds+VBA参生报表
  test_print_report.asp

<html
<head
<meta content="text/html; charset=BIG5" http-equiv="Content-Type"
<titleclient use rds produce excel report</title
</head
<body bgColor="skyblue" topMargin=0 leftMargin="20" oncontextmenu="return false" rightMargin="0" bottomMargin="0"
<form action="test_print_report.asp" method="post" name="myform"
<div align="center"<center
<table border="5" bgcolor="#ffe4b5" style="HEIGHT: 1px; TOP: 0px" bordercolor="#0000ff"
<tr
<td align="middle" bgcolor="#ffffff" bordercolor="#000080"
<font color="#000080" size="3"
client use rds produce excel report
</font
</td
</tr
</table
</div
<div align="left"
<input type="button" value="Query Data" name="query" language="vbscript" onclick="fun_query()" style="HEIGHT: 32px; WIDTH: 90px"
<input type="button" value="Clear Data" name="Clear" language="vbscript" onclick="fun_clear()" style="HEIGHT: 32px; WIDTH: 90px"
<input type="button" value="Excel Report" name="report" language="vbscript" onclick="fun_excel()" style="HEIGHT: 32px; WIDTH: 90px"
</div
<div id="adddata"</div
</form</center
</body
</html
<script language="vbscript"
dim rds,rs,df
dim strSQL,StrRs,strCn,RowCnt
dim xlApp, xlBook, xlSheet1,xlmodule,XlPageSetup
dim HeadRowCnt,TitleRowCnt,ContentRowCnt,FootRowCnt
dim PageRowCnt,PageNo,TotalPageCnt,ContentRowNowCnt
dim ColumnAllWidth,ColumnAWidth,ColumnBWidth,ColumnCWidth,ColumnDWidth

sub fun_query()
set rds = CreateObject("RDS.DataSpace")
Set df = rds.CreateObject("RDSServer.DataFactory","http://iscs00074")
strCn="DRIVER={SQL Server};SERVER=iscs00074;UID=sa;APP=Microsoft Development Environment;DATABASE=pubs;User Id=sa;PASSWORD=;"
strSQL = "Select * from jobs"
Set rs = df.Query(strCn, strSQL)

if not rs.eof then
StrRs="<table border=1<tr<tdjob_id</td<tdjob_desc</td<tdmax_lvl</td<tdmin_lvl</td</tr<tr<td"+ rs.GetString(,,"</td<td","</td</tr<tr<td"," ") +"</td</tr</table"
adddata.innerHTML=StrRs
StrRs=""
else
msgbox "No data in the table!"
end if
end sub

sub fun_clear()
StrRs=""
adddata.innerHTML=StrRs
end sub

sub fun_excel()
set rds = CreateObject("RDS.DataSpace")
Set df = rds.CreateObject("RDSServer.DataFactory","http://iscs00074")
strCn="DRIVER={SQL Server};SERVER=iscs00074;UID=sa;APP=Microsoft Development Environment;DATABASE=pubs;User Id=sa;PASSWORD=;"
strSQL = "Select count(*) as recordcnt from jobs"
Set rs = df.Query(strCn, strSQL)
TotalPageCnt=rs("recordcnt")
rs.close
set rs=nothing
strSQL = "Select * from jobs"
Set rs = df.Query(strCn, strSQL)
Set xlApp = CreateObject("EXCEL.APPLICATION")
Set xlBook = xlApp.Workbooks.Add
Set xlSheet1 = xlBook.ActiveSheet
Set xlmodule = xlbook.VBProject.VBComponents.Add(1)
xlSheet1.Application.Visible = True
xlSheet1.Application.UserControl = True
i=0
RowCnt=1
PageNo=1
HeadRowCnt=4 'The header number to print in one page!
TitleRowCnt=3 'The title number to print in one page!
ContentRo
展开更多 50%)
分享

猜你喜欢

客户端用ASP+rds+VBA参生报表

ASP
客户端用ASP+rds+VBA参生报表

关于客户端用ASP参生报表

ASP
关于客户端用ASP参生报表

s8lol主宰符文怎么配

英雄联盟 网络游戏
s8lol主宰符文怎么配

关于客户端用ASP参生报表(高级篇)

ASP
关于客户端用ASP参生报表(高级篇)

ASP获取客户端MAC地址

ASP
ASP获取客户端MAC地址

lol偷钱流符文搭配推荐

英雄联盟 网络游戏
lol偷钱流符文搭配推荐

ASP如何获取客户端真实IP

Web开发
ASP如何获取客户端真实IP

用ASP.Net获取客户端网卡的MAC

电脑网络
用ASP.Net获取客户端网卡的MAC

lolAD刺客新符文搭配推荐

英雄联盟
lolAD刺客新符文搭配推荐

RedHatLinux附加引导和内核引导选项

RedHatLinux附加引导和内核引导选项

为你的ASP程序制作一个编译组件(中)

为你的ASP程序制作一个编译组件(中)
下拉加载更多内容 ↓