Solved

Crystal Reports - VB front end to run report and refresh at runtime

Posted on 2008-06-24
1
268 Views
Last Modified: 2013-12-25
I want to use VB to run a crystal report and have the data refreshed at runtime. Can this all be wrapped up into an executable that any user can run? Within Crystal I connect to a DB2 database using ODBC (RDO).  The database connection would need to happen inside the VB App. The important thing is that it can be run by any user just by running the executable.  Would each user need to have DB2 on their PC? It's been many years since I've worked with VB so before I spend alot of time I just want to know if this is possible. Thanks.
0
Comment
Question by:Deb6105
1 Comment
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 21861335
Crystal maintains its own connection even if used within an application.  You onl need to have a DSN with the same name available.

They would need to have the DB2 ODBC database drivers and permissions to a probably system DSN to the database.

It is possible.

There are also 3rd-party viewers available at fairly low cost.

Are you looking at using this within your orgamization?
Licensing depends on version, connection method, and inhouse or not.

mlmcc
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question