It may be possible to move the data to a a "report" table and insert the sub totals as separate records in this table.
Can you post an example of what the report would look like? It doesn't need to be a picture perfect image, just enough detail to see how the sub summarys work when you produce this report in a FileMaker client.
Thanks for offering to look at this.
See attached image. It's really simple. It just counts the number of any given SubType like iPads, Projectors, etc. They are sorted into Type then SubType but that's mostly just for categorizing purposes. But this thing just shows as blank in IWP.
Presumably each row in this layout is a sub summary part.
Define a new table. Define a field for type and sub type. Set a unique values, validate always validation rule on Sub Type. Then import all your records from your current table into this new table. The validation rule will filter out duplicates so that you get one record for each sub type.
Define this relationship:
YourTable::SubType = SummaryTable::SubType
Base your layout on the new sumary table with it's Type and Sub Type fields but also include your Count type summary field from yourTable. This list view layout will be IWP compatible.
Thanks for the response, I will give it some more thought so that I can fully understand the process.
Does it help that I already have Type and SubType in a separate table? I put them there to make nested value lists.
Assuming that "subType" is unique, you should be able to use your table of SubTypes for this report.
Should this be a Body part for the web layout and not a Sub-summary?
I've got it displaying running totals, but I'd like it to just give "25" for a total rather than "23...24...25" etc.
Avoiding the use of a sub summary part is what makes this report web compatible. Yes, the fields are placed in the body part. Since the layout is based on one record for each sub type, a simple list of records will give you one total for each sub type.
Sadly I'm still not having any luck with this. I apologize.
The best I have gotten has been 23...24...25 counts of everything but I can't get it to just show the final total. Any other tweaking I do just results in 0 or blanks.
If it matters, every row is not a sub summary part. There is only one main sub summary part that displays everything on the original report.
This report layout should have NO sub summary parts.
This report layout should refer to the subtypes table in Layout setup...| "Show records from", not your main data table so that you get one record for each subtype.
It has no sub summary parts.
I have it set to show the other table.
I guess I am curious as to if I need to make another field in the SubType database. When I show the summary field from the relationship it shows as zero.
I sort of have this working in another test database with a self-relationship but for some reason I can't figure this one out.
The summary field should display the total of the related records. If you have multiple table occurrences involved, review your relationship graph and make sure that you are specifying the summary field from the correct occurrence of your main data table. (And make sure that your records are matching up by SubType not some other fields or an operator other than =.)
I have a scratch database working with 2 tables exactly as you describe.
My working database only shows zeros. The pre-existing relationship I am using to generate nested menus from the SubType database must be interfering with any new relationship I try to create.
I tried making a new table with the same SubType records and made a brand new relationship, still no go...just get zeros for everything. There must be some minor detail I am missing.
In which table did you define the summary field?
I tried making a new table with the same SubType records
Did you do that on the Relationships tab or the Tables tab of Manage | database?
Let's assume that you used the relationships tab...
In Manage | Database | relationships, make a new table occurrence of SubTypes by clicking it and then clicking the duplicate button (2 green plus signs). You can double click the new occurrence box to get a dialog to appear where you can rename the new occurrence box as SubTypesSummary.
We have not duplicated a table. Instead, this is a new reference to the same table already present in your database.
Add it to your relationships like this:
SubTypesSummary::SubType = YourMainTable::SubType
Make sure that these two SubType tables are exactly the same data type, text I would assume here.
Create a layout based on SubTypesSummary by selecting this name in Show Records From in layout setup. Add fields to the body from this same table occurrence. Define a summmary field, sTotal, in YourMainTable that computes the total of your number field.
On your SubTypesSummary layout, use the field tool to add a field to the layout. Select YourMainTable from the drop down in specify field and then click sTotal to select it.
Set up your layout for view as list or view as table and you should see the sub type name and the total for each sub type.