Jump to content

Sub-Summary Report Problem


rimpoche
 Share

This topic is 7171 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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 ]

Link to comment
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))

Link to comment
Share on other sites

This topic is 7171 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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