Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

  • Newbies
Posted

So sorry if this seems to be a trivial question, but I am a newbie with FM.

I am trying to create a report/layout that has a list of parts contained within sections.

The parts need to be listed in separate sections in the layout, so for example all parts in section 1 would be on pages 1-3, section 2 page 4, section 3 pages 5-6 e.t.c. I can't work out how to put a page break after each section.

The STOCK_NO field is unique i.e.

01234 Part in section 1

01235 part in section 1

02134 part in section 2

...

24123 part in section 24

I have also created a field 'SECTION' which contains 1-24

At the moment with the current layout all the parts get listed.

I have attached a picture, with the current layout.

Hope someone can help.

Thanks

Tim

fmparts.jpg

Posted

Try adding a Section table with fields Section# and Page#. Relate this by Section# to the table that your report is based in. Then add a Sub-Summary by Page part (selecting the related Page# field) to the layout and set the option for this part to Page break after each occurence. This part does need to have anything on it in the layout. After you have defined the Page#s that each Section is on, you can run your report and sort by Section::Page#, to get it to break by the defined pages.

Posted

If no more than one Section is on a page, then you can skip the Section table, and instead use a Sub-Summary by Section part.

  • Newbies
Posted

OK, think I know what you mean.

Problem is, that the parts list is dynamic and can shrink or grow! So I would have to work out the page# for each part and then enter them again? Is that right???

I have attached a picture of the layout.

Thanks again

Tim

FMpart2.jpg

Posted

It sounded like you have a Section# assigned to each part. This is all that's necessary to get the methods described above to work. This is dynamic. The parts will be grouped by Section#, and a new page will break at each new Section#.

This topic is 7206 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
×
×
  • Create New...

Important Information

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