Sally,
I think you would change the subsummary part to sorted by size. Put
<<border>> <<size>> <<QtySum>> on it. Sort the report by both border
type and size, and your report should look just like you want.
Geoff
On Sep 15, 2009, at 10:52 AM, Sally Lawrence wrote:
Hello, I need to create a printable report that will show three
items: Border type, size, and
a summary count of each. I have 15 different border types and two
available sizes for
each. So in a batch of 30 records, if one of each border type on
each size is ordered, I
would like the report to look like this:
Border A 11x14 1
Border A 8x10 1
Border B 11x14 1
Border B 8x10 1
Currently I am printing two separate reports, one that shows just
11x14s, and another that
shows just the 8x10s, using a find for the size, a subsummary layout
part sorted by border,
and a summary field (count of Borders). I just can't figure out how
to consolidate the two
reports on one page. Thanks in advance for the help.
(This client is using filemaker 7.ov3. Thanks
Sally
