Opening CR8/8.5 Reports in VB6, Using CRViewer Control 
Author Message
 Opening CR8/8.5 Reports in VB6, Using CRViewer Control

I'm working with generating a small VB6 service-program, which among
other tasks should be able to
show a general rpt-file report with subreports in the CRViewer control,
after fetching the data from a
Oracle database (7 and 8).  It is assumed that database login and and
schema-name may be different
from site to site, and different between report-developer and
report-viewer.  The following is generally done::

           Data is assumed fetched through ODBC,
           is using SetLogOnInfo on tables in report and subreports to
set login-info

                Set CRAppl = CreateObject("CrystalRuntime.Application")
                Set CRRapp = CRAppl.OpenReport(CRRappName)

                Rem --- Set the report-database
                For i = 1 To CRRapp.Database.Tables.Count

CRRapp.Database.Tables(i).SetLogOnInfo _
                                        Trim(Connectinfo.DNSName),
Trim(Connectinfo.OraService), _
                                        Trim(Connectinfo.UsrName),
Trim(Connectinfo.UsrPwd)
                Next i

            Is running through the sections to identify subreports, and
doing the same for them.

It seems like the reports are running, but before the CRViewer is
showing any data, the message

            "Server has not yes been opened."

Is shown.  The logon-information is correct so this may not be the
cause.

        1. What is the cause for this message ?
        2. Does anybody know any good sources for information about VB
and CrystalReports, have
            been looking at the CrystalDecision site without finding
much ?

Thanks
Stein



Sun, 12 Oct 2003 18:05:35 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Using Crystal 8.5 and VB6 -- need to get a list of fields available to the report

2. how can I transfer the report from Access2000 to crystal report 8.5 or VB6.0

3. Crystal Reports 8.5 (VB6) to Crystal Reports NET (VB.NET) conversion

4. Solution: LogOnServer with VB6, CRViewer, CR8, ODBC, Oracle

5. Using Crystal Reports 8.5 to Report Fields From Public Contacts Folder on Exchange 5.5 Server

6. VB6 and CR 8.5 Server has not yet been opened

7. Export to PDF only from CRviewer (RDC 8.5 - VB 6.0)

8. Page numbers in CRViewer 8.5

9. Crystal Reports 8.5 and VB6 - Passing parametere

10. running report in Crystal 8.5 via VB6

11. Crystal Reports 8.5, VB6 Problem

12. Crystal reports 8.5 and VB6 SP5

 

 
Powered by phpBB® Forum Software