Selective running total in a cross tab v10

[mabis]

I am running v10 CR on top of SQL Server 2000. My cross tab counts the number of phone calls made based on a result code (rows) which is the history.result field. My columns are based on date using history.completeddate. Some sample date from both fields are as follows:

history.result
21 RDC Complete
6 SSC VM
5 SSC Received

history.completeddate
8/4/2006 8:39:23 AM
8/4/2006 9:02:51 AM
8/4/2006 9:10:34 AM

currently my crosstab summarizes the total for each column. This is good. I need this date.

However, I also want to be able to offer a total field at the bottom of the cross tab for only selected history.results added together. For example:

where history.result = 6 SSC VM or 5 SSC Received, add the daily totals together for these two history.result codes and add it as a total at the bottom.

I have attempted to create it as a formula and add it to the "summarized fields" in crosstab expert but what I get is an additional field in each cell instead of a running total at the bottom only.

I appreciate any help you can offer. Thank you, mabis

 

[Madawc]

As a work-round, you could manually create a row of totals in a section below the crosstab

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

If you want the conditional summary at the bottom, then you will have to have an additional summary in each cell. Just suppress the summary in the inner cell, and then drag the edges of this summary to minimize the height.

-LB