Cross tab report

[SueBK]

Could someone point me to a good site to explain how to set up a cross tab report? I found one, but I'm not quite following the code, so I'm not sure what bits of it I need to change to pick up my query.

My query returns a bunch of 'static' columns (name, rate, project code), and then a bunch of 'dynamic' columns (week numbers) in which the cell shows the number hours worked in the given week. Which weeks to return are controlled by query filter. In essence, the query returns the hours to be billed for the four (or five) weeks of the immediate past month.

The explanation site I found seemed to return on the dynamic columns (without any static columns). But maybe I'm just reading it wrong.

 

[HiTechCoach]

Could someone point me to a good site to explain how to set up a cross tab report? I found one, but I'm not quite following the code, so I'm not sure what bits of it I need to change to pick up my query.

My query returns a bunch of 'static' columns (name, rate, project code), and then a bunch of 'dynamic' columns (week numbers) in which the cell shows the number hours worked in the given week. Which weeks to return are controlled by query filter. In essence, the query returns the hours to be billed for the four (or five) weeks of the immediate past month.

The explanation site I found seemed to return on the dynamic columns (without any static columns). But maybe I'm just reading it wrong.

I have an example using a crosstab query:

Dynamic Report based on a Crosstab query

Since crosstab queries tend to be dynamic, that example handled that. If your crosstab has static columns, it will still handle it just the same. The nice thing about using the dynamic version of the report with the static columns is that if the columns every change, the report will still work.

What problems are you having?