Cross tab. Cumulative totals? 1

[coffee123]

Problem

Cross tab with a sum of a field.

I need it to do a cumulative total to the end of the period.

Ie sum(field1) + (field1) for the different date ranges.

Iv tried to use a formula but the formula field does not appear in the "selectable report fields"

got any ideas? or is it best to do some fancy sql in the store procedure?

thanks
coffee123

 

[kenhamady]

You can't reference cross-tab cells in formulas. You will need to create a 'manual' cross-tab described in faq149-243. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com