I have several showrooms in a "Shwrm" field and wish to have status reports generated in another layout for each showroom.

I can successfully run a script that gets the showrooms to list in the layout but want to know if there is a way to have a new record (page that can be printed independently) created in that new layout for each showroom. Here is the script I am running currently.

Enter Find Mode []

Set Field [Current Order Status::Shwrm; "JRFL"

New Record/Request

Set Field [Current Order Status::Shwrm; "GMAT"

New Record/Request

Set Field [Current Order Status::Shwrm; "JRDC"

New Record/Request

Set Field [Current Order Status::Shwrm; "IDCD"

New Record/Request

Set Field [Current Order Status::Shwrm; "YCTO"

Perform Find[]

Sort Records[Restore; No dialog]

Go to Layout["Showroom Status Report"]

Currently it puts everything on one page, I would like to have 5 different pages, one for each showroom. Thanks guys!

Raouls

You can do this by at least two means.

Option 1 is do a seperate find for each criteria singularly and then print.

Option 2 is to create a new report layout with grouped data. Pick the fields that you want on the report, and then organize records by the field 'Current Order Status::Shwrm'.

After your report is created, go to layout mode and right click on the subsummary part definition and change the checkbox to 'Page break before each Occurrence'

OK John (and anyone else),

Using your second option (which seems a bit more automated) I got the report to show all of the showrooms.

Then when I go to layout mode, Layouts then Part Setup, then I choose Body then Change, then I click "sub-summary when sorted by" then click shwrm, then I click "page break before each occurrance."

Regardless whether I choose "print above" or "print below" the resulting layout is blank (Though it shows records found). What am I missing?

No, I did not say to change the body part.

First, did you create a reports layout using the wizard (columnar/list report). If you used the wizard, and did as in my previous post, it should have created a subsummary part. Right click on that one.