Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Featured Replies

  • Newbies

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

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.

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.

  • Author
  • Newbies

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

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#.

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.