Hi there,

I have never used Crystal reports and tomorrow I have to make a change to a report. What I need is to add a field on a report from a table that is not part of the report yet.


Basically the report displays information about customer "A" and there's another table "B" that has multiple records about the customer (one to many) and I will get just one record from this secondary table and about 3 fields of that record need to go on the report.

I think from reading stuff on the net that I can add the table to the report data list. Basically my next problem would be how do I do a filter on table "B" (it needs to return just one record), basically how do I pass the customer id and another field of the main table as parameters, I guess if I can get to that point when I drop a field from table "B" into the report it's already going to be filtered when I run it, right?

Any suggestions?

Thanks.