Adding Fields that Will Exist in Future to a Report

[ertweety]

Hi there,

I have a report that runs off a crosstab. The report displays a list of employees by cost centre with their fte count by month.

e.g.

Cost Centre 211

Employee Name Jan Feb Mar Apr May Jun Jul
Jim Smith 1 1 0.5 1




Currently, the query has the first 4 months populated. I would like to set up the report so that the remaining months are in the detail section of my report without me having to add them every month. Is there a way to do that since the fields don't exist yet in my report?

 

[vbaInet]

Amend the PIVOT part of the Crosstab query's SQL statement to look like this:

PIVOT Format([DateField], "mmm") IN ('Jan', 'Feb', 'Mar', [COLOR=Red]... etc[/COLOR])

 

[ertweety]

Thanks for the help!

 

[vbaInet]

You're welcome!