can i do this in a report??

[mmonsalveg]

hello ... i want to know if i can do the follow in a filemaker report.

1: this is how my portal looks

portal

2:this is how my report looks

report

now if you see in the report ... 2 customers order ref 1010 so the report shows me 2 lines ... if 10 customer order ref 1010 it will shows me 10 lines with that ref ... what i want is a report that shows all the references using one line per reference making totals....

thanks for your help

Mauricio Monsalve

[mr_vodka]

This could be done with a straight subsummary report grouped by the ref field. Try using the wizard to create it. If you have issues, then come back and post what they are. Keep in mind that the records will need to be SORTED as part of the script steps.