ok i tried that it works as if i had no running total as a summarized field. In other words each cell counts how many new subs for that title that month instead of the accumulated amount for each month. See below...

The crosstab is reflecting the group numbers so i think the problem isn't the crosstab but how the running total is calculating the count of subs grouped by date then title.

Actually we got this to work. I did need the running total because we still wanted the cumulative total at a point in time (by month). The difference is we didn't need two groups just grouped on titles and used order date in our column in the cross tab grouping by month.

We had to throw in a sort at the report level by orderdate and that seemed to be the magic elixir. But we were unable to do running totals in cross tabs until today and couldn't have got this far without your help so much appreciated.

Actually just thought of something esle. The months were not new subs were added we are getting zeros in the cross tab instead of the cumulative total to that point. Seems strange. Any thoughts?


Edited by hcpro - 22 Apr 2009 at 11:27am

From my guesstimation... it seems like when there are no new subs (customer id's original data) or new rows during a month it wants to put a zero instead of the cumulative sum up to that point. So we are still counting our subs it is just that not every month we have a subscriber or customer for every title. Seems like crystal doesn't know what to do so it inserts a 0 in those cells. Looks like this... zeros are the months where there are no new subs.

	12/2005	1/2006	2/2006	3/2006
Administrator	636.00	657.00	663.00	######
Assistant Administrator	104.00	106.00	106.00	173.00
Attorney/Consultant	900.00	910.00	916.00	930.00
CEO, President, Chief Administrator, Exec Dir, Partner, Board Member	678.00	678.00	0.00	701.00
CFO, VP Finance, Finance Director	79.00	0.00	0.00	88.00