CRViewer ActiveX via ASP will not prompt for parameter fields

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/,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()

Who is Participating?
ee_ai_constructConnect With a Mentor Commented:
Question answered by asker or dialog valuable.
Closed, 500 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
Look at these examples.  There is one for Parameter passing

JayCroweAuthor Commented:
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.

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Do the parameters have valid default values?

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

JayCroweAuthor Commented:
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.

JayCroweAuthor Commented:
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.
JayCroweAuthor Commented:
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.

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.

All Courses

From novice to tech pro — start learning today.