473,670 Members | 2,527 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

keep section head and detail together

2 New Member
I have a multicolumn report with one group header section. The header has "new col or row before and after" to make sure the header always starts on a new line.

Basically I have two problems:
1. the minor problem: the header section is as wide as the detail. This is survivable, but when a "before and after" is set, the section always has room to span the page. Is there a trick to achieve this?
If I would use "page before" then I could use the page header to display the group header, but that is not an option.

2. the real problem: the group header can be displayed at the bottom of one page and the actual detail on the next page. This is visually not attractive. I need a way to keep header-detail together (like paragraphs in Word) and only page break between detail-detail or detail-header.
Setting the header to "repeat on page break" works in that the header is repeated on the next page, but then the next detail is placed directly to the right of the header. And that is not the idea either.
Nov 6 '06 #1
2 2499
tbee
2 New Member
FYI: I came up with a hack of myself: I moved the texts of the header to the details section and sized the header to 0 height and only use it to insert the "new cols before and after".

The header texts in the details are of minimal height with autogrow. Then I implemented the grouping using a module variable to detect grouping and another to determine index within a group. On idx = 1 the headers are filled from corresponding hidden fields, on idx=2 the headers are filled with a space to make sure they take equal room so it all lines up on the line, for idx>2 (next line) the texts are set to empty strings so they use as less room as possible.

This results in some restrictions to the layout but it does work acceptably. And it also allows me have some kind of a page wide header (a line).
Nov 6 '06 #2
MMcCarthy
14,534 Recognized Expert Moderator MVP
I have a multicolumn report with one group header section. The header has "new col or row before and after" to make sure the header always starts on a new line.

Basically I have two problems:
1. the minor problem: the header section is as wide as the detail. This is survivable, but when a "before and after" is set, the section always has room to span the page. Is there a trick to achieve this?
If I would use "page before" then I could use the page header to display the group header, but that is not an option.

2. the real problem: the group header can be displayed at the bottom of one page and the actual detail on the next page. This is visually not attractive. I need a way to keep header-detail together (like paragraphs in Word) and only page break between detail-detail or detail-header.
Setting the header to "repeat on page break" works in that the header is repeated on the next page, but then the next detail is placed directly to the right of the header. And that is not the idea either.
Click on the grey bar defining the group header and open the properties window. Under the format tab set the Force New Page property to Before Section.
Nov 7 '06 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
1865
by: William Starr Moake | last post by:
This may be difficult to understand unless you are familiar with the design mode feature built into Internet Explorer 5.5+. I used this feature to develop a browser-based WYSIWYG HTML editor for offline use, but I have run into a serious problem that I can't solve. innerHTML and outerHTML access the <body> section of the web page under construction, but I was able to hack together some javascript to access the <head> section for the user...
2
3936
by: John M | last post by:
Hi For reporting grades and comments about students, I use one subreport per subject. This includes a number of text boxes, some containing numerical data, but one containing a textual report. Depending on how much is written, sometime there are three on a page, sometimes two etc. What I cannot seem to do is to get it to 'not start a report for a subject unless it can fit it on a page'. The keep together option seem to have no effect...
6
8630
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...
0
1592
by: Johnny M | last post by:
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...
1
2844
by: Ramanfromoz | last post by:
Hi, Developing a new we application. Everything okay on my local WIN XP PROFESSIONAL, IIS 5.0 running locally. The website is running smoothly. Now, the same code I am copying over to a WINDOWS 2003 SERVER, I created a new website, allocated port number 6000. Created a release version on my local machine and copied the WEB project from my local to http://ACTYD003:6000
0
1613
by: Tim Marshall | last post by:
Access 2003. A report of mine was hanging on print preview. It turned out the issue was a bound text box where the data was too big to fit all on one page. When I changed the "keep together" property for the detail section to NO, the report previewed and performed as expected. However, I'm now faced with a minor irritant I'd like to be able to deal with. Some other records with far less content in the text box at issue end up getting...
4
5612
by: Tom | last post by:
Hi: I'm having a problem with a simple report in a simple database. Basically it's an issue tracking database - what is the issue, what is the proposed solution, who is responsible, a tracking number, and that is it. Two tables - one for the issue, one for the people (one issue can have more than one responsible person). No code - whole thing slapped together in 15 minutes. The report is set up to print the tracking number, issue,...
10
11748
by: sara | last post by:
Hi - Is it possible to hide the detail section of a report at run time? I have a report that prints all details, with summary lines. The user would like the report ALSO with just summary lines. It seems the simplest thing is to run the code (see below) once with the detail section showing, and a second time hiding the detail section. I can't figure out the code to do that and don't see it posted.
0
918
by: Les Desser | last post by:
I have a problem in an A97 report. The detail section of the report has Keep-together and CanGrow set to Yes The detail section contains a sub-report which can grow quite large. If the subreport cannot fit on the page then it skips to the top of the next page.
0
8896
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8810
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
8590
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
8659
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
6211
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
5683
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
4208
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...
0
4387
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1790
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.