August 13, 200817 yr ok.. i did tried many times the layout/previews summaries... i just really would like a very simple report like follows.. a table: moo 3 0 moo 2 0 moo 1 0 moo 0 7 moo 0 2 foo 1 0 foo 0 7 foo 0 2 i want to get as a summary: moo 6 9 3 2 foo 1 9 1 2 where 6 and 9 are sums of all the values for moo in the second field of the table above (same for foo) and 3 and 2 is how man records are not zero... very, very simple... yet not with file maker... i tried that new layout/report menu many times back and forth with grouping and without and i couldn't make it do that... what's the easiest way to group records by field? thank you...
August 13, 200817 yr Summary fields will work fine for the totals. Summary fields for the non-zero values depends: if the zero fields are actually empty, then a Count summary field will work; otherwise, you need a calculation such as GetAsBoolean() and then a Total summary field based on that. Run the report script in the attached file and see if the light bulb goes on. summaries.zip
August 21, 200817 yr Author thank you... i just came back to this.... i'll test your script. will report.
August 22, 200817 yr Author it help a lot. i didn't realize that the summary parts have to have summery fields..... thank you.
August 23, 200817 yr i didn't realize that the summary parts have to have summery fields..... thank you. This is a hasty conclusion, not necessary correct: http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000752 --sd
August 30, 200817 yr Author i just refuse to believe what i just witnessed... i loaded some of the data that needs to be summed up by this summary layout - about 85000 records. over a local LAN to sort these records (file served using fms 9) it took about 15 min to get the preview layout. 15 freakin minutes!!! totally unacceptable. this is live data with hundreds if not thousands of records added every day!!! and i spent so much time on this filemaker set up. what am i doing wrong?!
August 30, 200817 yr here is another method - use a utility table to create the records needed just to display the data. Then you can clean up the records on exit. summaries.fp7.zip
Create an account or sign in to comment