Left({field},1) in Report Designer
Posted: Thu Feb 15, 2007 8:16 pm
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.
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.