Try creating an SQL alias over your table member.
I believe the syntax is CREATE ALIAS ....
Then use that for the query.
Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
-----Original Message-----
------------------------------
message: 8
date: Thu, 19 Mar 2009 11:31:28 -0400
from: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
subject: multi member file use in Crystal Reports
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!
midrange.com
