columns in crosstab reports

Did you create a report that looks like a crosstab, or did you insert a crosstab in the report?
If it is the latter, on which fields have you grouped the columns?

--
Outin

Inserted crosstab into report.  Report is grouped by patient id.  Crosstab is in patientID header.  Crosstab columns are:
Date of Visit
Visit Type
Visiting Nurse ID

Rows are:
Question group
Question number

RB

It sounds like you're saying you want to see a column on the crosstab even though your dataset doesn't contain data for that column - is that accurate?  If so, the answer is that you can't do it - you'll have to do a join to a dummy table to supply data in order to see that column.

The dataset does contain data for the column in some cases.  Depends on whether the patient had 1, 2, 3 up 6 wounds. It should look like what's below.  It is pretty close in terms of formatting but the 2nd wound for Mary does not show.  My crosstab intersection or summary field is MaxValue for the answer field.  I think that is why it is only showing one column.  Is there another way to use the summary field for a text value?

BTW the wounds are not really numbered 1,2,3 etc.  They are in fields called WOUND1LOC , WOUND2LOC, etc.  If there is only one wound there will be a record for the patient with an answer in the WOUND1LOC but there will not be a record for that patient with the field WOUND2LOC.  Every answer is a seperate record.


                   
                   6/1/2006                        6/1/2006
                  John Smith                    Mary Jones
wound #          1                             1                     2
Location         arm                           leg           shoulder
Question2      answer                     answer       answer
etc.

Below is an example of 1 visit 1 patient 2 wounds showing 7 records per wound - this number acutally varys between 5 and about 15 depending on which questions are asked for each wound.  

AssSys      AssItmSeq      QID                      Des                     QSeq
43      4      WOUND1DEP         Depth of Wound (1)      1
43      4      WOUND1LEN         Length of Wound (1)      1
43      4      WOUND1TYP         Type of Wound (1)      1
43      4      WOUND1TYP         Type of Wound (1)      3
43      4      WOUND1TYP         Type of Wound (1)      8
43      4      WOUND1WID         Width of Wound (1)      1
43      4      WOUND1CLOS        Wound Closure (1)      5

AssSys      AssItmSeq      QID                      Des                   QSeq
43      6      WOUND2DEP         Depth of Wound (2)      1
43      6      WOUND2TYP         Type of Wound (2)      8
43      6      WOUND2CLOS        Wound Closure (2)      2
43      6      WOUND2LOC         Location of Wound (2)      1
43      6      WOUND2TYP         Type of Wound (2)      4
43      6      WOUND2TYP         Type of Wound (2)      6
43      6      WOUND2CLOS        Wound Closure (2)      1

I hope I'm giving enough info here without overdoing.  Thanks for the help so far.

RB

kmarf  - In the future please post only the link to the article (as you did).  It may be copyrighted and therefore EE doesn't want it posted.

thanks
mlmcc

What finally did work was a combination of #2 and #4.  I hard coded the sequence numbers since they don't change very often.  It forces the crosstab to give me all the info I need but instead of 2 columns for 1 person I have two groups, i.e. 2 groups of rows which show separate wound numbers instead of columns.  This actually works really well since it keeps each one separated across the date columns.

Thanks for your help and the link to Ken Hamady's site - that will come in handy in the future.

RB