crystal report

[kpr]

dear friends,
to show the reports in my appplication i am using the crystal reports.in cr i am creating the reports with a system dsn.
when i am trying to show this report through my vb application i am getting the report,but when i am trying to view the report by setting the recordselection formula.its giving the followin error:
IM001[Microsoft][ODBC database driver]data source name not found.
i am giving the coding which i am using to show the report.
dim apli as craxdrt.application
dim report as craxdrt.report
sub show()
set report=apli.openreport("the path of the report",1)' i tried even with 0
report.database.tables(1).setdatasouce "the systemdsnname"
report.recordselectionformula="{tablename.fieldname}='" & value & "'"
reportviewer.reportsource=report
reportviewer.viewreport
end sub

i hope any one will come up with a solution.thanks in advance to the one who comes with solution.

[Vishalgiri]

1. As Beacause of Your Problem is "DSN Not Found" So try to Use a ADODB.Connection Insted of it (Hopefully You Know about that)
2. and also check you SQL string which u r using at selection


I came Acrose this problem when i make a application and On Other PC there was no DSN so I hope u got it

How ever Try these, It may Help You But I m not Sure about it because It could be other problems too