Choosing fields to display in a report using parameters

[Janeski]

I have a table of projects (rows) with monthly workload in columns e.g. 2015-06, 2015-07, etc. Each time I run the report, I only want to include fields for the current month and the following 5 months i.e. 2015-06 to 2015-11. I have got as far as asking for the parameters 'Current Year' and 'Current Month', but I don't know how then to apply these parameter values to select the appropriate field as the starting point e.g. 'Current Year' = 2015 and 'Current Month' = 06, so select field '2015-06' and then select the next field using 'Current Month' + 1 e.g. 2015-07, etc.?

[ranman256]

You cant really make reports using crosstabs because of the changing columns.
The EASIEST way is take the exisiting report ,saveAs , then modify it to the new query.
but I made an attempt to make a fluid, self correcting report via code.
Since its advanced code, it may be of no use to you, but you can look.
dynamicHdrDb.zip

[nick404]

query criteria : Between [Start Date] And [End Date]
have your year-month be entered as one field

[June7]

Is this a CROSSTAB query? Creating a stable report to run perpetually based on crosstab is not easy but is doable. Review http://allenbrowne.com/ser-67.html

If you are actually working with a non-normalized table structure, then a report with dynamic fields would be even more complicated. Instead of a table with field for each fiscal year data, should be a field for the data and another field for the year identifier (or calc the fiscal year in a query using a record date field). Then use that table/query as source for a CROSSTAB query with filter parameters on the year identifier field.