[FX.php List] Subsummary report web page

[Gary Sprung]

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