Ok thanks for your suggestions, it's fixed now. The report shows what we want.

But the report is not performing like we want, this is something that we have to...

I had to change my (insert into) for previous error, but now having this error:

"The select list for the INSERT statement contains more items than the insert list.

The number...

Thanks for your replay and your solutions.

I had invited a colleague to see how we can build like you suggested that meets our requirements, so we build it like...

I will discuss this with the department and tell them about it.

I'm so curious to see if it works but thanks anyways.

Thanks Pieter, yes would you please upload that report?

Thanks for the reply.

I have made some data export from my db (see attachment)

I have also adjusted some rows.

Maybe this gives you an idea...

The rows are from 3 tables...

Thanks for your reply, I fully understand your way of approach and to give me an idea, but I have to deal with table views of this department and I...

Thanks @SSC Eights! for the reply.

This is the query which I use for my dataset and I think this one meets my requirements.

But my issue is how to...