Solved

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

Posted on 2008-06-24
1
266 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This article describes some very basic things about SQL Server filegroups.
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now