Cannot see more than 5 reports - CR 8.5 ! 2

[zwieback89]

Hi,

I developed all the reports in version 8.0 and then upgraded the reports to version 8.5,

I have a page with links and when I click on a link, I see the report in a new browser window. All this worked fine in CR 8.0 ( I was able to see all the 25 reports)

Now with CR 8.5, after seeing the first five reports, even though I close all the reports before I see another report, I get an error saying that "The Page server cannot process the reports because all the 5 licenses have been used up. Pleae wait till the reports viewed are closed"

I close all the reports and only then view the next report. What is the suggestion for this ?

I view my reports in the following manner:

-----------------------------------------------------

<%
' This line creates a string variable called reportname that we will use to pass
' the Crystal Report filename (.rpt file) to the OpenReport method contained in
' the AlwaysRequiredSteps.asp.

reportname = &quot;web_cardiac_function.rpt&quot;

' ALWAYS REQUIRED STEPS
' Include the file AlwaysRequiredSteps.asp which contains the code for steps:
' - create the application object
' - create the report object
' - open the report
%>
<!-- #include file=&quot;AlwaysRequiredSteps.asp&quot; -->
<%
'Request for variables.
stPatientID = Request.Form(&quot;PatientID&quot
stStartDate = Request.Form(&quot;DateFrom&quot
stEndDate = Request.Form(&quot;DateTo&quot
%>
<!--#include file=&quot;../Database/DBConnection.asp&quot; -->
<%
set crtable = session(&quot;oRpt&quot.Database.Tables.Item(1)
'crtable.SetLogonInfo &quot;Pubs Sample Database&quot;, &quot;pubs&quot;, cstr(userid), cstr(password)
crtable.SetLogonInfo cstr(stODBC), cstr(stDatabase), cstr(userid), cstr(password)

'The following section shows setting the Title ID.
Session(&quot;oRpt&quot.ParameterFields.GetItemByName(&quot;PatientID&quot.AddCurrentValue(Cdbl(stPatientID))
'Response.Write stPatientID

'The following section shows setting the start Date and the End Date.
'GetItemByName gets the name of the parameter set in the CR.
'Make sure that the spelling of the parameter is same as that in the CR.
Session(&quot;oRpt&quot.ParameterFields.GetItemByName(&quot;StartDate&quot.AddCurrentValue(CStr(stStartDate))
Session(&quot;oRpt&quot.ParameterFields.GetItemByName(&quot;EndDate&quot.AddCurrentValue(CStr(stEndDate))

' MORE ALWAYS REQUIRED STEPS
' Include the file MoreRequiredSteps.asp which contains the code for the steps:
' - retreive the records
' - create the page engine
' - create the smart viewer and point it to rptserver.asp
%>
<!-- #include file=&quot;MoreRequiredSteps.asp&quot; -->
<%
' INSTANTIATE THE REPORT VIEWER
%>
<!-- #include file=&quot;SmartViewerActiveX.asp&quot; -->

Hope to hear more on this issue.

Thanks,
Padmaja.

 

[MalcolmW]

Your SmartViewerActiveX.asp should contain the following code to release the license.
This code sample, along with the cleanup.asp file that is referenced in it, is available from

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/aspxmps85.exe

</SCRIPT>

<script language=&quot;javascript&quot;>
’The following function is called when closing the browser window, and will
’release the license used by this session.
function CallDestroy()
{
window.open(&quot;Cleanup.asp&quot;,&quot;Cleanup&quot;,&quot;status=no,toolbar=no,location=no,menu=no,scrollbars=no,width=1,height=1&quot;
self.focus()
}
</script>
Malcolm Wynden
Authorized Crystal Engineer

http://www.wynden.net

malcolm@wynden.net

 

[zwieback89]

Hi Malcolm,

In all the folders where there are reports, I have the following files:

1. AlwaysRequiredSteps.asp
2. MoreRequiredSteps.asp
3. SmartViewerActiveX.asp
4. rptServer.asp

But I do not have the file cleanup.asp

Do I need to include this file as well in the folders that hold the reports ?

Hope to hear soon from you,
Thanks,
Padmaja.