Newbies gsfield Posted June 30, 2004 Newbies Share Posted June 30, 2004 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. Link to comment Share on other sites More sharing options...
ffarmer Posted July 3, 2004 Share Posted July 3, 2004 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. Link to comment Share on other sites More sharing options...
Robert Kidd Posted July 5, 2004 Share Posted July 5, 2004 You don't need your summary break field on the layout at all. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7258 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now