Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 6 of 6
  1. #1
    Gold Member
    Join Date
    Mar 2015
    Posts
    27
    Location
    Bakersfield, CA, USA
    FileMaker Pro Software
    FileMaker Pro ver14.3 - Mac
    OS
    Mac
    Skill Level
    Intermediate
    Last Post
    10-25-2017
    Local Date
    11-20-2017
    Local Time
    11:48 PM
    Last Active
    11-21-2017

    Show Sub-summary rows only

    Good Day,

    I thought there is a way to show only the sub-summary part in a report and hide the body that has all the sorted records. However, I cannot figure out how to do this.
    Please help.

    The case is similar to wanting to do a report on a Line Items Join Table that shows several invoices and sorts them by serial no. Then the desired report will just show the totals for the sorted serial numbers that are totaled in the sub-summary Layout Part and not all the individual line items in the Body of the report.

    Best regards, Rick

  2. #2
    Senior Moderator - FMT Preferred Developer Consultant - Netherlands, Europe, Asia, USA Maarten Witberg's Avatar
    Join Date
    Mar 2004
    Posts
    6,135
    Location
    netherlands
    FileMaker Pro Software
    version 11, 12, 13, 14, 15
    OS
    Windows & Mac
    Skill Level
    Developer
    Last Post
    06-29-2017
    Local Date
    11-21-2017
    Local Time
    09:48 AM
    Last Active
    07-16-2017
    Just drag the main part up so it is removed. Make sure the sort order matches the subsummary part settings.
    Stick to what you don't know.

    http://www.maartenwitberg.nl

    Filemaker 15 Certified Developer

    -------

  3. #3
    Forum Member
    Join Date
    Apr 2012
    Posts
    1
    Location
    Milton Keynes, UK
    FileMaker Pro Software
    FM15
    OS
    Windows & Mac
    Skill Level
    Pro, Developer
    Last Post
    02-15-2017
    Local Date
    11-21-2017
    Local Time
    08:48 AM
    Last Active
    10-11-2017
    Hi Rick,
    Just create your report without a body part and which has only the sub summary parts
    Once you have your found set and you are sorted by appropriate breaks then only the sub summaries will show

    Cheers
    Harry

  4. #4
    Gold Member
    Join Date
    Mar 2015
    Posts
    27
    Location
    Bakersfield, CA, USA
    FileMaker Pro Software
    FileMaker Pro ver14.3 - Mac
    OS
    Mac
    Skill Level
    Intermediate
    Last Post
    10-25-2017
    Local Date
    11-20-2017
    Local Time
    11:48 PM
    Last Active
    11-21-2017
    Thanks! I was reluctant to do this at first for fear crashing the sub-summary report. But once I figured out that you can just fold up the Body part after removing the fields, it all worked just fine.
    Really appreciate your help

  5. #5
    FileMaker Mentor
    Join Date
    Aug 2015
    Posts
    111
    Location
    Broomall, PA USA
    FileMaker Pro Software
    FM 16 Advanced
    OS
    Windows
    Skill Level
    Intermediate
    Last Post
    11-18-2017
    Local Date
    11-21-2017
    Local Time
    02:48 AM
    Last Active
    11-20-2017
    You can also make 2 reports in 1 by changing the body part to another sub-summary. Then when you only sort on the first sub-summary you get a summary, but when you sort on both you get a detail of all the lines.Summary-Detail.png

  6. #6
    Senior Moderator - FMT Preferred Developer Consultant - Netherlands, Europe, Asia, USA Maarten Witberg's Avatar
    Join Date
    Mar 2004
    Posts
    6,135
    Location
    netherlands
    FileMaker Pro Software
    version 11, 12, 13, 14, 15
    OS
    Windows & Mac
    Skill Level
    Developer
    Last Post
    06-29-2017
    Local Date
    11-21-2017
    Local Time
    09:48 AM
    Last Active
    07-16-2017
    nice!
    Stick to what you don't know.

    http://www.maartenwitberg.nl

    Filemaker 15 Certified Developer

    -------

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 guests)

Similar Threads

  1. Leading Grand Summary doesn't show when printed
    By acarlsson in forum FileMaker 13 - All Versions
    Replies: 1
    Last Post: 05-28-2014, 04:50 PM
  2. Show Sub-summary Report Counter
    By Benjabcarp in forum FileMaker 13 - All Versions
    Replies: 3
    Last Post: 05-02-2014, 12:11 PM
  3. Flat File Import - many rows per client - report to show one per?
    By kirkrr in forum Portal & Relationships
    Replies: 6
    Last Post: 12-18-2012, 10:07 AM
  4. Show Equal highest value in Sub summary
    By mjrogers50 in forum FileMaker Pro 9
    Replies: 1
    Last Post: 12-29-2008, 10:16 AM
  5. Summary of Portal Rows...
    By JaySee in forum Portal & Relationships
    Replies: 1
    Last Post: 02-26-2002, 04:33 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a FREE to join community where you can boost your FileMaker expertise, build better apps & solutions and interact with over 42,000+ FileMaker Developers from all over the world. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.