Hello:
I need to make a report and I don't find the way to achieve this:
My querie has this fields and data:
sample:
[user] [date] [hour] [status]
-1- - 1/5- -9:00- -In
1 1/5 10:05 Break
1 1/5 10:30 Break
1 1/5 14:30 Break
1 1/5 15:30 Break
1 1/5 18:00 Out
...
An I need in this format in one line grouped by day and user
for example:
user -- date -- In --Break-- Break-- Break -- Break --Out
-1- ---- 1/5 --- 9:00 -- 10:05-- 10:30 -- 14:30-- 15:30 --18:00
-2 ---- 1/5 ...
-3 ...
I attach a document where you can see it better.
Can you help me please?
Many many thanks