Click here to Skip to main content
15,889,817 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Time of Day Launched Project Pin
John Kuhn21-Feb-04 17:33
John Kuhn21-Feb-04 17:33 
GeneralWindow Location, Multiple Monitor: Sorry for crosspost Pin
Matt Philmon20-Feb-04 19:48
Matt Philmon20-Feb-04 19:48 
GeneralListbox and XML Pin
Novaoblivion20-Feb-04 14:25
Novaoblivion20-Feb-04 14:25 
Generalrich text output to postscript or... Pin
jjpaquin20-Feb-04 7:52
jjpaquin20-Feb-04 7:52 
GeneralJanus GridEx & Rows Pin
RichardGrimmer20-Feb-04 4:26
RichardGrimmer20-Feb-04 4:26 
GeneralRe: Janus GridEx & Rows Pin
jimpar20-Feb-04 9:12
jimpar20-Feb-04 9:12 
GeneralRe: Janus GridEx & Rows Pin
RichardGrimmer20-Feb-04 12:20
RichardGrimmer20-Feb-04 12:20 
Generalcrystal report Pin
joypreeti20-Feb-04 1:33
joypreeti20-Feb-04 1:33 
hello all,
i m connecting a crystal report 8.5 thru my vb6 application and i m trying to disaply only specific records in the crystal reports.
i m pasing querry in the crystal report thru my VB applcation.
all is going well but getting one error at the statement

cr.viewreport
server has not yet bee opened

Private Sub Form_Load()


Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim crystal As CRAXDRT.Application
Dim report As CRAXDRT.report
CR.DisplayBorder = False
CR.DisplayTabs = False
CR.EnableDrillDown = False
CR.EnableRefreshButton = False
Set conn = New ADODB.Connection
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Raj;Data Source=."
conn.Open
Set rs = New ADODB.Recordset
rs.Open "SELECT* From user_file where user_id='Raj'Order By user_id ASC", conn, adOpenStatic, adLockReadOnly
Set crystal = New CRAXDRT.Application
Set report = crystal.OpenReport(App.Path & "\myrep.rpt")
report.DiscardSavedData
report.Database.SetDataSource rs
CR.ReportSource = report

'here at this statement i m having problem getting erro msg :server has not yet been opened
CR.ViewReport
CR.Zoom 94
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
Set crystal = Nothing
Set report = Nothing
End Sub
sending the code for ur refrence.
please help me if anybd can
thanks

Generaloutpur in Excel using vb6 Pin
Anonymous20-Feb-04 0:52
Anonymous20-Feb-04 0:52 
GeneralRe: outpur in Excel using vb6 Pin
John Kuhn20-Feb-04 12:55
John Kuhn20-Feb-04 12:55 
General.NET and Binary compatibility Pin
cnurse19-Feb-04 22:33
cnurse19-Feb-04 22:33 
GeneralFree UML tools Pin
cnurse19-Feb-04 22:26
cnurse19-Feb-04 22:26 
GeneralRe: Free UML tools Pin
Corinna John22-Feb-04 22:13
Corinna John22-Feb-04 22:13 
GeneralRe: Free UML tools Pin
cnurse22-Feb-04 22:26
cnurse22-Feb-04 22:26 
GeneralRe: Free UML tools Pin
Corinna J.23-Feb-04 6:01
sussCorinna J.23-Feb-04 6:01 
GeneralRe: Free UML tools Pin
LuckyNB12-Sep-09 21:48
professionalLuckyNB12-Sep-09 21:48 
QuestionRuntime Error 430?? Pin
erikkloeze19-Feb-04 21:49
erikkloeze19-Feb-04 21:49 
AnswerRe: Runtime Error 430?? Pin
Nadroj20-Feb-04 1:57
Nadroj20-Feb-04 1:57 
GeneralRe: Runtime Error 430?? Pin
erikkloeze20-Feb-04 3:40
erikkloeze20-Feb-04 3:40 
GeneralRe: Runtime Error 430?? Pin
Nadroj20-Feb-04 4:36
Nadroj20-Feb-04 4:36 
GeneralRe: Runtime Error 430?? Pin
Nadroj20-Feb-04 4:50
Nadroj20-Feb-04 4:50 
GeneralRe: Runtime Error 430?? Pin
erikkloeze20-Feb-04 10:03
erikkloeze20-Feb-04 10:03 
GeneralRe: Runtime Error 430?? Pin
Nadroj20-Feb-04 11:38
Nadroj20-Feb-04 11:38 
GeneralSet Printer Using Printing API Pin
Edbert P19-Feb-04 19:07
Edbert P19-Feb-04 19:07 
GeneralRe: Set Printer Using Printing API Pin
Duncan Edwards Jones20-Feb-04 8:09
professionalDuncan Edwards Jones20-Feb-04 8:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.