I am generating a report using crystal report from vb6.0. I already designed the report using crystal reports with sql server 2000 as back end. when I am generating a report from vb 6.0 it giving the report error as "SERVER NOT YET BEEN STARTED". Can any please help me. Its matter of urgency for my module.
I tried using logonserver, its connecting to the server but when i tried using action = 1 to the report its giving me the error. I think its problem with the server connection. please help me out.
Re: problem(crystal report, sql server 2000,vb6.0)
My DSN is working fine. I am connecting to my dsn with rdo and getting the values into the dsn but giving problem only when connected with sql server via vb to generate the report.
I am sending the code .
my dsn settings dsn=gghms;userid=hms;pwd=hms
crviewer.reportsource = report
upto here it is fine working when used to generate the report with the action command on the report it is giving server not yet started.
cr.action = 1
Another important thing is when i designed the report in crystal reports 8.5 and saved the report with data then it is not giving any errors (since it was connected to the db at the crystal report instance) and it will loose the connection when i opened it else where again.
when I save the report without data then its giving me the problem.