crosstab issues

[pam1980]

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.

 

[pam1980]

Also I forgot to mention, that this is Crystal 11.

 

[lbass]

You need to show the fields you are working with. We don't know if you have one or multiple date fields. Please show the contents of all formulas you are using for opened, closed, and dispatched.

-LB