grouping records with summary

[bobydick]

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...

[Fitch]

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

[bobydick]

thank you... i just came back to this....

i'll test your script. will report.

[bobydick]

it help a lot. i didn't realize that the summary parts have to have summery fields..... thank you.

[Søren Dyhr]

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

[bobydick]

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?!

[Ocean West]

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