Ask Your Question
1

display count of records on report

asked 2015-06-19 12:36:23 +0200

jay Arr gravatar image

updated 2015-08-25 10:43:58 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2015-06-24 08:42:11 +0200

pierre-yves samyn gravatar image

Hi

Set Pre evaluation to Yes. See RecordCount.odb

screenshot

Regards

edit flag offensive delete link more

Comments

Ah! NEVER would have found this - thanks!

jay Arr gravatar imagejay Arr ( 2015-06-24 12:40:11 +0200 )edit

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.

EasyTrieve gravatar imageEasyTrieve ( 2018-03-09 00:00:20 +0200 )edit
0

answered 2015-06-24 07:11:04 +0200

jay Arr gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-06-19 12:36:23 +0200

Seen: 998 times

Last updated: Jun 24 '15