Running total field inserted but does not display on run

[dinshak]

I have inserted a running total field on the sub-report but it does not display when I run the report.

There are other running total fields on the sub-report that display porperly.

I am new to this and am working on a previously created report. Any help is appreciated as to why this running total field does not display the value when all others do.

 

[beltmanjr]

So, what does the running total do?
What are the restrictions, on what does it evalute etc?

 

[dinshak]

Field to summarize:
Result.Formatted_Entry

Type of summary:
maximum

Evaluate use a formula:
InStr ({RESULT.REPORTED_NAME}, 'TSA Lot') > 0

Reset on change of group:
Group#3: @Pos2-A

 

[Madawc]

Where is it placed? Unlike a summary, a running total accumulates values at the same time as detail lines are printed. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

It also helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


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

 

[dinshak]

it is placed in the group footer

 

[Madawc]

Do a test version with an extra display lines, and put the running total there. This will show exactly where the problem occurs.

You could also put the formula in a formula field, this would make it a Boolian, returning True or False and this can be displayed.

I'd have done the test as

"TSA Lot" in {RESULT.REPORTED_NAME}

Or even

{RESULT.REPORTED_NAME} LIKE "TSA Lot"

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