summary of two groups on a page in a report

[Guest]

how can i create a summary of two groups on one page in a report without
subtotal of the 2nd group from the 1st group.

the problem is i wanted to count the transaction of all salesman summarily
and after that the transaction count of department not under of any salesman
but with all the department on records.

 

[Guest]

Can I presume that all salesmen are related to departments? If so, you may
like to base your report on a query that has an outer join from dept to
salesman. Not sure if this is what you are after, but try grouping by
department AND by salesman. In your report add a grouping level based on:

IsNull([Salesman])

or something like that, which should provide True and False. Then you can
have a summary in the False (not null) group footer for the salesmen, and a
summary in the True (nulls) for the departments w/o salesmen.

Anthony