How do you use multiple member files in Crystal Reports?

40 pts.
Tags:
AS/400 database
Crystal Reports
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    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
    49,550 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • tcuccaro
    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
    40 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following