Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: alias tables Post Reply Post New Topic
Author Message
Leda
Newbie
Newbie
Avatar

Joined: 19 Jan 2011
Location: Panama
Online Status: Offline
Posts: 3
Quote Leda Replybullet Topic: alias tables
    Posted: 04 Apr 2011 at 7:17am
Hello, I am trying to write a report that shows information on purchase, related Purchase order and payments. 
JRow.postorder to JHdr.postorder
JRow_PurchaseOrder.postorder to JHdr_PurchaseOrder.postorder
JRow.postorder to JRow_PurchaseOrder.LinkToAnotherTrx
JRow.postorder to JRow_Payment.LinkToAnotherTrx
 
Is this correct?
How should be my selection record formula?
 
Do you have any information to share related to that?
Thanks in advance
Leda
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 04 Apr 2011 at 10:24am
I assume you're selecting the tables in the Database Expert, correct?  If so, you link from one table to the next on the linking tab of the expert - you don't have to create selection criteria for this.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Leda
Newbie
Newbie
Avatar

Joined: 19 Jan 2011
Location: Panama
Online Status: Offline
Posts: 3
Quote Leda Replybullet Posted: 04 Apr 2011 at 11:46am
Yes I did on Database Expert but I need a sample of the Record Selection Formula.
Leda
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 04 Apr 2011 at 12:15pm
What are you trying to do in your record selection?  Joins don't happen in the record selection formula - they're automatically created when you link the tables together in the Database Expert.  Without more details about how you're trying to filter your data after it's joined, I can't give you an example.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.