Crystal on Client Machine - server has not yet been opened

[PleaseGiveHelp]

I created an application that runs and prints a Crystal Report. It works great on my machine. However it does not work on the client machine. At first I had a message 'Physical Database not found' and so I registered the dll's and now I'm getting this 'server has not yet been opened' error. Crystal is NOT on the client machine, however I have registered some of the .dll's that I know are imperative...can I run my application on this client machine if Crystal is not installed...I don't want to open the report, only print it...help!

 

[StevenK]

Ensure that the database access dll's are on the client machine (files like 'p2sodbc.dll', 'p2ssql.dll').
If you're making use of the Crystal Reports Viewer component - ensure that it (and dependencies) are registered.
Also ensure that the database log-in information (I'm assuming you're running the reports against SQL Server) is set accordingly such that all tables in the report / subreport can be connected to.
I hope that this helps.
Steve

 

[PleaseGiveHelp]

Ok so does this mean that if I don't install Crystal Reports, I DO need to install the viewer? Or can I just bring on over any necessary .dll's?

 

[StevenK]

I make use of the Crystal Reports Viewer component in Delphi 5.
I need to include (for distribution) 'CRViewer.dll' and 'Craxdrt.dll' - both of which I register on the target client machine.
I hope that this helps.
Steve

 

[PleaseGiveHelp]

So i need the two .dll's AS WELL AS the crystal reports viewer? i installed the .dll's and still have the error...so then does this mean i need to install the actual viewer? and can i install the viewer without having to use my crystal reports license?

 

[JohnBates]

Hi PleaseGiveHelp (i like the name),

Is your application Visual Basic?

If so, in VB, check-off the Crystal Report Viewer in the VB projects References and Components. Select Crystal Reports Viewer Control in both places.

Then (using Tools or Addins I cant remember which),
create a Setup/Install package by using the Package and Deployment Wizard.

The setup package will then contain the necessary runtime .dlls to ghet it to run on the client PC, after you run the setup.exe on the users PC.

All of these comments are for Visual Basic. Other languages have similar ways of creating a setup package.

John

 

[StevenK]

As mentioned in my first post reply - do you have the appropriate database access dll's on the client machine ?
The message 'Server has not yet been opened' I think comes from trying to access SQL Server database tables - so it may be that it can't get a link to them.
Check that you have the database access dll's and ensure that you're able to interogate the data through other means (outside the scope of Crystal Reports itself) - can this be done ?
Are you sure that you're passing the appropriate information to the logon for accessing the database tables - if you're not then again this might cause the error you're seeing (ensure you have the correct server-namer, database name, table name, user name and password as appropriate).
I hope that we can help you solve this.
Steve

 

[SurfingGecko]

looking for some info----

The errors you are seeing are basically telling you that your report can ont gain access to the specified data source.

you will have to include several Crystal runtime files in your application's setup/install to allow a client to use it. In addition you will need to ensure the proper data connection is available.

What database are you reporting off and how are your reports designed to connect?

Which version of CR are you using? If 8.8.5 have a look for runtime.chm on your dev machine and read through it.










Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com