Hi Guys,
in my report i have a cross tab placed in a group footer. i need to place the columns in a certain order, so i concatenated letters in alphabetical order with the column header into a formula (@SortedSizes)
formula looks like this :
Code:
select {@order}
case 10:
"A-"+{fieldName}
case 20:
"B-"+{fieldName}   //... and so on
so they display in the correct order.
but i needed to hide the "A-" so i set the display string format to
Code:
RIGHT({@SortedSizes},LENGTH({@SortedSizes})-2)
but now all the columns headers are displaying the value in the last column


thanks for any suggestions