Home > IT Answers > Business Intelligence > How do you use multiple member files in Cryst...
Tcuccaro
25 pts.
 How do you use multiple member files in Crystal Reports?
Crystal Reports, AS/400 database, iSeries, iSeries AS/400
i have to retreive data from as400 iseires files that have multiple members and most do not have a logical for that member without creating a new logical is there anyway to tell crystal reports to use a certain member ?

Software/Hardware used:
iseries, as400, crystal reports
ASKED: Sep 2, 2011  3:17 PM GMT
UPDATED: March 31, 2012  5:11:55 PM GMT
RELATED QUESTIONS
Tcuccaro
25 pts.
Answer Wiki:
Last Wiki Answer Submitted:  Sep 2, 2011  3:17 PM (GMT)  by  Tcuccaro   25 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

Don’t know if this will help …
To access the members from sql on the 400 you would create an AS/400 SQL alias - name the file and member and then work with the Alias as if it were a file.
Phil

Philpl1jb
 36,420 pts.
 

There are three general alternatives.

First is simply not to reference any member except the *FIRST member. Crystal Reports needs to use SQL to retrieve data, and SQL has no concept of members.

Second is to issue OVRDBF in the job. Override the member to the member you want to retrieve. You’ll need to determine if Crystal Reports can send a command before sending the query.

Third is as Phil says — create an ALIAS on the server. That might not be possible if you can’t create a logical file.

Tom

TomLiotta
 66,935 pts.
 

thans I will try these ideas - currently i do not have privlledges to do the create command to create an alais but I am working on that - thanks again
Tony

Tcuccaro
 25 pts.