Reg: Subreports in VB 6.0

[raj_81]

Dear all,

I'm using Crystal report 8.5 as reporting tool and VB 6.0 and Oracle.

i'm facing a problem as "Error no: 20599 Cannot open SQL Server"

"a.rpt" is the Report file
and it contains subreports as x.rpt and y.rpt

x and y reports displays the address information of employee

My coding is as example:

Cr is Crystal report name.
-----------------------------------------

Dim sql as string

Cr. ReportFileName = App.Path & "\reports\a.rpt"

sql = "select empcode,empname,address from employeemaster"

Cr.Connect = "DSN=emp;UID=test;PWD=test"
Cr.SQLQuery = sql
Cr.Action = 1

can anybody help me to solve it..


Regards,
Raj