Creating report with varying number of columns

  • Thread starter Thread starter DVN
  • Start date Start date
D

DVN

I'm trying to create a report from a query that the amount
of columns vary from each time the module to create the
query is ran. We have this report that in the first column
list the device that failed. In the other columns, we list
the amount of failures per month. i.e

Device Jan'03 Feb'03 Mar'03
-------------------------------------
Diode 3 4 1
Bios 2 2 1
PBC 5 1 2

When the user runs the module, the user can select any
range of months (up to 18) to create the query. When I go
to create the report, I do not see a way to make a report
that will vary the columns. I know I can use a different
style of report but I prefer to stay with columns. Is
there a way to have the report vary the amount of columns
or do I have to write some kind of program to do it? Your
help is very much appreciated.
 
You will have to write some code. On my website (see sig below) is a small
sample database called "CrosstabReport" which shows you one way to do this.
 
Back
Top