473,698 Members | 2,432 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Columns and subreports

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
Nov 13 '05 #1
4 2829
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.
Nov 13 '05 #2
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
Nov 13 '05 #3
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.
Nov 13 '05 #4
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

Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1966
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...
3
3353
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.)
2
2853
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?
1
1501
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
1
2127
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...
0
1304
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...
3
2727
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...
1
1543
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...
6
5444
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....
10
3177
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...
0
8678
marktang
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...
0
8609
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,...
0
9030
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8899
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,...
0
8871
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6525
isladogs
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...
0
5861
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
2333
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2007
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.