Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Sub-Summary When Sorted By


Recommended Posts

Hi All!


I hope you can help me with a problem.

I have created a database and I would like to generate a report from it that is sorted and printed in a specific way.


Essentially, there are fields representing ReelName (Number), Timecode (Number), Scene Prefix (Letter), and Scene Number (Number). I have listed these fields in the order I want the records sorted:




Scene Prefix

Scene Number


Everytime the report hits a new Scene Number, I want a page break. I have created a SubSummary Part (Subsummary when sorted by Scene Number) that does so, and it works just fine ONLY if the records are sorted like so:


Scene Prefix

Scene Number

(and then all of my other data fields)


Once I sort the records in the order I need (as I laid out at the start of the post), where Scene Number is fourth in the sort order list, the report prints only one record per page and inserts the SubSummary with every record, rather than displaying together all of the records that share a Scene Number.


Any ideas as to how to remedy this? Am I missing a key step, or is this a Filemaker 8 bug? I'm sure I can write a script and run it every time I want to print, but this seems basic enough to be done within the layout definitions.




Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.

  • Create New...

Important Information

Terms of Use