Executing Crystal Reports from VB

[pashu]

Hi friends,

I want to execute crystal reports from vb i'm doing thru logon server but i'm getting the error object required,i've given all the arguments i.e. dllname,dsn name,dbname,useid,passwd of which database name is optional.Can any one has done it before or by any other way kindly let me know.Thanks in advance.

Regards,
Prashant.

 

[tb]

Post the line of code that is generating the error.

I have found that there is so many ways to do it - so it will help if we know what your approach is.

Please also mention what you are referencing.



I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[pashu]

Hi friend,

my code is
Private Sub mnuPayslips_Click()
CR1.LogOnServer "PDSODBC.DLL", "pssl", "", "pssl", "edp1999"
CR1.DiscardSavedData = True
CR1.RetrieveSQLQuery
CR1.Action = 1
End Sub

The report get executed but doesn't refreshes the data i.e. shows the previous data.I've written the sql in sql query designer and pass thru ODBC.I've unchecked the options save data with query and save data with report,still it is not working.My backend is oracle 8i.Waiting for ur reply.

Thanks & Regards,
Pashu.