A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multiple instances of a report on the same page



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2004, 03:28 AM
Chris
external usenet poster
 
Posts: n/a
Default Multiple instances of a report on the same page

My technical manager is asking me a tabelar report with header and footer.
For every change of each one of 2 of the parameters from rhe header, he
wants a new instance of the report on the same page (not on a new page, so I
can't use "force new page").
Every tabelar report must have a fixed number of lines(7), even the lines
with data are less than 7.


  #2  
Old June 1st, 2004, 07:29 AM
Chris
external usenet poster
 
Posts: n/a
Default HELP!!! Multiple instances of a report on the same page

Didn't anybody read this cry for help? Or nobody wants to answer?
Chris" wrote in message
...
My technical manager is asking me a tabelar report with header and footer.
For every change of each one of 2 of the parameters from rhe header, he
wants a new instance of the report on the same page (not on a new page, so I
can't use "force new page").
Every tabelar report must have a fixed number of lines(7), even the lines
with data are less than 7, and the lines must have grid.




  #3  
Old June 1st, 2004, 12:08 PM
Brendan Reynolds
external usenet poster
 
Posts: n/a
Default HELP!!! Multiple instances of a report on the same page

I don't understand the question, Chris. I can't imagine what "a new instance
of the report on the same page" might mean. To my way of thinking, pages are
"inside" reports, not the other way around, you can't have reports within a
page, you have pages within a report.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"Chris" wrote in message
...
Didn't anybody read this cry for help? Or nobody wants to answer?
Chris" wrote in message
...
My technical manager is asking me a tabelar report with header and footer.
For every change of each one of 2 of the parameters from rhe header, he
wants a new instance of the report on the same page (not on a new page, so

I
can't use "force new page").
Every tabelar report must have a fixed number of lines(7), even the lines
with data are less than 7, and the lines must have grid.






  #4  
Old June 1st, 2004, 01:15 PM
Chris
external usenet poster
 
Posts: n/a
Default HELP!!! Multiple instances of a report on the same page

Sorry! I ment to print on the same A4 paper sheet more consecutive pages of
a report (smaller then A4)till the A4 paper sheet is over, and then to
continue on the next paper sheet with the next page of the report, and so
on.
OR to print on the same A4 paper sheet more times the same page of the
report.
The report it is all about has header, body and footer with data in all of
them..

Can you help me?

"Brendan Reynolds" brenreyn at indigo dot ie wrote in message
...
I don't understand the question, Chris. I can't imagine what "a new

instance
of the report on the same page" might mean. To my way of thinking, pages

are
"inside" reports, not the other way around, you can't have reports within

a
page, you have pages within a report.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"Chris" wrote in message
...
Didn't anybody read this cry for help? Or nobody wants to answer?
Chris" wrote in message
...
My technical manager is asking me a tabelar report with header and

footer.
For every change of each one of 2 of the parameters from rhe header, he
wants a new instance of the report on the same page (not on a new page,

so
I
can't use "force new page").
Every tabelar report must have a fixed number of lines(7), even the

lines
with data are less than 7, and the lines must have grid.








  #5  
Old June 1st, 2004, 02:36 PM
Bruce
external usenet poster
 
Posts: n/a
Default HELP!!! Multiple instances of a report on the same page

If I understand what you need to do, I think you could
accomplish it by grouping the report and using group
header and footer. If this does not help, additional
details about what you need to do would help. For
instance, is there one record or multiple records between
each header and footer? In other words, are the seven
lines several records, or just one?
-----Original Message-----
Sorry! I ment to print on the same A4 paper sheet more

consecutive pages of
a report (smaller then A4)till the A4 paper sheet is

over, and then to
continue on the next paper sheet with the next page of

the report, and so
on.
OR to print on the same A4 paper sheet more times the

same page of the
report.
The report it is all about has header, body and footer

with data in all of
them..

Can you help me?

"Brendan Reynolds" brenreyn at indigo dot ie wrote in

message
...
I don't understand the question, Chris. I can't imagine

what "a new
instance
of the report on the same page" might mean. To my way

of thinking, pages
are
"inside" reports, not the other way around, you can't

have reports within
a
page, you have pages within a report.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in

making it impossible for
me to use a real e-mail address in public newsgroups. E-

mail replies to
this post will be deleted without being read. Any e-

mail claiming to be
from brenreyn at indigo dot ie that is not digitally

signed by me with a
GlobalSign digital certificate is a forgery and should

be deleted without
being read. Follow-up questions should in general be

posted to the
newsgroup, but if you have a good reason to send me e-

mail, you'll find
a useable e-mail address at the URL above.


"Chris" wrote in message
...
Didn't anybody read this cry for help? Or nobody

wants to answer?
Chris" wrote in message
...
My technical manager is asking me a tabelar report

with header and
footer.
For every change of each one of 2 of the parameters

from rhe header, he
wants a new instance of the report on the same page

(not on a new page,
so
I
can't use "force new page").
Every tabelar report must have a fixed number of lines

(7), even the
lines
with data are less than 7, and the lines must have

grid.








.

  #6  
Old June 1st, 2004, 04:19 PM
Brendan Reynolds
external usenet poster
 
Posts: n/a
Default HELP!!! Multiple instances of a report on the same page

I think what you probably need is subreports. Create a new, blank report and
insert as many subreport controls as you want 'pages' per sheet. Use your
existing report as the source object for the subreport controls.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"Chris" wrote in message
...
Sorry! I ment to print on the same A4 paper sheet more consecutive pages

of
a report (smaller then A4)till the A4 paper sheet is over, and then to
continue on the next paper sheet with the next page of the report, and so
on.
OR to print on the same A4 paper sheet more times the same page of the
report.
The report it is all about has header, body and footer with data in all

of
them..

Can you help me?

"Brendan Reynolds" brenreyn at indigo dot ie wrote in message
...
I don't understand the question, Chris. I can't imagine what "a new

instance
of the report on the same page" might mean. To my way of thinking, pages

are
"inside" reports, not the other way around, you can't have reports

within
a
page, you have pages within a report.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible

for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted

without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"Chris" wrote in message
...
Didn't anybody read this cry for help? Or nobody wants to answer?
Chris" wrote in message
...
My technical manager is asking me a tabelar report with header and

footer.
For every change of each one of 2 of the parameters from rhe header,

he
wants a new instance of the report on the same page (not on a new

page,
so
I
can't use "force new page").
Every tabelar report must have a fixed number of lines(7), even the

lines
with data are less than 7, and the lines must have grid.










  #7  
Old June 1st, 2004, 04:20 PM
Wayne Morgan
external usenet poster
 
Posts: n/a
Default HELP!!! Multiple instances of a report on the same page

If I'm understanding this correctly, you want to fill the page. You even
want to do this if the second copy of the report starts to print instead of
the second copy starting on a new page. Standard windows printing is going
to send a page feed at the end of a print job before it starts the next
copy, so unless you can find a printer driver add-in that will capture the
print job and repaginate all the copies into a single run for you, I'm going
to say No. One utility I've used successfully, but I don't remember this
option, is at www.fineprint.com. This will give options for 4 pages/sheet
and other reformatting.

--
Wayne Morgan
MS Access MVP


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.