N
nmatthis
Guest
I'm very familiar with taking data from a single table and creating a report in Crystal Reports for this single table. I can use the Detail section to display the fields I want displayed.
But what if I have data from two tables, each of which have different fields or attributes? Lets say I have 3 records in Table A and 4 records in Table B in my report. In the Detail section, I would like CR to display the 3 records from Table A, which it's distinct fields, then under that, list the 4 records from Table B, with it's own distinct fields. I understand that the records displayed from Table A would have their own field headings, and so would the records from Table B.
I thought I could do this by creating multiple Details, A and B, but when I do this, the report only shows one record from A and one record from B. This seems very basic and I'm just missing something obvious. Any help appreciated. Thanks.
Neal
But what if I have data from two tables, each of which have different fields or attributes? Lets say I have 3 records in Table A and 4 records in Table B in my report. In the Detail section, I would like CR to display the 3 records from Table A, which it's distinct fields, then under that, list the 4 records from Table B, with it's own distinct fields. I understand that the records displayed from Table A would have their own field headings, and so would the records from Table B.
I thought I could do this by creating multiple Details, A and B, but when I do this, the report only shows one record from A and one record from B. This seems very basic and I'm just missing something obvious. Any help appreciated. Thanks.
Neal