Using Crystal Reports XI
We have a report that lists the IDs of all Salesmen that exist in the fields
"Inside" and "Outside" in the "Invoices" table. The report is Grouped by
In the Detail section, we want a subreport that contains all invoices where
"Inside" OR "Outside" = SalesmanID.
We need to create a SQL command/Query for a subreport that receives the
SalesmanID from the main report as a link/parameter where either of two
columns contains the SalesmanID
SELECT * FROM Invoices WHERE (`Inside` = @SalesmanID OR `Outside` =
@SalesmanID = Value from main report passed to the subreport command/query.
Invoice table illustration:
INV# INSIDE OUTSIDE INVAMT
001 A A $1000
002 B A $2000
003 C B $3000
Any help will be appreciated