Crystal Reports On The Web 
Author Message
 Crystal Reports On The Web

Hi All,

Not a stricktly VB question (but can't find an exact newsgroup) and one that
has been asked many times I know......  But....

I use the Active X viewer very sucessfully in an Access ADP - no problem.
However, I am currently undertaking a project to move the database in
question to a web interface using Coldfusion MX.

All I would like to be able to do is call a report into the viewer and pass
paremeters where required etc.  I was hoping to do this without getting
involved in ASP, as the system is CF based.

I have the code below so far.  The code works as much in that is creates an
instance of the active x control, but with no report in it.  I am unsure as
to how to call a specific report and set the parameters for that matter.  I
would be hugely grateful if someone could assist.

Many many thanks.


<TITLE>Crystal Reports ActiveX Viewer</TITLE>
<BODY BGCOLOR=C6C6C6 leftmargin=0 topmargin=0 rightmargin=0 bottommargin=0>

 WIDTH=100% HEIGHT=100%
<PARAM NAME="EnableRefreshButton" VALUE=1>
<PARAM NAME="EnableGroupTree" VALUE=1>
<PARAM NAME="DisplayGroupTree" VALUE=1>
<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
CRViewer.ReportName =
 Set webBroker = CreateObject("WebReportBroker9.WebReportBroker")
 If ScriptEngineMajorVersion < 2 Then
  window.alert "IE 3.02 users need to get the latest version of VBScript or
install IE 4.01 SP1 or newer. Users of Windows 95 additionally need DCOM95.
These files are available at Microsoft's web site."
  Dim webSource
  Set webSource = CreateObject("WebReportSource9.WebReportSource")
  webSource.ReportSource =
  webSource.URL =
        webSource0.PromptOnRefresh = True
  CRViewer.ReportSource = webSource
 End If
End Sub


Mon, 07 Nov 2005 18:52:21 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Will Crystal Reports meet our web reporting needs?...

2. Crystal Report 8 for Web Reporting

3. Will Crystal Reports meet our web reporting needs?

4. Will Crystal Reports meet our web reporting needs?...

5. Running Crystal Reports in a Web Browser

6. how to create Crystal Reports on the web?

7. Crystal Report, AS400 and Web

8. Crystal Reports on the Web

9. Crystal Reports on IIS Web Server HELP

10. Crystal Reports 7.5 and Web

11. Distributing Crystal reports on the Web

12. Crystal reports on the web


Powered by phpBB® Forum Software