Different Group Headings

[Guest]

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?

 

[Marshall Barton]

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.

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