473,325 Members | 2,712 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,325 software developers and data experts.

Keeping elements of a report together.

Hi,

I've set up a sytem in our school for writing reports. It uses Access ...
and does a fine job! My problem comes with printing.

Each subject produces a report consisting of a series of coded data, levels,
targets etc, then text from a memo field. Different staff write different
amounts in the memo field. As a result I keep getting odd reports split
over a page.

I'm aware of the 'Keep together' property, but seems inapproprite in this
situation. A set of data for a subject is not a group. Putting in page
breaks leaves me too often with virtually empty pages. What I need is an
elastic band to put round all the fields for one subject!!

Any ideas

Thanks in advance
Nov 12 '05 #1
3 1937

"John M" <jo**@jmawer.demon.co.uk> wrote in message
news:c1*******************@news.demon.co.uk...
Hi,

I've set up a sytem in our school for writing reports. It uses Access ...
and does a fine job! My problem comes with printing.

Each subject produces a report consisting of a series of coded data, levels,
targets etc, then text from a memo field. Different staff write different
amounts in the memo field. As a result I keep getting odd reports split
over a page.

I'm aware of the 'Keep together' property, but seems inapproprite in this
situation. A set of data for a subject is not a group. Putting in page
breaks leaves me too often with virtually empty pages. What I need is an
elastic band to put round all the fields for one subject!!

Any ideas

Thanks in advance

Nov 12 '05 #2
John,

Put Subject in a subreport, make the Subject subreport control on your main
report only 1" in height and set the Can Shrink/Can Grow properties of the
Subject subreport control both to Yes.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"John M" <jo**@jmawer.demon.co.uk> wrote in message
news:c1*******************@news.demon.co.uk...
Hi,

I've set up a sytem in our school for writing reports. It uses Access ...
and does a fine job! My problem comes with printing.

Each subject produces a report consisting of a series of coded data, levels,
targets etc, then text from a memo field. Different staff write different
amounts in the memo field. As a result I keep getting odd reports split
over a page.

I'm aware of the 'Keep together' property, but seems inapproprite in this
situation. A set of data for a subject is not a group. Putting in page
breaks leaves me too often with virtually empty pages. What I need is an
elastic band to put round all the fields for one subject!!

Any ideas

Thanks in advance

Nov 12 '05 #3
If the printed data for a single record can exceed a single page then you're
stuck. However, if all records are less than a page in length then you do
want to keep together such that anytime a page would overflow the record
will begin on a new page. Other than that you get into tweaking your data
and the printed format in order to get a pleasing result.

HTH
--
-Larry-
--

"John M" <jo**@jmawer.demon.co.uk> wrote in message
news:c1*******************@news.demon.co.uk...
Hi,

I've set up a sytem in our school for writing reports. It uses Access ...
and does a fine job! My problem comes with printing.

Each subject produces a report consisting of a series of coded data, levels, targets etc, then text from a memo field. Different staff write different
amounts in the memo field. As a result I keep getting odd reports split
over a page.

I'm aware of the 'Keep together' property, but seems inapproprite in this
situation. A set of data for a subject is not a group. Putting in page
breaks leaves me too often with virtually empty pages. What I need is an
elastic band to put round all the fields for one subject!!

Any ideas

Thanks in advance

Nov 12 '05 #4

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

Similar topics

24
by: Michael Malinsky | last post by:
I'm attempting to create a database which will take information from one (perhaps two) tables and utilize that information to return queries to a report designed in Excel. The general idea I...
4
by: R. Weigman | last post by:
Can anyone tell me how to keep a sub report together on the main report. Once I drop the sub report onto the main report all of the sorting and grouping keep together options on the sub report go...
5
by: Alan Webb | last post by:
Guys, I get this: Regular Hours are any hours less than the number of hours that can be worked before the hours begin to be counted as overtime in the period. Overtime Hours are any hours...
2
by: Henry | last post by:
I am trying to write an application that allows me to dynamically load selected Crystal Report files, read the parameters from the report file, give the user a chance to enter relevant data in a...
2
by: mavis | last post by:
Could you please help me with this xsd definition? I need to define a set of elements occur in any order with multiple occurrences, but the same kind of elements need to group together... Sth...
4
by: Jana | last post by:
Hi! I have an Access 97 report based on tables linked to an SQL back end. The report has 5 subreports in it (unfortunately unavoidable due to the nature of the report) and performance is quite...
5
by: ladybug via AccessMonster.com | last post by:
I am trying to create a report using multiple tables. The first table has Employee info in it (name and id's). the next three tables have employee info for training, test, scores, etc. I am...
2
by: anthony | last post by:
My report has RegNo header, AOL header, Detail section, RegNo footer. The RegNo footer contains a subreport which consists only of a label and a single control, both in the subreport's detail...
6
by: santiago | last post by:
I guess one cannot do this: arraytot = arraytot + arraydet; So, what's the trick to adding arrays like this? Thanks.
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.