Hi anybody can help I am getting a

[ven]

Hi anybody can help
I am getting an error while reporting a crystal report(v7.0)from vbcode.
the error is
"server has not yet been opened"
thanks in advance.
ven(programmer)

 

[CrystalVisualBOracle]

I just had the same problem. Check out the thread I started for help. It's titled "Creating Crystal Reports with VB6 using the RDC component (Oracle 8)".
thread149-45809

I got some great help.

Basically you have to use LogOnServer or SetLogOnInfo to log onto the server in VB.

 

[ven]

hi i am giving my code below.
(I am getting the error "server has not yet been opened&quot
my application backend is sqlserver7.0
Set objData = CreateObject("orderentry.clsCMShipments", g_intServerName)
blnSuccess = objData.getCalenderShipments(rstData)

Set rptMainReport = appmain.OpenReport(AddDirSep(App.Path) & "rptCalender.rpt&quot
rptMainReport.Database.SetDataSource rstData
Set rptSubReport = rptMainReport.OpenSubreport("subreport1&quot
rptSubReport.Database.SetDataSource rstData
Screen.MousePointer = vbArrow
CRViewer1.ReportSource = rptMainReport
CRViewer1.DisplayGroupTree = False
CRViewer1.EnableExportButton = False
CRViewer1.ViewReport
i am getting the recordset from the middletier and populating in the report using(active data method).

thanks in advance
ven(programmer)

 

[kenhamady]

When you created the Calendar.rpt did you use the Active Data Driver? You can't pass active data to a report that was created against tables. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[ven]

Hi kenhamady,
first i used the tables then for subreports i used active data.As u said i done active data for the main and subsequent subreports .now it works.
thanks for ur help.
ven