Cross Tab

[strom99]

I have a cross tab that counts the number of invoices (INVC_NBR) for each month for the past 12 full months (INVC)BILL_DATE) I need to add two additional columns. One column that would count the total invoices for the previous year and one that would count the total invoices for this year to date. Any ideas?

-Thanks-

 

[kenhamady]

Unfortunately, you can't add columns to a cross-tab.

You can create a manual cross-tab that allows you to create as many columns as you want. A bit more work. See my FAQ on common formulas for info on manual cross-tabs and conditional totals. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)