multiple identical sql queries in report

And it looks like your Number of Staff is not a proper measure, meaning it is not defined with a SQL aggregate function such as SUM or COUNT in the SELECT portion of object properties in universe designer.

Note: I am not talking about: projection althought SQL aggregation and projection go hand in hand, see this post here please.


Andreas :de: (BOB member since 2002-06-20)