Accessing AS/400 PF members in Crystal Reports

[Guest.Visitor]

I am using Crystal Reports 8.5 with the Client Access ODBC to access data on the AS/400. How can I access specific members of a PF? I always get the first member. In addition, if the first member is not named the same as the PF, then I get an error. I have just started using Crystal Reports and am very pleased...so far. Thanks in advance for a quick response.

[David Abramowitz]

CR does not give you a member option even when using the OLE/ADO connection. I would suggest copying the member to another (new) file. Dave

[Guest.Visitor]

Depending on file/member sizes, you could try Logical views of the mbr. bobh

[Guest.Visitor]

Scott, The multiple members problem is a common problem when we start dealing with them via ODBC. You can use the SQL Alias command to create aliases for each member that can then be referenced by the ODBC driver. Bill

[Guest.Visitor]

//Quick-n-Dirty ODBC/SQL access //If ODBC gives you the annoying "*N" not valid error, //type at As/400 cmd line (ignore //Comments): ADDRDBDIRE RDB(<your as400 Local-control-point name from DSPNETA>) + RMTLOCNAME(*local) //Type the following at As/400 cmd line: STRSQL NAMING(*SQL) //You will now be in interactive SQL (My option 13 on menu CMDSQL) //Type: CREATE LIBRARY.ALIASNAME FOR LIBRARY.FILE(MEMBER) //Example: For ODBC to retrieve my modified IPL startup file //in QGPL/QCLSRC(QSTRUP) I type: //CREATE ALIAS qgpl.myqstrup FOR qgpl.qclsrc(qstrup) //Press F3 and taker option 1 to save session. You normally won't //execute this more than once for each alias you need. //Now browse QGPL with Crystal Reports (or whatever). CA400 ODBC will now //return a file named "myqstrup" which represents file member //QGPL/QCLSRC(QSTRUP). Bob Mills DP Solutions Lufkin TX

[deepu73@hotmail.com]

How can I access As/400 PF records using Crystal report ? Do I need to have VB installed in my Pc to do this ? Thank You, Deepu

[David Abramowitz]

All you need is the ODBC driver that comes free with CA/400. Even if you don't have a CA/400 license, you may still use the ODBC driver free of charge. CR also supports OLE/ADO. Dave