Count Rows On Last Page

[Steve]

The detail section of the report I am working on consists of a subreport.
The subreport has a single row record and an internal subreport below it.
When the report prints, you see a single record followed by multiple records
below it multiple times. So the total report has several single records and
below each are multiple records. I am trying to find a way to count the
number of rows (single records + multiple records) on the last page. Can
anyone help?

Thanks!

Steve

 

[John... Visio MVP]

The detail section of the report I am working on consists of a subreport.
The subreport has a single row record and an internal subreport below it.
When the report prints, you see a single record followed by multiple
records below it multiple times. So the total report has several single
records and below each are multiple records. I am trying to find a way to
count the number of rows (single records + multiple records) on the last
page. Can anyone help?

Thanks!

Steve

For a reasonable fee, I can help.

Steve

 

[Gina Whipp]

You have GOT TO BE KIDDING!!! You ignore the rules and then expect HELP for
FREE??????

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[James A. Fortune]

The detail section of the report I am working on consists of a subreport.
The subreport has a single row record and an internal subreport below it.
When the report prints, you see a single record followed by multiple records
below it multiple times. So the total report has several single records and
below each are multiple records. I am trying to find a way to count the
number of rows (single records + multiple records) on the last page. Can
anyone help?

Thanks!

Steve

Several minutes ago I posted in this NG:

http://groups.google.com/group/microsoft.public.access/msg/803b9e45ea891a5b

That technique should give you a way to find at least how many records
are contained in the multiple record parts. With Google not going very
far back it's difficult for me to provide a search string for posts to
determine at which record a page break occurs in the report or
subreport. Perhaps someone will jump in and help you with that. I
think I remember reading that reports use two passes to determine where
to make the page break. I don't remember the specifics and have not
experimented with it much because I usually output directly to PDF
format when I need that much control over the output process.

James A. Fortune
(e-mail address removed)

 

[Steve]

<<....provide a search string for posts to determine at which record a page
break occurs in the report or
subreport. >>

I am very interested in following up on this. Can you give me any ideas on
where to start googling on this?

Thanks!

Steve

 

[none]

I am very interested in following up on this. Can you give me any ideas on
where to start googling on this?

What percentage of your modest fee can I expect in return for helping you?

 

[Steve]

Keith Wilby. Afraid to show your name? And you don't offer the OP any help.
This just proves that you are nothing but a low life stalker.

 

[James A. Fortune]

<<....provide a search string for posts to determine at which record a page
break occurs in the report or
subreport. >>

I am very interested in following up on this. Can you give me any ideas on
where to start googling on this?

Thanks!

Steve

Some have suggested using the Advanced Groups Search feature of Google
Groups:

http://groups.google.com

click on 'Advanced Groups Search'

Group Return only messages from the Group at this location
group:<NameOfGroup>

but I still find Advanced Groups Search quite inferior to the way Google
searched before using a larger set of posts. I tried:

all these words: page break report

and got:

Your search - page break report
group:groups.google.com/group/comp.databases.ms-access - did not match
any documents.

The most recent CDMA post on the topic seems to be:

http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/ba3ce5d27dd27cd8

Maybe more general search engines such as Google Search or Bing can help
you to find sites that have archived older NG posts. Let us know if you
find such a site containing a reliable search engine.

You can also do some experiments by looking at the properties of the
Detail sections, subreports, controls, footers, headers, etc.,
especially the Height property, along with the report margins and some
estimate of padding to see if you can figure out how Access determines
page breaks. Please post the results if you discover something
interesting. I poked around on MSDN and didn't see any documentation
about the algorithm Access reports use to determine page breaks after a
cursory search. Also, I recall that subreports treat the display (or
lack of display) of things like subreport header information differently.

James A. Fortune
(e-mail address removed)

 

[Keith Wilby]

Keith Wilby. Afraid to show your name? And you don't offer the OP any
help. This just proves that you are nothing but a low life stalker.

Not at all. I'm simply finding my way around Linux and a new news reader.
You however are still an idiot.

 

[Keith Wilby]

And that idiot is still becoming *very* famous these days...
174 pageloads last week.... 100 unique visitors

Nice work Arno. Quite why $teve thought I would consider helping the "OP"
in this thread remains a mystery.

Keith.