Dynamic crosstab headers with multiple values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
The solution is rather complex. If you need outside help on this, contact me
at my emeial address below.
 
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.
 
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!
 
You can set the Column Headings property to create the order the columns
display.
 
Back
Top