[AccessD] Dynamic Report Based on Crosstab Query

I did this years ago.  I saved the data into Year01 thru Year10 field names.  I then generated a 1 record table for the label with
Year01 data equalling 2002, Year2 = 2003, etc.

I then had a subreport that linked to the 1 record table for the report labels.

My big problem was realizing I had to force one blank or zero record for every crosstab combination.  If not got a big mess.

Tom



----- Original Message -----
From: "Myke Myers" <mmmtbig at bellsouth.net>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, January 29, 2003 12:03 PM
Subject: [AccessD] Dynamic Report Based on Crosstab Query


> I have developed an app that uses reports based on crosstab queries.
> Each report looks like a spreadsheet, with a 10-year range of FYs in
> columns across the top. The first column (the "Base" year) has a label
> in the header called 'FY 2003', a textbox in the detail section with a
> control source of '2003', and a total textbox in the footer with a
> control source of ' =sum([2003]). Each column shows the next FY up to
> '2012'.
>
> The client wants to be able select the Base year -- for example, 'FY
> 2004', and have the report dynamically show columns FY 2004 - FY 2013.
> Before I spend several hours writing some code to change the columns in
> the report open event, I want to know if anyone has a better solution.
>
> TIA,
> Myke
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd