Re: multi member file use in Crystal Reports -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Get a copy of WRKODBCJOB if you are going to be doing a lot of this. This utility will show you who is logged on using ODBC and then you can look at the attributes of the connection: library list, open files, overrides, etc. You can get a copy here:
http://home.roadrunner.com/~jbmmdietz/wrkodbcjob.html

I couldn't function without it.

Pete

Hoteltravelfundotcom wrote:

We have many multi-member files on the iSeries that we would like to report
against using Crystal Reports. I have created an Alias file name using SQL
on the iSeries to reference a single member within a file. The alias file is
not showing up in my datasource list in Crytal Reports. My IBM iSeries
Access for Windows data source definition is using the "iSeries Access ODBC
Driver". Do I need to setup another data source using a different driver to
access SQL alias information on the iseries? If so, which driver should I
use?

Any ideas would be much appreciated. The Crystal product is new for us and
we still have a lot to learn. Thanks!

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.