Summary Report

[Guest]

Is it possible to have a report that draws from multiple queries or tables?
For example, I have one query which counts shipments, one query which counts
units returned, and one query which counts damaged goods. I'd like a report
which shows the results of all three queries which are totally unrelated.

Thanks,

 

[Guest]

You will ned to use subreports and not define any parent child relationships
to be able to have all of these on one report if there is no relationship.

 

[Pieter Wijnen]

SELECT 'Shipment' AS Code, Count(*) AS CNT FROM SHIPMENTS
UNION ALL
SELECT 'Returned' ,COUNT(*) FROM UnitsReturned
UNION ALL
SELECT 'Damaged', Count(*) FROM DAMAGED

Would do it

Pieter

 

[Pieter Wijnen]

SELECT 'Shipment' AS Code, Count(*) AS CNT FROM SHIPMENTS
UNION ALL
SELECT 'Returned' ,COUNT(*) FROM UnitsReturned
UNION ALL
SELECT 'Damaged', Count(*) FROM DAMAGED

Would do it

Pieter

You will ned to use subreports and not define any parent child
relationships
to be able to have all of these on one report if there is no relationship.

--