(3)ASPCallCrystalReportwithStoreProcedure

王朝厨房·作者佚名  2007-01-04
窄屏简体版  字體: |||超大  

’framepage.asp

<%

’ 05/02/98

’ Added the following features:

’ Page Expiry Time

’ - The page will expire when downloaded by browser so that user is insured that all data

’ will be current.

Response.Expires = 0

%>

<html>

<title></title>

<%

qs = request.querystring

if qs <> "" then

qs = "&" & qs

end if

%>

<frameset rows ="59,*">

<frame marginheight=0 marginwidth=0 noresize scrolling=no name="CrystalViewerToolbar" src="toolbar.asp?<% response.write request.querystring %>">

<frame name="CrystalViewerPreview" src="rptserver.asp?cmd=get_pg&viewer=html_frame&vfmt=html_frame&page=<%response.write session("CurrentPageNumber") %><% response.write qs %>">

</frameset>

</html>

’htmstart.asp

<%

’ 05/02/98

’ Added the following features:

’ Tab Query String Parameter

’ - This is the selected tab’s tabArray index value.

’ Page Expiry Time

’ - The page will expire when downloaded by browser so that user is insured that all data

’ will be current.

Response.Expires = 0

On Error Resume Next

qs = request.querystring

if qs <> "" then

qs = "&" & qs

else

’ Need to make this call for backward compatibility. Users may be referencing htmstart.asp in their web pages.

Call InitializeFrameArray

end if

dim tmpArray

dim index

dim brch

dim val

if request.querystring("TAB") <> "" then

tmpArray = session("tabArray")

index = Cint(request.querystring("TAB"))

if tmpArray(index + 1) <> "" then

brch = tmpArray(index + 1)

qs = "&" & "BRCH=" & brch

end if

session("CurrentPageNumber") = tmpArray(index + 2)

session("lastknownpage") = tmpArray(index + 3)

session("LastPageNumber") = tmpArray(index + 4)

’ clear out all of the other arrays

if index = 0 then

Call InitializeFrameArray

else

redim preserve tmpArray(index - 1)

session("tabArray") = tmpArray

end if

else

session("CurrentPageNumber") = "1"

session("lastknownpage") = "0"

session("LastPageNumber") = ""

end if

’ This function initializes the tabArray.

SUB InitializeFrameArray()

’initialize the html_frame array

set session("tabArray") = Nothing

session("lastBrch") = ""

dim tmpArray

tmpArray = Array(4)

redim tmpArray(4)

’Initialize the sequence number

tmpArray(0) = "EMPTY"

session("tabArray") = tmpArray

END SUB

%>

<html>

<title></title>

<frameset cols="15%,*">

<frame name="CrystalViewerTree" src="rptserver.asp?cmd=get_ttl&viewer=html%5Fframe&vfmt=html_frame<% response.write qs %>">

<frame name="CrystalViewerPageFrame" src="rptserver.asp?cmd=toolbar_page&viewer=html%5Fframe&vfmt=html_frame&page=<% response.write session("CurrentPageNumber") %><% response.write qs %>">

</frameset>

</html>

’JavaPluginViewer.asp

<html>

<head>

<title>Seagate Java Viewer using Java Plug-in</title>

</head>

<body bgcolor=C6C6C6>

<P align="center">

<object

classid="clsid:8AD9C840-044E-11D1-B3E9-00805F499D93"

width=100%

height=100%

codebase="/viewer/JavaPlugin/Win32/jre1_2_2-win.exe#Version=1,2,2,0">

<param name=type value="application/x-java-applet;version=1.2.2">

<param name=code value="com.seagatesoftware.img.ReportViewer.ReportViewer">

<param name=codebase value="/viewer/javaviewer/">

<param name=archive value="ReportViewer.jar">

<param name=Language value="en">

<param name=ReportName value="rptserver.asp">

<param name=ReportParameter value="">

<param name=HasGroupTree value="true">

<param name=ShowGroupTree value="true">

<param name=HasRefreshButton value="false">

<param name=HasPrintButton value="true">

<param name=HasExportButton value="true">

<param name=HasTextSearchControls value="true">

<param name=CanDrillDown value="true">

<param name=HasZoomControl value="true">

<param name=PromptOnRefresh value="true">

<comment>

<embed

width=100%

height=90%

type="application/x-java-applet;version=1.2.2"

pluginspage="/viewer/JavaPlugin/Win32/jre1_2_2-win.exe"

java_code="com.seagatesoftware.img.ReportViewer.ReportViewer"

java_codebase="/viewer/javaviewer/"

java_archive="ReportViewer.jar"

Language="en"

ReportName="rptserver.asp"

ReportParameter=""

HasGroupTree="true"

ShowGroupTree="true"

HasRefreshButton="false"

HasPrintButton="true"

HasExportButton="true"

HasTextSearchControls="true"

CanDrillDown="true"

HasZoomControl="true"

PromptOnRefresh="true"

></embed>

</comment>

</object>

</p>

</body>

</html>

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航