473,385 Members | 1,757 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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 1572

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

Similar topics

0
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...
1
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...
2
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...
1
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...
6
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...
2
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...
9
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...
17
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...
2
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...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
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...

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.