mjmiller24
Programmer
My current situation is the following:
I have multiple documents for one ID number. I have several other fields that are displayed in the reports also. However, the reports look exactly the same, they almost look like duplicates, except for the different documents. It should be noted that the ID is the common link between tables.
The select statement, generically, looks like:
SELECT
MAIN.ID, TABLE.ID, TABLE.DOCUMENT
FROM
MAIN MAIN, TABLE TABLE
WHERE
MAIN.ID = TABLE.ID;
example output:
ID Document
343 Test1
343 Test2
Is there a way to get Crystal reports to put all of the documents in the same report so that the IDs are not duplicated?
This is what I want to see:
ID Document
343 Test1 Test2
[/blue]
I have multiple documents for one ID number. I have several other fields that are displayed in the reports also. However, the reports look exactly the same, they almost look like duplicates, except for the different documents. It should be noted that the ID is the common link between tables.
The select statement, generically, looks like:
SELECT
MAIN.ID, TABLE.ID, TABLE.DOCUMENT
FROM
MAIN MAIN, TABLE TABLE
WHERE
MAIN.ID = TABLE.ID;
example output:
ID Document
343 Test1
343 Test2
Is there a way to get Crystal reports to put all of the documents in the same report so that the IDs are not duplicated?
This is what I want to see:
ID Document
343 Test1 Test2
[/blue]