One way would be to use a virtual list technique where the fields on the body part are calculations instead of the actual body fields. Something like:
Evaluate ( $fieldName )
You could then populate global fields or variables with the names of the fields you want to use. Or, just leave them empty if you wanted them to be empty.
Showing my ignorance -- I see how I can insert a field, variable, or symbol -- how do I insert the Evaluate() function?
why go to all that work when you could just create another layout with out the body part. You could be done with it in a few minutes?
If it was just this one, I would. And of course, if there's not a better way, I will have to. However, the solution we're developing will have many similar reports where we want the option to do totals-only. So, in addition to adding many extra layouts, every time a report is changed, we may have to make the same change or recreate the totals-only layout. I was hoping I was missing a better way as this seems like it would be a common need.
Ideally, the "hide when printing" option would be conditional based on a calculation. Also a hide when printing conditional option on whole layout parts would be even better for this case. I will make these enhancement requests to FileMaker if there is not a better way that I'm missing.
If you don't mind having to maintain an additional sort, you can place the individual lines in a Sub Summary by Item_ID. then you can
- sort only by Item_ID (unique for every line, thus like a body part),
- sort only by Item, showing just the Item summry without detail, or
- sort by both to show detail and summary
You have to be sure that there is a sort or you receive no results. More sorting, but more flexible.
That's intriguing. I'll play with that. Thanks.
The Evaluate function goes in a calculation field in the database table. You use that on the layout instead of the actual field that holds the data.
Got it. Thanks for the suggestion.