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

Posted on 2008-06-24
Medium Priority
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.
Question by:Deb6105
1 Comment
LVL 101

Accepted Solution

mlmcc earned 2000 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.


Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

621 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