Need Help with script

[Nestor]

I have 200 records. Each record has different values for example.

DC # Store# Style#

10 27 107

10 27 107

10 27 107

10 27 101

10 27 101

10 27 101

10 28 107

10 28 107

10 28 107

10 28 101

10 28 101

10 28 101

10 29 107

10 29 107

10 29 107

10 29 101

10 29 101

10 29 101

10 74 107

10 74 107

10 74 107

10 74 101

10 74 101

10 74 101

10 81 107

10 81 107

10 81 107

I want to create a report using a scrip so that i can print all stores at once, but having all records with store "27" on 1 page, store "28" on another page and so on. Any Ideas. Thank you

[Sanjai]

Create a columnar/list report with grouped data using FileMaker report assistant. In the "Organize records by category" dialog box of the report assistant, select the field "Store".

When you finish designing the report layout, in layout mode select the part definition of the summary part and select the check box to Page Break after every 1 occurance.