I know how to specify a sort when I create the report layout, but I've got one created and "prettified" and now want to add another sort level.

Does anyone know how to add it. It's an awful lot of work to go back and re-create the entire layout just to add a sort level.

Thanks.

SewCool2

When you say "sort level," I assume you're talking about adding a sub-summary part. Go to Layout mode and choose Part Setup... from the Layout menu. That lets you insert a part without scrambling your layout.

If you have a script where one step is "Sort", then perform the new sort (with the added level), then open the script. When you hit "OK", you'll be asked if you want to keep the original sort order, or change to the new one. Change to the new one.

When creating a new "level" as you call it, why not duplicate the report, then add your new subsummary part to the original.

You can then amend the script as for danjacoby's reply, and if it doesn't work you still have your duplicate to fall back on and try again.

This method was learnt from many ****ups when creating summary reports of varying levels... (or as the old addage says - always work on a copy)

[ March 31, 2002, 05:05 AM: Message edited by: ADB ]