Cannot format the crosstab node member. I have datetime field (datasource sqlserver 2005) on this node. Tried to format to short date and short time, but does not work.
Does anyone know how to format the date on crosstab node member? The problem is cognos adds the datetime to millseconds.
Thanks in advance