ASP Call Crystal Report with Store Procedure(3)
'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>
<%
' 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>
