Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

newbie... Server has not yet been opened... SQL

Status
Not open for further replies.
yakata

yakata

Programmer
Dec 13, 2000
30
0
0
FR
Hi there !)
Using CR8.5 in VB 6.0 connecting to a SQL SERVER 2000...
Just a little report taking data from a view. I use the CR8.5 standalone designer to design : execute without any problem.
In VB, I insert a CR component using 'existing report'... works... from time to time...
I try to pass parameter like this :
Set CrxReport = crxApplication.OpenReport(App.Path & "\dossier.Rpt")
CrxReport.ParameterFields.GetItemByName("Annee").AddCurrentValue "2003"
CRViewer1.ReportSource = CrxReport
CRViewer1.ViewReport

and at this last line, always get a 'server has not been opened yet' message...

AAAAAAAArrrrrrrrrggggggggghhhhhhhhhh... Tried almost everything, what do i missed ?

TIA for a reply and have a nice day !)

Luc
 
Status
Not open for further replies.

Similar threads

BTPJayW
  • Locked
  • Question
Verify Database Not Working Against Stored Procedure
Replies
1
Views
163
hilfy
hilfy
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
276
LyleU
LyleU
Gary Hnat
  • Locked
  • Question
Crystal SQL Code linking to partial database field entries
Replies
2
Views
156
Gary Hnat
Gary Hnat
PeaEssEl
  • Locked
  • Question
ASP.Net Crystal Reports connection to SQL Server through published website
Replies
2
Views
60
PeaEssEl
PeaEssEl
dovl
  • Locked
  • Question
presenting all records that meet a condition plus the first record only that does not meet the cond
Replies
1
Views
160
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top