How do you use multiple member files in Crystal Reports?
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
Software/Hardware used:
iseries, as400, crystal reports
ASKED:
September 2, 2011 3:16 PM
UPDATED:
March 31, 2012 5:11 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
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
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
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