Solved

CRViewer ActiveX via ASP will not prompt for parameter fields

Posted on 2004-10-05
9
2,553 Views
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

to

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.

<%@ LANGUAGE="VBSCRIPT" %>

<%
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)                                              
Wend                                                                  
                                                                     
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
  Session.Abandon
  Response.End
End If

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

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


<HTML>
<HEAD>
<TITLE>Crystal Reports ActiveX Viewer</TITLE>
</HEAD>
<BODY BGCOLOR=C6C6C6 ONUNLOAD="CallDestroy();" leftmargin=0 topmargin=0 rightmargin=0 bottommargin=0>
<OBJECT ID="CRViewer"
      CLASSID="CLSID:A1B8A30B-8AAA-4a3e-8869-1DA509E8A011"
      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>
</OBJECT>

<SCRIPT LANGUAGE="VBScript">
<!--
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."
      else
            Dim webSource
            Set webSource = CreateObject("CrystalReports10.WebReportSource.1")
            webSource.ReportSource = webBroker
            webSource.URL = "RDCrptserver10.asp"
            webSource.PromptOnRefresh = True
            CRViewer.ReportSource = webSource
      end if
      CRViewer.ViewReport
End Sub
-->
</SCRIPT>

<script language="javascript">
function CallDestroy()
{
      window.open("Cleanup.asp");
}
</script>

</BODY>
</HTML>
0
Comment
Question by:JayCrowe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
9 Comments
 
LVL 101

Expert Comment

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

http://support.businessobjects.com/communityCS/FilesAndUpdates/aspxmps10.exe.asp

mlmcc
0
 

Author Comment

by:JayCrowe
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.

Thanks.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 12233244
Do the parameters have valid default values?

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

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:JayCrowe
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.

*ugh*
0
 

Author Comment

by:JayCrowe
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.

http://support.businessobjects.com/library/kbase/articles/c2015774.asp


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.
0
 

Author Comment

by:JayCrowe
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.

0
 

Accepted Solution

by:
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
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

707 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