dynamic crosstab report

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I would like to generate a crosstab report from a table
that contains attendance history. I have successfully
created a crosstab query and I would like to put this into
a report. The problem I face is that the # of columns from
the crosstab query may vary (depending on the date range
supplied).

My question is if anyone has an example, suggestion, idea,
or comment please reply. I also did some searching and
apparently there used to be a sample database called
"Solutions9.mdb". When I go to the link to download the
file at MS website there isn't a link. If anyone has this
sample db please let me know where I can get it. Thanks!
 
I think the various methods/solutions at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4 are much more flexible
and more efficient than those in the Solutions.mdb. Actually, if you have
date increments as column headings, it is much easier to create relative
date columns and fix the number of columns returned. If you need reports for
either 6 months or 12 months, these should be two different reports.

You can search google on my name "relative dates" to find some solutions. If
you want more help, come on back with your current SQL.
 
Back
Top