Left({field},1) in Report Designer

[Jon]

Hi,

In a report I wish to just use the first character of a string as a group by (like a phone book with everyone's name starting with A, B, C, etc).

To try and get it working I made a blank (ungrouped) report and then I dragged the database field onto the report. I then changed its Text property to: ".Left({ReportDatabase.Name},1)" the intellisense implies this will work, but it actually outputs: ".Left(Dave,1)"

Can anyone offer a solution?

Thanks,
Jon.

[Vital]

Please use following conditions:

Code: Select all

{ReportDatabase.Name.Substring(1)}