livereport returning email addresses from the users table, hyperlinked

Michael_Ioannides

Hi,I have a livereport to create our directory of staff from the Livelink user accounts.The columns are Name, Telephone, email , etc.Can I make the email field hyperlinked so when a user clicks on it, it opens a new email with the email address filled in ?Thank you,Michael IoannidesP.S. We do not have "webreports".

Michael_Ioannides

after a lot of experiments, here is the solution I have done: select DataID, isnull(LastName,'') + ' ' + isnull(FirstName,'') + ' (' +Kuaf.Name+')' as Name , isnull(Contact,'') as Phone, IsNull(MailAddress,'') as Email, 'guy.gif' as Gif, 140 as SubType, 'mailto:' + IsNull(MailAddress,'') as exAtt1, null as PermID, 0 as reserved, 0 as reservedBy, IsNull( OfficeLocation, ' ') as "Office" from KUAF, Dtree where Type=0 and Deleted=0 and LastName>' ' and UserPrivileges <>14 and (Kuaf.GroupID = 187970) and /* the base group of the users we want to show as staff */ DataID = 8908882 /* this is a URL object (any one with the same permissions as the report ) */ order by LastName---------------------Michael Ioannides