I have a main report (single column report and page headers and
footers) and a 4 column subreport in the detail section. The report
will generally be a single page.
Everything prints fine except that I cannot get the report footer onto
the same page as the subreport, it always goes onto another page even
when there is obviously room for it on the first page.
I have the main report detail section set to can grow Yes if I set
this to No the subreport seems to then only print a single column.
Alex
4  2832 
Alex wrote: I have a main report (single column report and page headers and
footers) and a 4 column subreport in the detail section. The report
will generally be a single page.
Everything prints fine except that I cannot get the report footer onto
the same page as the subreport, it always goes onto another page even
when there is obviously room for it on the first page.
I have the main report detail section set to can grow Yes if I set
this to No the subreport seems to then only print a single column.
Alex
On a situation like this, I cheat. I add a column to the reports
recordsource. Open up the query and enter
Master : "M"
Now make Master the first column to group on (Edit/Sorting&Groupin g from
the menu). Add a footer to Master. Move the data from the ReportFooter
to the Master footer.
Since the Master sort column contains only 1 value, the break is always
at the end.
Salad <oi*@vinegar.co m> wrote in message news:<EQ******* **********@news read3.news.pas. earthlink.net>. .. Alex wrote:
I have a main report (single column report and page headers and
footers) and a 4 column subreport in the detail section. The report
will generally be a single page.
Everything prints fine except that I cannot get the report footer onto
the same page as the subreport, it always goes onto another page even
when there is obviously room for it on the first page.
I have the main report detail section set to can grow Yes if I set
this to No the subreport seems to then only print a single column.
Alex
On a situation like this, I cheat. I add a column to the reports
recordsource. Open up the query and enter
Master : "M"
Now make Master the first column to group on (Edit/Sorting&Groupin g from
the menu). Add a footer to Master. Move the data from the ReportFooter
to the Master footer.
Since the Master sort column contains only 1 value, the break is always
at the end.
Thanks for that. The footer is now at the end of the page but it is in
the last column. I want it to be the full page width. The report has a
header that spans the full page and a footer that must also span the
page. The detail section is in four columns.
Alex
Alex wrote: Salad <oi*@vinegar.co m> wrote in message news:<EQ******* **********@news read3.news.pas. earthlink.net>. ..
Alex wrote:
I have a main report (single column report and page headers and
footers) and a 4 column subreport in the detail section. The report
will generally be a single page.
Everything prints fine except that I cannot get the report footer onto
the same page as the subreport, it always goes onto another page even
when there is obviously room for it on the first page.
I have the main report detail section set to can grow Yes if I set
this to No the subreport seems to then only print a single column.
Alex
On a situation like this, I cheat. I add a column to the reports
recordsourc e. Open up the query and enter
Master : "M"
Now make Master the first column to group on (Edit/Sorting&Groupin g from
the menu). Add a footer to Master. Move the data from the ReportFooter
to the Master footer.
Since the Master sort column contains only 1 value, the break is always
at the end.
Thanks for that. The footer is now at the end of the page but it is in
the last column. I want it to be the full page width. The report has a
header that spans the full page and a footer that must also span the
page. The detail section is in four columns.
Alex
Hmmm...I guess this is where you need to fiddle and fart with it.
Something you could test would be to set a global variable for the
report to false when the report opens. Then set it to true with you get
to the Master footer. Move your fields into the page footer. Only
print the fields when true.
See MoveLayout, PrintSection in help. You'd either set this on the
OnFormat or OnPrint event.
Alex wrote: I have a main report (single column report and page headers and
footers) and a 4 column subreport in the detail section. The report
will generally be a single page.
Everything prints fine except that I cannot get the report footer onto
the same page as the subreport, it always goes onto another page even
when there is obviously room for it on the first page.
I have the main report detail section set to can grow Yes if I set
this to No the subreport seems to then only print a single column.
Alex
Alex,
I have a similar report, except that the subreport is in an inner
footer, and there is text in the report footer that I need on the same
page. I set the subreport control to "can grow" = No, to force the
columns, since with it set to Yes, I always got just one column and it
went on for pages until it was done. And as I look now, the sections
themselves are all set to "can grow" = Yes, but since that subreport
isn't going to grow, it won't overflow the page. I did have to play a
bit with the size I give the subreport to allow enough space for the
data that appears there, but to also keep the footer on the page.
Rebecca This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Anne |
last post by:
I have a report containing multiple subreports (approximately 37
subreports) that are based on individual queries. The query calls to
only display the subreport if there is valid data in the table (that
the subreport is based on). Because the subreport may not always
appear, there are spaces in between the subreports that do contain
valid data. Is there any way to resize or reformat the main report so
all subreports with valid data...
|
by: Edward |
last post by:
ACCESS 2k
I need to design a report based on a rota system for staff at various
shops. The data is effectively stored in a single table, along the
lines of:
Initials (e.g. BH, FG, RM etc.)
Day (e.g. Monday, Tuesday etc.)
Shop (e.g. Shop1, Shop2 etc.)
StartTime (e.g. 8, 13 etc.)
|
by: DFS |
last post by:
Main report contains one large graph in the detail band (no detail records).
Subreport snakes just fine (5 columns) when opening by itself. When I add
it to the main report (in the report footer), it shows just 1 column and
spills over to 5 pages.
I've tried moving the subreport to the detail band: no go. All
bands/objects are set to Grow and Shrink.
Any ideas?
|
by: Peter Bailey |
last post by:
I have a report that gives the classroom and then a list of students in it
for a particular week.
Thats fine if I want just one column with its associated rows of students.
I have been asked to produce it so that it gives multiple columns of five
rows. so:
Classroom xxx
|
by: Don Sealer |
last post by:
I have a report that includes 5 different subreports. I'd like to be
able to open this report using a date function (Start Date and End Date).
I'd like all five subreports to show the data from those dates. I have
learned how to use this start/end function but I can't figure out how to use
it with these subreports. Right now the report opens but asks for start/end
dates for each of the five reports. Is there a way I can input one set of...
| | |
by: Don Sealer |
last post by:
I have a report that includes 5 different subreports. I'd like to be
able to open this report using a date function (Start Date and End Date).
I'd like all five subreports to show the data from those dates. I have
learned how to use this start/end function but I can't figure out how to use
it with these subreports. Right now the report opens but asks for start/end
dates for each of the five reports. Is there a way I can input one set of...
|
by: strauss.sean |
last post by:
To all:
Here's an interesting one: I have a query that produces 56 (!!) columns
of data. The first three columns are "to repeat at left", as can be
selected in Excel at File --> Page Setup --> Sheet tab. That is, the
first page prints (say) 10 columns. The second page prints the first
three columns, and the next seven columns, and so on. Each page would
do this until all columns are printed.
Access gives a limit to the amount of...
|
by: sandersx2 |
last post by:
I need to create a report that shows each employee with a listing of their current projects in columns according to the project status.
Example:
Employee Name...........Active........Pending.......Marketing.......On Hold
John Doe.....................Project 1....Project 5.......Project 2........Project 6
...................................Project 3....Project 7............................Project 8...
|
by: Brett Barry: Go Get Geek! |
last post by:
Hello,
I have a main report with a Record Source, a DateToday table, that has
the current Month and Year. I have about 60 queries, each pulling
different data via ODBC, that I am creating subreports that go on the
main report. The problem is that when I run the report the data shows
on the screen but not the print preview. I am aware that the main
report is not linked to the subreports because of the Link Master,
Child Fields issue....
|
by: glenfernandez |
last post by:
HI there,
Need a little help with the reporting component of my MS Access 2002 project and would appreciate any insight / help from the experts. Please bear with me as I am still learning Access and this is my first project using it.
I'm generating a financial reporting system for a bank and have created a form for user input to dynamically generate the financial reports. So far everything is coming along ok. The reporting options allow...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
