Calling reports via VB application

[hal9000p]

I am having problems deploying a VB application to my users. Here is what is going on:
1. Server running SQL Server 2000 and IIS.
2. On the server there is a reports directory.
3. Reports were developed using Crystal 8.5.
4. Security on the report folder on the server is
defined at the domain\user level. This was done
so that reports can be maintained in one place
instead of installing them on every WS.
5. VB app running on the client selects a report to
run. When the print preview button is selected I
get an Access denies error.
6. Development testing works in referencing the report
directory on the server. Compiled application works
in development environment as well.

Is there something I am missing here? Perhaps this approach will not work? The client workstations I have tried to install this on all can access/open the report folder on the server, so I doubt that security is the issue. The Crystal web site is no help because almost all their examples use either file-based and/or locally resident DB's.

Dave

 

[chelseatech]

Have you installed the SQL client on your client PC's
In your VB code are you loggin in to the SQL DB?

Do your users have access to the SQL server DB? Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[hal9000p]

1. SQL Client is not installed.
2. Each user must login before using the app (NT domain
security). This works fine.
3. Besides, running reports, the app can also maintain
some tables. This works fine - once the user is
authenticated, they are able to make updates to these
tables.

So access to the SQL database is not the problem.
The only problem occurs when they try to print reports.

 

[kenhamady]

Try saving the report with saved data and see if the client gets the same error trying to run that report. That will tell you if it is access to the data or something else that is the problem. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[flager]

In the string you participated in on 26 mar above, you mentioned that the SQL logon had been taken care of. I ma new to crystal reports 8.5 as well as visual basic 6. I have developed the report, and imported it into VB. my problem is 'Server has not yet been opened' when I run from VB. Do you happen to have the code necessary to allow the user (ie me at the moment) to log on to the server? Many many thanks. Fred

 

[hal9000p]

Fred;
Basically don't use DSN's in any shape or form..they are too problematic, short of installing the full Crystal app on your client. What you need to do is use ADO recordsets to gather the data for your report. Go to the Crystal web site and download the following document:
Using Data Definition (TTX) files to pass an ADO recordset to a Crystal Report.
I'm sure other people know this factoid, but don't seem to want to share it as I've seen lot's of these posts...

Dave

 

[KenRicketts]

>>Basically don't use DSN's in any shape or form..they are too problematic, short of installing the full Crystal app on your client.

Does anyone know how problematic, or why? We have a system in development for which some 25 reports have already been produced, using DSNs. We are having a lot of problems with them, and I would like to know if converting them all to use ADO recordsets is the best solution. The changes required do not appear to be trivial (most of them have subreports) so I don't want to do it unless it really is necessary.