Different Group Headings

N

Nikki

Hi,

I am trying to create a report that lists all employess phone details. I
have created a report that has 5 columns that run down and then across the
page and each column is grouped by first letter of their last name. I have
added a heading at the top of each group but they all say 'A'. Is there a
way I can change the heading for each group to say the correct letter eg. 'A'
then 'B' then 'C' etc. I have added the heading to the Group Header section.

Any ideas?
 
M

Marshall Barton

Nikki said:
I am trying to create a report that lists all employess phone details. I
have created a report that has 5 columns that run down and then across the
page and each column is grouped by first letter of their last name. I have
added a heading at the top of each group but they all say 'A'. Is there a
way I can change the heading for each group to say the correct letter eg. 'A'
then 'B' then 'C' etc. I have added the heading to the Group Header section.
Click to expand...


Use a text box with the expression:
=Left([employeename], 1)
in the group header.
 
Top