Running Totals in Crosstabs

[dannyb29]

Hi All,
I am using Crystal 2008 and am trying to use a running total which groups the number of items sold each hour.

Currently it shows dates down the sides and hourly slots across the top.

0400 0500 0600 0700 0800 .... Total
20/04/2012 2 3 2 5 3 15
21/04/2012 2 1 4 4 1 12
22/04/2012 1 2 1 3 2 9

And i need it to show:

0400 0500 0600 0700 0800 .... Total
20/04/2012 2 5 7 12 15 15
21/04/2012 2 3 7 11 12 12
22/04/2012 1 3 4 7 9 9

Many Thanks

 

[Madawc]

Crystal has a 'flow', a fixed cycle that you have to slot your own code into. It isn't a full programing language: that's the price you pay for a software tool that can be used to produced a nice-looking report very quickly.

Running totals 'run' along with the final printing. Crosstabs work on data at the detail-line level.

I think you'll need to use a Mock-Crosstab. Have a running total for each hour, but it counts everything equal to or less than the hour.

Unless you also want to define every date, you'd need to put this in a subreport that groups by date, and just shows the group footer.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP