?
Solved

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

Posted on 2008-06-24
1
Medium Priority
?
273 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 101

Accepted Solution

by:
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.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

770 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