Hi All
I tried using TRIM functrion for removing the spaces from the live-report results since when the results are copied from live report web page to an excel it has got spaces.
For e.g select LTRIM(name), LTRIM(dataid) from Dtree---it gives me results with spaces as well.
When i use trim(name) live-report engine tells me it is not supported.
I am using SQL 2008 as the DB server.
Thanks,