Report containing 2 Groups

[Guest]

I'm trying to create a report that details the items that a given cheque is
paying for. I'd like it to look something like this:

Cheque # 3

Book # Total
4 $3,000
13 $2,000
---------
$5,000

Chair # Total
25 $ 200
33 $2,500
---------
$ 2,700

Cheque Total
$ 7,700


In other words the cheque is paying for several different books and several
different chairs. So how do I get tow different groups (books and chairs)
with their respective details into one report without embedding the one group
within the other?

I hope I've explained this well enough to understand!

Thanks,
FJ

 

[Pat Hartman\(MVP\)]

You need to use the sorting and grouping properties of the report. To get
what you want, you'll need chequeNum, ItemGroup, and ItemID. You would
group and break on chequeNum and ItemGroup.

 

[Guest]

Hi FJ,

If you are trying to do two separate "groups" on a report that aren't
nested, you will need to use two subreports... one to group the Books and one
to group the Chairs. Embed these in your main report with other data as
necessary.

Hope this helps.

Damian.