Vertical Alignment in Crosstab 1

[hoagieryder]

I am trying to get a value vertically aligned within a crosstab. I am using this formula in the Display String formula under format field:
replicatestring(chr(13),1) + cstr(currentfieldvalue)

This works fine when the value is a string, but when it is a number its is returning #########

Any ideas?

 

[northw]

Try expanding the field size.

 

[hoagieryder]

That is not the problem. When I expand the field the number is returned, but not on the next line. It appears that it is pushing the text the value to right the within the cell rather than returning it on the next line.

 

[lbass]

You don't need to use replicatestring if you just want one return--just use chr(13)--although it doesn't hurt and this isn't causing the problem either.

I see that this problem occurs in the inner cells of the crosstab, but not for labels. Instead of this approach, you could add an additional summary as your first summary field, and then suppress it.

-LB

 

[hoagieryder]

Adding an additional summary worked great, thanks LB.