crosstab issues

[pam.1980]

Hello,

I need to provide monthly count of opened and closed issues along with a count of issues dispatched to resolution queue.

I am able to add the date field and group by month in the column section fine.

The problem is that when I add more than one field in the row section, it does not display right.

So that the rows are labeled correctly, I have created formulas where:

Formula - Opened = Date Created
Formula - Closed = Date Closed
Formula Dispatched = dispatch table can have multiple dispatches, I am only interested the "dispatch for closure" and I think I can work on that formula with max date etc.

How do I display the following:


Jan 2012 Feb 2012 and so on

Opened 10 20
Dispatched 8 15
Closed 6 12

In the Summary section, I just want to pull the 3 fields and do a distinct count.

My crosstab can only accept either one of the fields in the rows.

What am I doing wrong.

[hensa22]

could you show us as your report is designed?

[pam.1980]

Thanks for your response. This is on hold for now but when it is resuscitated, I will figure out a way to include the report and code.
Thanks,
Pam