Cross tab report

[grecon]

I am doing a cross tab report to show sales for years, so I have the customer name in the Row the column is the Order Invoice Date (grouped for year) and the sum field is the sum of invoice.item_total. My question is : How do I get it to show the account number with the customer name?? I don't want to add another row.

 

[lbass]

The presentation would be better if you did account number as another row. You can go into the customize style tab and highlight either customer or the account field and check "suppress subtotal". This will allow the customer and account to use only one "line" in the crosstab.

Alternatively, you could concatenate the customer name and the account number, but it won't look as neat:

{table.customername} & " " & {table.accountno}

-LB