473,804 Members | 2,164 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SubReport - Keep Together

I have a main report that consists of 15 subreports. When a main detail item
is produced only selected subreports are produced depending on a certain
control. The subreports generally occupy only 3 columar inches of space and
I want to keep the entire subreport on a page. The keep together property on
the detail section of each subreport is set to Yes but the subreports still
break across a page even if it is the last of three subreports visible on
that page. No subreport is close to filling a page on it own. Generally 3
subreports fit comfortably on a page. I do not want to leave a orphan on the
next page.

Am I missing something obvious? Is there another way to get a whole
subreport to keep together on a page?

I am using Access 2003 on WinXPpro

Thanks
Johnny
Nov 13 '05 #1
0 1594

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

Similar topics

0
6231
by: Chibyboy | last post by:
Hi fellow developers, I have a crystal report with a subreport whose (N of M) special field only shows the page number at the last page of the subreport. The page number is on the subreport and it's supposed to show on every page. I have placed this special field in a group section that's set to "Repeat Group Header on each Page". I tried unchecking the "Keep Togerther" from the Detail section above the group section, but this doesn't...
1
3391
by: Ed | last post by:
Hello! I have a report that includes a subreport. They are linked together by a common ID field. The subreport contains 6 controls, 5 of them text boxes with a control source and one of them is a list box based on a query. The text boxes that have a control source show the correct data for multiple records of the subreport but the listbox is only queried once and it does not change for other records.
2
1414
by: Josh Nikle | last post by:
I have a subreport that displays the addresses of suppliers. Its source table has fields for the name, street, city/state, and ZIP code for easier querying. However, for display purposes, I put the city/state and ZIP together and put that value in txtCityAndState. When I run the report, the print preview looks perfect. When I print it, though, txtCityAndState is blank. I've tried putting the same code I used to fill this textbox in the...
1
2380
by: last Name | last post by:
Hello all, I'm using Access 2000. I have a subreport control which loads a report in the detail section of a main report. I need to keep a count of each item price in the subreport and place it in the Report footer of the main report. Each post i've read on this seems to not work and/or give me the same problems the other posters are having: a box coming up asking for parameter values. Thanks in advance for your help.
6
8645
by: Steve Jorgensen | last post by:
I tried to fix a problem for a client today in which report sections and even individual text controls in some of their reports are being split across page boundaries. Of course, I was thinking the answer was just going to be setting some Keep Together properties to Yes. Alas, it was not to be. It turns out that the report in question is actually a combination of 2 other reports based on different tables. The reports should follow one...
2
5068
by: Li Pang | last post by:
Hi, I can add a subreport into the main report at the develop time (visual way), and everything works fine. However, I'd like to know how to do the same task at the run time, ie, when the main report is loading, the second report is adding into it. Both reports 'main.rpt', and 'subreport.rpt' are predefined, I only want to know how to link them together.
9
7364
by: Alan | last post by:
Hmmm, I'm not too good with the syntax of referencing a subreport. I have frmInvoice which has the invoice details (e.g. ProductCode, ProductCost etc) in the subform frmInvoiceDetails. I'm trying to get a field (AccountID) to show in the parent form based on whether a particular product code (EXT) is present in the list of ProductCodes on the subform. So far I've tried: IIf(Reports!!="EXT",Null,!)
17
20353
by: =?Utf-8?B?SGVyYg==?= | last post by:
I have created a report and subreport in VB/ASP.NET. The report works fine but the subreport will not display. The subreport, when displayed as a standalone report, works fine. Any help I can find on this error refers to the WinForms.ReportViewer and none to the WebForms.ReportViewer. Anyone have any guidance?
2
1955
by: NJonge01 | last post by:
Hi, I use a counter in a subreport. The subreport is the primary data presentation for the report, and it covers more than 1 page. I use the OnFormat event of the Detail section to conditionally initialize the counter. I use the Onprint event of the Detail to increment the counter. The problem is, that the counter seems to initialize itself when the report is pushed to a new page. The response is different if I have the "Keep...
0
9714
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
10350
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
10351
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
9174
agi2029
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...
1
7638
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
6866
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();...
0
5673
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3834
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3002
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.