473,386 Members | 1,943 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,386 software developers and data experts.

keep section head and detail together

2
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 2474
tbee
2
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 Expert Mod 8TB
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
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...
2
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. ...
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...
0
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...
1
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...
0
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"...
4
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...
10
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....
0
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...
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: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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
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
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,...
0
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...
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.