I have a complicated problem.
The example is about trash collection routes, they each have a name.
I want to know how many addresses and how many products (trash containers) each route contains.
A product (trashcontainer) has a dotation id (meaning: green trash, paper, large, small)
In the word attachment you can see the relations of this problem in the database.
The number of addresses on a route is: count(distinct card_id)
The number of containers on a route is: count(product_id)
I wil attach the word doc, a sample qvw document.
I'll give you the qvd files if you guys need them.
I hope someone can help me!
Kind regards,
Katleen
