Need count of detail records printed within a group 1

[PhilB2]

I am suppressing detail records when the numeric id of the next record is the same as the current record and the current record contains a field with a particular value.

In the group section preceding the detail section, there is a summary count, but the count includes the suppressed records.

The report contains one group and its detail records per page.

Can you suggest a way of displaying a count in the group header, group footer or other footer on each page, that excludes the suppressed records?

 

[lbass]

Insert a running total that evaluates using a formula and put the opposite of your suppression criteria in the formula area. Set it to reset on change of group. Place the running total in the group footer.

-LB

 

[PhilB2]

Thanks, lbass. That worked!

 

[PhilB2]

I was able to use a text field into which I inserted two formulas, to format the total line as follows:

[group name] total: [running total]

Still, for future reference, I would like to know how to use the split operator or other technique to be able to get the same result as above using a formula: When I tried concatenating the group name and running total in a formula, I had to use toText({running total}), and got a decimal and two zeros.

 

[lbass]

If you are using formulas, there is no need to use a text box. You could just write the formula like this:

{table.groupfield} & ": " & {#runningtotal}

The ampersand allows you to concatenate fields of different datatypes. You can place the formula directly on the report. Using totext(), you can eliminate decimals like this:

totext({#runningtotal},0,"")

-LB