Help with formating formula for crosstab

[WittyD]

Using cr 9.0 I am trying to format a column on a crosstab report. The column is based on a formula that displays two separate fields. Here is the formula:

"GSF: " & table.GSFTotal & " NSF: " & table.NSFTotal

All I want to be able to do is have a "return" in the middle of the formula so it displays on two lines. Is there a way to do this?

 

[jambu]

Try chr(13), like this

"GSF: " & table.GSFTotal & chr(13) & " NSF: " & table.NSFTotal

 

[WittyD]

That's right I remember now. Thanks!