Grouped data with count result

[joki1975]

Hi.

I have tree tables vendor, model and category

i try to make a rapport where the data is grouped by the vendorname.

under each vendorname the models is listet, and i need a field where the number of models under each vendor i counted.

Thanks

[-Queue-]

Create your report in the model table. Add a subsummary part by vendor and a summary field equal to the Count of model id. Put this field and the related vendorname in your subsummary part and be sure to sort by vendor when you view the report. This should give you the desired report in Preview Mode and when printing.