Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

VB Crystal Reports using INFORMIX Database

Posted on 1998-10-16
2
Medium Priority
?
507 Views
Last Modified: 2010-10-05
hi!

i wish i can ask some help from anybody who is familiar with VB5 in INFORMIX Database.

How can I generate a Report in Crystal Reports using INFORMIX ODCB in VB

thanks
0
Comment
Question by:bmaranan
[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
2 Comments
 
LVL 2

Expert Comment

by:BergJC
ID: 1440251
I'm unfamiliar with Informix, but here's how you use any other ODBC database:

1)Choose "File/New"
2)Choose "Standard report"
3)In the "Tables" tab, Click on the "SQL/ODBC" button
4)A "Log-on Server" dialog box will come up. Press the "Database File" button.
5)Choose your database file and click "Add"
6)When you are finished, click "Done"
7)Now your tables should be listed. Go over to the "Fields" tab and select the fields you wish to place on the report.

Everything else is just like any other database. If you need more help beyond that, let me know.




0
 

Accepted Solution

by:
pbirkbeck earned 100 total points
ID: 1440252
I had a heck of a time with this!  I called Crystal about this and the only Informix ODBC drivers that they support/recommend (at least at the time) are the ones from intersolv.  The URL you'll want to look at is http://www.microfocus.com/products/data.htm

Good luck... this did work for us though...
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

721 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