Display count of records on report

Using LO Version: 4.4.3.2 & OSX 10.10.3

How do I display a simple record count of the records on a report ?

I’ve tried creating a text box in both the page header & the page footer
with the data tab visible setting the data field type to COUNTER
the scope then automatically sets to REPORT. When I execute the report
the field displays 1 - there are 7 records in the report ?!?

What am I doing wrong?

Hi

Set Pre evaluation to Yes. See RecordCount.odb

Regards

Ah! NEVER would have found this - thanks!

Wow, also a huge speed difference. I have a report with with 3 levels of grouping and 10 accumulations (various sub totals). It had gotten extremely slow at both producing the report (just a single page correctly), and also saving the report design edits. After changing all function Pre evaluation properties from the default Yes to No, suddenly all of the slowness went away.

Fixed it … sort of but NOT very satisfactory

My report had these sections:

Page header

Header

Detail

Page footer

With the menu EDIT → INSERT Report Header/Footer these change to:

Page header

Report header

Header

Detail

Report footer

Page footer

Now I can insert into the report footer a text box and using the DATA tab properties
change the Data field type to COUNTER which sets the scope to REPORT automatically and counts the records correctly.

This gives me what I want BUT not where I want it, which is in the Page Header - there it gives 1.
I’m guessing this is because this is a single pass report generator (and not a double pass like Access).

So if anyone can help with a suggestion of how I can get the record count in the Page header I’d be most greatful.