Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Displaying 1 Row from a multi-instance table
I am using two tables Name and Demographics. From the name table I am displaying company name and company Id From Demographics I am using Transport Volume. I have two types of Members that I am pulling for to get the total transport volume for the main agency. ACC – Agency ASA – Agency...- yaz1np
- Post #7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Displaying 1 Row from a multi-instance table
Thank you for your help. Setting the maximum on the date field helps to show the last field for a given ID number and I used a subreport to link the additional agencies to the main agencies to get a total for the whole comapny. But of course they now want to see it group by the volume field...- yaz1np
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Displaying 1 Row from a multi-instance table
Help, I am creating a crystal report that is using two tables, one of the tables “Demo” is a multi-instance table (Can contain more than one record per ID) I need to display the last or only record per ID number from the Demo table. I am using crystal 7.0 but I also have crystal 9.0 if this can...- yaz1np
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 1 Formulas
