[2k7] Is it possible to create a group based on the page number ?

  • Thread starter Thread starter AlexT.
  • Start date Start date
A

AlexT.

Folks

I'm trying to create a report group based on the page number. Is this
possible ? If so what syntax should I use (I have tried [page], me.
[page]) ?

Thanks

..-alexT
 
Report sorting and grouping can only be based on expressions that can be
resolved in the report's record source query. You would not be able to get
the "Page" unless you knew exactly how many detail records would appear on
each page.
 
Report sorting and grouping can only be based on expressions that can be
resolved in the report's record source query. You would not be able to get
the "Page" unless you knew exactly how many detail records would appear on
each page.
Click to expand...

Aha... you would go for a record counter and group on that ? Hmm...
unfortunately my detail section is not fixed width...

Thanks for the suggestion, though.

-AlexT
 
AlexT. said:
Folks

I'm trying to create a report group based on the page number. Is this
possible ? If so what syntax should I use (I have tried [page], me.
[page]) ?

Thanks

.-alexT
Click to expand...

You can't do so. I can't imagine a valid need to do so. Perhaps if you
will explain what you are trying to accomplish with such a grouping, someone
could offer a suggestion for a useful alternative.

Larry Linson
Microsoft Office Access MVP
 
Hello
You can't do so.  I can't imagine a valid need to do so.  Perhaps if you
will explain what you are trying to accomplish with such a grouping, someone
could offer a suggestion for a useful alternative.
Click to expand...

You might be right that I am probably not taking the problem with the
adequate biais...

What I would like is a "double" floating page footer, i.e. a page
footer that prints directly after the detail section regardless of the
amount of data in the page.

Typically I have a page footer that prints at the end of every page
with items such as current page number. Works fine, no brainer.
I also want to have per page totals that print directly at the end of
the detail section. If I have 3 records in the report I want my totals
just after those records, not at the bottom of the page with the other
"standard" footer items.

How would you do this ? My "natural" answer would have been to create
a group based on the page number so that when the page changes the
group footer would print just after my data, regardless of the footer.
Apparently this is not the right approach...

Any help / suggestion most welcome.

--alexT
 
What defines pages in your report? Aren't your records grouped by a value in
a field? If so, you should be able to use a Group Footer section.
 
What defines pages in your report? Aren't your records grouped by a value in
a field? If so, you should be able to use a Group Footer section.
Click to expand...

Just duping record one after the other and new page starts when the
previous is full.

I might want to try an "artificial" group to generate a group footer
and programmaticaly hide the totals from the last page footer while
retaining the other footer elements... Hmmm.... might work.

Surprised that Access doesn't have a built in feature to achieve what
seems to be a reasonably simple requirement...

--alexT
 
I can't imagine why this would ever be a requirement or specification in any
application.
 
Hi AlexT,

Sorry about not getting back to you as I'm busy with a urgent work.
Click to expand...

No problem at all - your help and accompanying suggestion are most
appreciated. I have implemented it and it works like a charm !

Thanks again

--alexT
 
Back
Top