I've got a db which stores employee details, hours worked for different company departments, the different rates of pay each dept pays and want a report showing each employee and pay for each department inside a certain pay period.
I've created a cross tab query (as per attached screen shot). The pay per catagory is calculated using an expression in the query which seems to work correctly. Where I'm stuck is simply that I want the query to show each employee on a single line with entries against all the different departments. As you can see each entry is currently showing up on a different line which despite trying to play with the group by setting I can't get round.