Employee A 12345678 3 Basic NR NHS 37.5 January
Enhanced NR NHS 3.5 January
Enhanced NR NHS 10.66 January
Enhanced NR NHS 28.5 January
Overtime NR NP NHS 11.16 January
Employee B 45678912 2 Basic NR NHS 18 February
Employee C 45874587-2 4 Basic NR NHS 32.25 March
Employee D 99887766 3 Basic NR NHS 37 April
Enhanced NR NHS 2 April
Enhanced NR NHS 6 April
Employee E 11410567 3 Basic NR NHS 37.5 May
Enhanced NR NHS 3.25 May
Enhanced NR NHS 10.66 May
Enhanced NR NHS 11 May
Enhanced NR NHS 38.75 May
Overtime NR NP NHS 26.16 May[/CODE]
The first three columns in the summary have had the "supress duplicate values" box ticked. I want to do the same with the Note column on the right hand side but the box is greyed out.
I've tried playing around with varying results. Putting the notes column fourth from the left allowed me to tick the box and hid the duplicate values but made the report a bit harder to use. Adding a dummy field to the far right allowed me to tick the box but didn't hide the values.
I know it seems like a small point but keeping that column on the right and hiding the duplicates is the best layout for what I need! The whole idea of this report is to improve on the usability of its source.
A few details - All the fields are defined as key (I've played about with that too to no effect) and the Notes field is currently a calculated field that copies an external lookup field (when it was just a straight external lookup I didn't even get the 'displayed' tab in the field properties!)
If anyone can help I'd be very grateful.