I've question about the layout with the results of a query (dataset)
Image Query.png shows the query in the dataset
Image Results.png shows the results of the query
Image Wannahave.png shows how I like to have this
Explanation (this example):
Data from two databases are combined and give result (or NULL if not exists)
Because there are 3 results for Description, Status and Score (PURPLE), the results for Customer, Contract, Component_Value (BLUE) are repeated.
I'dd like the results where Component Value is summed, but only for the 4 original value's and not for all the component values because everything is tripled.
I've tried several things, but no luck.
Can I do this in the Report? Or do I have to change my Query?