When I press submit it open viewschool.asp this page looks like this :
<%@ LANGUAGE="VBSCRIPT" %>
<TITLE>View Schools</TITLE>
<%
' This is the name of the report being used in this example.
' To use a different report, change it here.
reportname = "ViewSchool.rpt"
%>
<%
'=================================================================
'
' - 1 -
' CREATE THE APPLICATION OBJECT
'
If Not IsObject ( session ("oApp"

) Then
Set session ("oApp"

= Server.CreateObject("Crystal.CRPE.Application"

End If
' - 2 -
' CREATE THE REPORT OBJECT.
'
Path = Request.ServerVariables("PATH_TRANSLATED"
While (Right(Path, 1) <> "\" And Len(Path) <> 0)
iLen = Len(Path) - 1
Path = Left(Path, iLen)
Wend
' - 3 -
' OPEN THE REPORT
If isObject(session("oRpt"

) then
set session("oRpt"

= nothing
End If
Set session("oRpt"

= session("oApp"

.OpenReport(Path & ReportName, 1)
' Turn off sepecific report error messages
Set oRptOptions = Session("oRpt"

.Options
oRptOptions.MorePrintEngineErrorMessages = 0
%>
<%
'==================================================================
' Retrieve the Records
'==================================================================
%>
<%
On Error Resume Next
session("oRpt"

.ReadRecords
If Err.Number <> 0 Then
Response.Write "An Error has occured on the server in attempting to access the following data source - " & session ("pubs_ConnectionString"

Else
'==================================================================
' Create the Page Engine
'==================================================================
If isObject(session("oPageEngine"

) then
set session("oPageEngine"

= nothing
End If
Set session("oPageEngine"

= session("oRpt"

.PageEngine
End If
%>
<!-- #include file="SmartViewerActiveX.asp" --> %>
This then opens the viewschools crystal report.
my problem is how do I pass the school through to the viewschools report ?
cheers.