Is there any limit for number of parameters of a report?

[mz74]

Hi,

I am facing a problem here while calling a report on the web, the report is executed successfully and displays correct result but after its execution the user session expires. This is rather a very strange phenominon, atlease for me. When I examined the situation, rather experimented, I came to know that it is happening because of excessive number of parameters. I am passing 14 parameters to this report, but when I removed any one parameter from the report and also from calling page, it began working fine. If anyone has any idea what is going on, le me know.

The server configuration is:
Win 2000 Server, IIS 5, Crystal Reports 8

I am calling the reports from a JSP running on TOMCAT 3.3
If you can suggest/help of any other way to use the reports on web, it will be highly appreciated.

Thanks
Zaki

 

[r1ch]

How are you passing the parameters to the report? If you are using cookies then that may be the cause of the problem - there is a limit of 20 cookies (or 4Kb) per domain, so it may be that the session ID (which is also kept in the cookie) may be being pushed out by the parameters. If this is the case then try using a form to post the parameters or move some to the URL instead.

 

[mz74]

Here is the function I am using to call my reports. Is there anything wrong?

*******************************************
<OBJECT ID=&quot;CRViewer&quot;
CLASSID=&quot;CLSID:C4847596-972C-11D0-9567-00A0C9273C2A&quot;
WIDTH=100% HEIGHT=95%
CODEBASE=&quot;

http://localhost/reports/viewer/activeXViewer/activexviewer.cab#Version=8,0,0,371&quot;>

<PARAM NAME=&quot;EnableDrillDown&quot; VALUE=0>
<PARAM NAME=&quot;EnableExportButton&quot; VALUE=1>
<PARAM NAME=&quot;DisplayGroupTree&quot; VALUE=0>
<PARAM NAME=&quot;EnableGroupTree&quot; VALUE=0>
<PARAM NAME=&quot;EnableAnimationControl&quot; VALUE=0>
<PARAM NAME=&quot;EnablePrintButton&quot; VALUE=1>
<PARAM NAME=&quot;EnableRefreshButton&quot; VALUE=1>
<PARAM NAME=&quot;EnableSearchControl&quot; VALUE=1>
<PARAM NAME=&quot;EnableZoomControl&quot; VALUE=0>
<PARAM NAME=&quot;EnableSearchExpertButton&quot; VALUE=0>
<PARAM NAME=&quot;EnableSelectExpertButton&quot; VALUE=0>
</OBJECT>


<SCRIPT LANGUAGE=&quot;VBScript&quot;>
<!--

Sub window_onLoad()
Page_Initialize()
End Sub

Sub Page_Initialize
On Error Resume Next
Dim webBroker
Set webBroker = CreateObject(&quot;WebReportBroker.WebReportBroker&quot
if err.number <> 0 then
window.alert &quot;The Seagate Software ActiveX Viewer is unable to create it's resource objects.&quot;
CRViewer.ReportName = &quot;

http://oraliz/reports/SelectedAccount.rpt&quot;

else
Dim webSource0
Set webSource0 = CreateObject(&quot;WebReportSource.WebReportSource&quot
webSource0.ReportSource = webBroker
webSource0.URL = &quot;

http://localhost/reports/Report1.rpt?user0=usr&password0=pwd&quot;

webSource0.AddParameter &quot;PROMPT0&quot;, &quot;All Regions&quot;
webSource0.AddParameter &quot;PROMPT1&quot;, &quot;-1&quot;
webSource0.AddParameter &quot;PROMPT2&quot;, &quot;-1&quot;
webSource0.AddParameter &quot;PROMPT3&quot;, &quot;-1&quot;
webSource0.AddParameter &quot;PROMPT4&quot;, &quot;'07/01/2003'&quot;
webSource0.AddParameter &quot;PROMPT5&quot;, &quot;'07/01/2003'&quot;
webSource0.AddParameter &quot;PROMPT6&quot;, &quot;&quot;
webSource0.AddParameter &quot;PROMPT7&quot;, &quot; OIPBMOFFICE = 1&quot;
webSource0.AddParameter &quot;PROMPT8&quot;, &quot;'01/12/2002'&quot;
webSource0.AddParameter &quot;PROMPT9&quot;, &quot;'06/01/2003'&quot;
webSource0.AddParameter &quot;PROMPT10&quot;, &quot;2002&quot;
webSource0.AddParameter &quot;PROMPT11&quot;, &quot;&quot;
webSource0.AddParameter &quot;PROMPT12&quot;, &quot;&quot;
webSource0.AddParameter &quot;PROMPT13&quot;, &quot;&quot;
webSource0.PromptOnRefresh = False

CRViewer.ReportSource = webSource0
end if
CRViewer.ViewReport
End Sub

-->
</SCRIPT>

*******************************************

 

[r1ch]

I suspect that CR is writing the parameters passed to AddParameter out as cookies - the knowledge base article at

http://support.crystaldecisions.com/library/kbase/articles/c2009665.asp

describes a similar problem. It says that Crystal writes out 5 cookies of it's own and your JSP solution will be using one for it's JSP session ID which leaves 14 available for parameters...

To find out if this is the case, try viewing the cookies before you create the WebReportSource and after you call ViewReport in your VBScript. If that does prove to be the problem, you may be able to resolve it by simply re-assigning the original cookies after viewing the report.