I have a report that uses a table that stores multiple records for a field in another table....basically a many to one relationship.
Problem is that when I try to return the many fields in table 2 against each corresponding field in Table 1, crystal reports returns that record in Table 1 multiple times according to table 2 instead of returning all the related records in Table 2 to each related record in Table 1.
For every record in Table 2 with TradeID = 12345, those records should all be returned in the report to one row bc each row needs to represent the record TradeID from Table 1
Table 1 is joined to Table 2 using the field TradeID. Table 2 contains multiple records for each TradeID. TradeID and the data associated with it should only be brought back once in the report. Is there anyway to accomplish this without having to group the report on TradeID? I have existing reports that I don't want to have to reconfigure with grouping.