Summary Report Question

[gsfield]

New to FM (only been using for six months)...

Is there a way to create/design a Summarized Report (i.e., a report with subtotals or "sections" of information -- WITHOUT including the field that's being used as the Summary delineator?

For example, I might have a field named "color" and want to sort the report BY color (in sections)... all the blue ones, then the green ones. Can the report be displayed (on screen or print) without showing "blue" and "green" as the section dividers?

FM "compels" you to choose the summary field(s) during the layout wizard -- I just don't want them to be displayed on the output.

Any clues are appreciated.

[ffarmer]

I believe the answer to your question is "yes".

You would still have to sort the data based on the break-field, and define the sub-summary part to break on that field, but I don't think the field itself has to appear on the report.

At worst, in Layout mode, you can always move the break-field off to the far right, beyond the right hand margin. This way, it'll "appear" in Layout & Browse modes (may come in handy to know it's "there") BUT it WON'T appear in Preview mode.

[Robert Kidd]

You don't need your summary break field on the layout at all.