Dynamic crosstab headers with multiple values

S

Stacey

Hi everyone, here is my dilemma.

I have the following fields:
client#
month
year
reqcount
revsum

I will be producing a report that will give me a 6 months rolling
information by client. The format will look like:

Client# month1_req month1_rev month2_req etc....

The problem is:
1. I need the report to sort the months in order and take into
consideration the rolling into a new year.
2. The report column headers need to automatically adjust to the new months.
3. Provide 2 value results (reqcount & revenue).

When I do the two independent crosstabs to make the one, the columns become
fixed on the report. Help please....I am in desperate need. Thank you.
 
P

PC Datasheet

The solution is rather complex. If you need outside help on this, contact me
at my emeial address below.
 
D

Duane Hookom

Search google groups on my name and "Mth0" to find a solution that uses
"rolling" months.

I also have a solution out there for multiple value crosstab queries.

If you can't find these, come back.
 
S

Stacey

Thanks Duane,
I got the multiple values to work in the crosstab but I have one last
question (hopefully). I used your example of creating multi-value crosstabs
but now my dates are out of order. The headers look like this:

April req April rev Aug req Aug rev .........
How do I get them in the proper order? Thanks for all your help, you are a
wealth of information!
 
D

Duane Hookom

You can set the Column Headings property to create the order the columns
display.
 
Top