[FX.php List] Subsummary report web page

[BEVERLY VOTH]

Cool! set the $section and $subsection to "" (empty) before the loop. If you have sorted correctly (by section and subsection), you can compare the value in each of these fields to the variable(s) at the beginning of the loop. If different, you have a "header" and you set the variable(s) with the value(s) at the same time you display the variable as needed. As you loop through the records, you'll get the correct headers above the list items. If you are using a table-tr-td for the display, remember to have sufficient cols to display the Section and SubSection values. I like to use TD colspan for these kinds of rows, but you can uses any manner of "spacing" to display the rows:

Section - - - 
- Subsection - - -
- - record fields ...
- Subsection - - -

HTH,
Beverly

On 09 Dec 2013, at 2:43 PM, Gary Sprung wrote:

> 
> On Dec 9, 2013, at 7:36 AM, BEVERLY VOTH <beverlyvoth at gmail.com> wrote:
> 
>> Gary,
>> 	I generally don't like to use scripts for this sort of thing.
> I agree. To me, the big problem with using FM scripts with the PHP API is the lack of feedback from the script. 
> 
>> You can create variables and loop through the found set, as you get to a new "group" (also tested by variables), display the subsummaries (any aggregates you want).
> Yes, as I thought about this, loops and variables to find a change in section/subsection came to mind. So thanks for confirming that idea.
> 
> 
>> You can display the details as well as the summaries. Make it a boolean setting and your report can change from only summaries to all items and summaries. 
>> 
>> Getting these into "headers" is much more complex than into footers, of course. Getting the labels is not so difficult, but any aggregates (totals, for example) are more complex to get into headers.
> 
>> 
>> Are you wanting only the labels for Section and Subsection before the list items in those groups?
> I can see why getting aggregate into headers would be more difficult.  Fortunately, for this application I just want the labels.
> 
> Thanks much for the feedback.
> 
> Gary
> 
> 
>> On 07 Dec 2013, at 12:35 PM, Gary Sprung wrote:
>> 
>>> Hi folks. I'm looking for some sample code to build a web page that works like a Filemaker subsummary report. Can anyone point me in the direction of some info on that? 
>>> 
>>> I have a list view page of Documents records. Each record is categorized with a Section and Subsection. I want to sort and group the records by those values and display the Section and Subsection only in sub-headers.
>>> 
>>> Thanks,
>>> Gary
>>> 
>>> ----------------
>>> Gary Sprung
>>> GNURPS Consulting
>>> Database and web development; photography & writing
>>> 
>>> Member, FileMaker Business Alliance
>>> Filemaker 12 Certified Developer
>>> FileMaker 10 Certified Developer
>>> FileMaker 9 Certified Developer
>>> FileMaker 8 Certified Developer
>>> 
>>> Boulder & Denver, Colorado
>>> 
>>> gary at gnurps.com
>>> www.gnurps.com
>>> 
>>> Landline: 720-565-9933
>>> Cell: 303-859-9331
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> --------------------- 
> Gary Sprung
> 3675 Aspen Court
> Boulder, CO 80304
> 
> gary at gnurps.com
> www.gnurps.com
> 
> Landline: 720-565-9933
> Cell: 303-859-9331
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list