I have created a crystal reports file for my users. I want them to be able to click on an executable and be able to open up the file withou worrying about the login or the server name.
I setup a dsn on their pc so everything should be transparent.
This the code i have now
Set Report = Appl.OpenReport("c:\crystal_file.rpt")
Report.Database.LogOnServer "p2sodbc.dll", "DatabaseName", "DatabaseName", "username", "password"
CRViewer1.ReportSource = Report
I get a "Server has not yet been opened" error message from crystal reports.
Can anybody help me to get this to work?