CRViewer ActiveX via ASP will not prompt for parameter fields

Posted on 2004-10-05
Medium Priority
Last Modified: 2007-12-19
This upgrade to CR10 viewer via ASP has been kicking my butt.  My current dilemma is that I can not get a parameter dialog to pop up no matter what I do.

My report has nothing on it but a text label and a paramter field just as a test.  (not even trying to hook to a DB)

It does not have the 'Save data with report' checked.

I have only CRViewer v10 on the server and client, including reportparameterdialog.dll.  It is registered.

If I change:

session("oRpt").EnableParameterPrompting = False


session("oRpt").EnableParameterPrompting = True

the ASP page hangs during the load.  It seems to hang the web server real good... I'm rebooting it now.

If I leave it set to false, my report will load with the default value I put in my param field. (no prompt).  If I hit refresh, it loads a null value (no prompt).

I downloaded a test ASP & rpt from Crystal support that forces parameter values in during load and that works fine.  When I hit 'refresh' I just get null values back, no prompt.

I ususally end up figuring this stuff out on my own shortly after posting to EE.  I hope that is the case with this issue as well!  :o)

Thanks in advance for any help you can provide.

Here is my ASP code.  There is also an asscociated RDCrptserver10.asp that is default right from Crystal.  I will post it if necessary, but it is rather long.


Response.Expires = -1
Response.CacheControl = "no-cache"

reportname = "Jay.rpt"

If Not IsObject (session("oApp")) Then                              
  Set session("oApp") = Server.CreateObject("CrystalRuntime.Application.10")
End If                                                              

Path = Request.ServerVariables("PATH_TRANSLATED")                    
While (Right(Path, 1) <> "\" And Len(Path) <> 0)                      
iLen = Len(Path) - 1                                                  
Path = Left(Path, iLen)                                              
If IsObject(session("oRpt")) then Set session("oRpt") = nothing

Set session("oRpt") = session("oApp").OpenReport(path & reportname, 1)

If Err.Number <> 0 Then
  Response.Write "Error Occurred creating Report Object: " & Err.Description
  Set Session("oRpt") = nothing
  Set Session("oApp") = nothing
End If

'session("oRpt").MorePrintEngineErrorMessages = False
session("oRpt").EnableParameterPrompting = True

If Err.Number <> 0 Then                                              
  Response.Write "Error Occurred Reading Records: " & Err.Description
  Set Session("oRpt") = nothing
  Set Session("oApp") = nothing
  If IsObject(session("oPageEngine")) Then Set session("oPageEngine") = nothing
  set session("oPageEngine") = session("oRpt").PageEngine
End If

<TITLE>Crystal Reports ActiveX Viewer</TITLE>
<BODY BGCOLOR=C6C6C6 ONUNLOAD="CallDestroy();" leftmargin=0 topmargin=0 rightmargin=0 bottommargin=0>
      WIDTH=100% HEIGHT=95%
      CODEBASE="/crystalreportviewers10/ActiveXControls/ActiveXViewer.cab#Version=10,0,0,280" VIEWASTEXT>
<PARAM NAME="EnableRefreshButton" VALUE=1>
<PARAM NAME="EnableGroupTree" VALUE=1>
<PARAM NAME="DisplayGroupTree" VALUE=0>
<PARAM NAME="EnablePrintButton" VALUE=1>
<PARAM NAME="EnableExportButton" VALUE=1>
<PARAM NAME="EnableDrillDown" VALUE=1>
<PARAM NAME="EnableSearchControl" VALUE=1>
<PARAM NAME="EnableAnimationControl" VALUE=1>
<PARAM NAME="EnableZoomControl" VALUE=1>

Sub Window_Onload
      'On Error Resume Next
      Dim webBroker
      Set webBroker = CreateObject("CrystalReports10.WebReportBroker.1")
      if ScriptEngineMajorVersion < 2 then
            window.alert "IE 3.02 users on NT4 need to get the latest version of VBScript or install IE 4.01 SP1. IE 3.02 users on Win95 need DCOM95 and latest version of VBScript, or install IE 4.01 SP1. These files are available at Microsoft's web site."
            Dim webSource
            Set webSource = CreateObject("CrystalReports10.WebReportSource.1")
            webSource.ReportSource = webBroker
            webSource.URL = "RDCrptserver10.asp"
            webSource.PromptOnRefresh = True
            CRViewer.ReportSource = webSource
      end if
End Sub

<script language="javascript">
function CallDestroy()

Question by:JayCrowe
  • 4
  • 2
LVL 101

Expert Comment

ID: 12230721
Look at these examples.  There is one for Parameter passing



Author Comment

ID: 12231681
Thanks mlmcc.  I already have those samples, that's where the majority of the above code came from.

To clarify my issue, I don't want to send parameters via code, I want the default CRViewer parameter prompt to show up.

I cannot get the prompt to show up.  Most posts I read people complain they can't get rid of the thing.  hah.

Also, I'm not even sure if this is a server or client issue?  It seems that it would be the client, but I'm no expert.

LVL 101

Expert Comment

ID: 12233244
Do the parameters have valid default values?

I am not familiar with ASP code, though nothing looks wrong.

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.


Author Comment

ID: 12236110
I do have a default value for the parameter field, and even that does not show up when I open the report.

I don't suspect the ASP is the culprit, although this is the first time I have worked with ASP.  I more or less am using the Crystal demo ASP code.

It seems to me that there is something missing in relation to the reportparameterprompt.dll but I can't figure it out.


Author Comment

ID: 12237163
And the answer is:

The information in the article refers to:
Crystal Reports 10

The RDC parameter dialog box will not appear in the ASP application since the ASP application does not support the RDC parameter dialog box.


That just stinks.  It does work via VB6.  I don't know anything about ASP.NET, but I think this this can be made to work that way.

Back to the drawing board.

Author Comment

ID: 12451516
I paid $200 (price of one tech support call) for Business Solutions to tell me I could not use the CR10 ActiveX viewer via ASP to run rerports WITH parameter prompts.  Works fine with reports that have no parameter fields.  They said i would need to purchase a RAS server (report application server? I forget now) with the appropriate licenses to do what I wanted.

That was BS, I was able to get things working via ASP.NET with only CR10 Developer edition.  It doesn't use the ActiveX viewer, it renders the reports using an html type viewer.  Everything works, export, print, parameter prompts, etc.  I set it up so I can pass the name of the report I want and the necessary usrname and password, then the page loads and the parameter fileds pop up.  It even has a calendar date picker window that pops up instead of having to type in the goofy CR date format directly.  When you print reports, it actually spawns an Adobe Acrobat window containing the report, then you hit print from there.

I hope this info will help others.


Accepted Solution

ee_ai_construct earned 0 total points
ID: 12485032
Question answered by asker or dialog valuable.
Closed, 500 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question