Unbound Column Headings

[Anne]

I'm trying to create a report from a crosstab query where the column headings
will be dynamic. The data table has 4 fields:
site- text
discipline-text
studentName- text
Diagnosis- text

First I'm counting the amount of times the same diagnosis occurs by
site/discipline/student in a make table query. Then I'm using this table
in a cross tab query to pivot the students as the column headings. I now
need to create a report with unbound column headings to handle the different
students that will occur within different site/disciplines. The # of column
headings will change as well so I need the report to be flexible. I was
reading some other discussions but was not able to open the links from Duane.
Any help would be really appreciated!!!

 

[Duane Hookom]

Check the Crosstab link at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Anne]

Thanks for replying Duane. In your example you choose how many column
headings you need. In my problem the amount of column headings will be
determined by the # of students within a site/discipline (a range of 1-12.)
So I think I need a report that has unbound dynamic column headings and
details. I have a cross tab query that works fine showing the student's names
as the column headings and the detail works ( counting the diagnosis), but I
don't know how to write a report that will show the correct student names as
column headings and data when they are changing all the time. Do you know
how to do this?

THanks-Anne

 

[Duane Hookom]

First, you will have a maximum number of columns dictated by the width of
your page. Set this as your number of columns generated by the crosstab. My
solution dynamically creates column headings and will create 1, 2, 3, ...
100 column headings if necessary based on your data.

 

[Anne]

Let me take some time to really look through it. What was your column
headings drop down list for?

 

[Duane Hookom]

What was your column headings drop down list for? Demonstration purposes
only.

The code is a bit tricky to figure out. I think there is a table in the
database that explains how it works.