Sub-Summary Report Problem

[rimpoche]

I created a database program consisting of two files, one is a Project file and one is a Unit file. The purpose of the program is to have the user create a shelving installation project for a particular customer and to populate that project with different sized shelving units from Unit File. The Unit file differentiates each shelving unit by size, color, options. I am trying to create a raw material parts list to give to my purchasing agent so that he can buy material to produce the shelves. Here's an example. I have a project that has two similar shenvling units in it. Unit 1 is 12"W x 36"L x 74"H with 4 shelves . Unit 2 is 12"W x 36"L x 85"H with 6 shelves. The only difference is the height. I created a layout that has 2 sub-summary parts. Part one is sorted by a field called shelf_size and contains the summary field total_qty_shelves. Part 2 is sorted by a field called post height and contains the summary field total_qty_posts.

This is how the report looks in preview:

shelf size 12x36 qty shelves 4

shelf size 12x36 qty shelves 6

post size 74" qty posts 4

post size 85" qty posts 4

I want the report to group the identical shelves together. It should look like this:

shelf size 12x36 qty shelves 10

post size 74" qty posts 4

post size 85" qty posts 4

If the two separate shelf units are identical, I get the output that I am looking for. I am sure that someone can help me I am kind of new at this. Also, I simplified the example so I may not have provided enough information.

[ March 01, 2002, 06:00 AM: Message edited by: rimpoche ]

[andygaunt]

In your report, don't have a body area, just a subsummary.

This way it will just show you the totals.

[rimpoche]

Andy, thanks for the quick response. I do not have a body section in the report. Anymore suggestions. Thanks again.

[andygaunt]

OK,

can you email the files to me.

[andygaunt]

By changing the field that the subsummary sorts on to the quantity field, will then only give the total figure on one line

[Fitch]

rimpoche, you answered your own question.

"Unit 1 is 12"W x 36"L x 74"H with 4 shelves.

Unit 2 is 12"W x 36"L x 85"H with 6 shelves.

The only difference is the height. "

Well, one difference is all it takes my friend, to make a sub-summary break it out separately. FileMaker has no intrinsic understanding of shelving installations.

You're either going to need to keep the height in a separate field, or sort on a calculated WidthLength field like this:

Left(shelf_size, Position(shelf_size, "L", 1, 1))