Concatenate with return key

[Luvsql]

I have created a cross tab report with customers as rows and the months across the columns. I have concatenated two field to make the row header. However, it appears as:

CUSTOMERID CUSTOMER NAME


I would like it to place the first field, then the next field directly below it:

CUSTOMERID
CUSTOMER NAME

Also, in my summarized fields, I have 3 fields which display in each column:

sum(Qty)
sum(Cost)
sum(Price)

I would like to now create a formula based on these summarized values ie sum(Price)-Sum(Cost) but the summarized fields are not available in the formula editor.

 

[Luvsql]

Okay, I FINALLY found that chr(13) will pass a return to a formula, therefore putting my texts into 2 separate fields, but still can't get a new formula based off of the summarized cross tab values. It won't even let me insert anything without messing up the cross tab.

 

[lbass]

If you created a formula:

{table.price}-{table.cost}

...this formula should be available for summing in the crosstab.

-LB