Indexing and viewing reports

[raouls]

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

[mr_vodka]

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'

[raouls]

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?

[mr_vodka]

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.