+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, CMIS Timetable cell style expression in Technical; When making a timetable in CMIS, and you can alter the cell style, altering what information appears and so on. ...
  1. #1
    SimAda00's Avatar
    Join Date
    Jan 2007
    Location
    Coventry, WM, UK
    Posts
    73
    Thank Post
    10
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    CMIS Timetable cell style expression

    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

  2. #2

    Join Date
    Jan 2007
    Posts
    423
    Thank Post
    7
    Thanked 30 Times in 26 Posts
    Rep Power
    21
    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.

  3. #3
    SimAda00's Avatar
    Join Date
    Jan 2007
    Location
    Coventry, WM, UK
    Posts
    73
    Thank Post
    10
    Thanked 3 Times in 3 Posts
    Rep Power
    16
    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.

  4. #4

    Join Date
    Nov 2007
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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??

  5. #5
    SimAda00's Avatar
    Join Date
    Jan 2007
    Location
    Coventry, WM, UK
    Posts
    73
    Thank Post
    10
    Thanked 3 Times in 3 Posts
    Rep Power
    16
    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.,

SHARE:
+ Post New Thread

Similar Threads

  1. Installing Microsoft Expression Web
    By srochford in forum How do you do....it?
    Replies: 11
    Last Post: 12th August 2008, 01:36 AM
  2. C# Help - Datagrid cell formatting
    By Gatt in forum Coding
    Replies: 6
    Last Post: 22nd July 2008, 08:33 PM
  3. Cell Phone signal.
    By laserblazer in forum General Chat
    Replies: 10
    Last Post: 27th June 2008, 09:12 AM
  4. CMIS - TA's Timetable
    By mark80 in forum MIS Systems
    Replies: 3
    Last Post: 25th April 2008, 02:12 PM
  5. Excel Cell colour changes
    By wesleyw in forum How do you do....it?
    Replies: 3
    Last Post: 20th December 2006, 10:01 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •