Hi,
I have an Advanced HTML/PDF Print out based on a saved search which is pretty much perfect for my requirements.
However, the user specified the layout as the following:
Department Clock No Employee STD Hours Days Breaks ADJ STD WAGE OT WAGE GROSS WAGE
I have set up most of this to work perfectly, the departments are grouped to show the staff in that area, however the specification is for the following
Department Clock No Employee STD Hours Days Breaks ADJ STD WAGE OT WAGE GROSS WAGE
dept name 383 Name 35 5 2 333 10 1000
387 Name 35 5 2 333 10 1000
373 Name 35 5 2 333 10 1000
dept totals x x x x x x
dept nam2 388 Name 35 5 2 333 10 1000
384 Name 35 5 2 333 10 1000
371 Name 35 5 2 333 10 1000
dept tot2 x x x x x x
I have got all of this to display however it looks like the below, I myself and the end user are not overly keen on the repeating of the department name like so:
Department Clock No Employee STD Hours Days Breaks ADJ STD WAGE OT WAGE GROSS WAGE
dept name 383 Name 35 5 2 333 10 1000
dept name 387 Name 35 5 2 333 10 1000
dept name 373 Name 35 5 2 333 10 1000
dept totals x x x x x x
dept nam2 388 Name 35 5 2 333 10 1000
dept nam2 384 Name 35 5 2 333 10 1000
dept nam2 371 Name 35 5 2 333 10 1000
dept tot2 x x x x x x
Is there a way to only show the department once on the first row, then not show it again?
I have tried to do this with IF ELSE and sat for ages trying to figure the logic but just can't get it to work.
The total section at the end of the department works in a similar way, it is created when the next department field is different. But I cant seem to figure a way to get this to work to put the dept name at the top and not repeat until change,
Any ideas appreciated.