CMIS Timetable cell style expression

[SimAda00]

When making a timetable in CMIS, and you can alter the cell style, altering what information appears and so on. Is their any way to make an expression that shows the initials of the lecturers rather than their full names or codes?

Cheers

[kylewilliamson]

You could probablay get the firstname and lastname, and then use a function to limit the char length to 1.

However, why? It would be normal to refer to teacher's by the codes, which in alot of cases would be initials anyway.

[SimAda00]

I wasnt specifically given a why, how ever i am guessing as we are a university, all our systems are linked together by the username, so the code for lecturers is their username. Additionaly as most lectures names are quite long, i believe the registry thought if initials could be used it would make things slightly easier, and look better on the timetables.

[hmd01]

Did you manage to get this to work?
I was thinking that something along the lines of
fn Concat((left(Event.Lect.Single.Lect.Forename),1),( left(Event.Lect.Single.Lect.Surname),1))
ought to work, but I can't get it to. I can get the length function to work, but left and right just don't seem to work??

[SimAda00]

I have been fiddling around and had no joys as of yet

How ever i have noticed that as i use MSSQL server for CMIS the concat is called differently, You put a '+' between the two strings or expressions to concatonate

For example
(SELECT (LEFT('ABC',1))+ (SELECT LEFT('WXYZ',2)) returns teh value
'AWX'.

i think its just we are not sure how to refernece the fields in cmis properly, but im not entierly sure.,