I have "Subcontract" (Row), The data in the "Compliance Code Type" make the Column Headings.   When I use these two I get the perfect Row and Column Heading but I want the summary data to be the actual data in the field, NOT a summary of the field. So one table is used to make up the heading and another table associates the row with the heading to give the data. This seems so simple to me but I cannot figure out how to do it.


            CompCode#1 CompCode#2 CompCode#3
Subcon#1      6/17/07       no        maybe

Subcon#2      6/5/07        yes        no

I just got done writing about this in my book. To display text in a cross-tab, you need to use the Display Text property in the Format Crosstab dialog box. Next to it is a formula button where you can enter a conditional formula. You need to use GetRowColumnHeader() function (or something like that) to find out which row and column you are on and then put in your text field when necessary. Look at the part of my cross-tab chapter that I posted online for free. It goes into some discussion about the formulas you will need to make this work. It won't be easy (you are effectively manually building your own cross-tab data), but it is very possible.