Jump to content
Sign in to follow this  
rimpoche

Sub-Summary Report Problem

Recommended Posts

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 ]

Share this post


Link to post
Share on other sites

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

This way it will just show you the totals.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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))

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.