running totals

[jomarelectric]

hello, all


is it possible to have running totals outside of my date parameter:

Monthly running total of payments (even though date parameter is between two given months: i.e., Feb 1 – Feb 29).

Totals Paymnt Totals Paymnt Totals Paymnt
Jan 1 – 31 Feb 1 – 29 Mar 1 – 31
0 -900.00 -2500.00

i pull this from a paid invoices tbl.

perhaps i need to use crosstabs.

as always, thank you.

 

[jomarelectric]

sry, cr10

 

[Madawc]

You can collect data from records you don't display, so long as they are selected. You could suppress the detail lines, or group them and use group selection.

You could also have a subreport in the report header or footer, with a different record selection. Inefficient but very easy to code.

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