Need help with Report

[azu_daioh]

How do i design a report to display/print related data on the same
page/header.

For every [Subject] could have 1 or more [Findings]. And I would like
to be able to fit two findings on 1 page. However, when the [Subject1]
has only 1 [Finding#1], the [Finding#2] for [Subject2] get printed on
the same page as [Subject1]

For example if Subject#1 has 3 findings (a, b, c) and Subject #2 has 1
finding (d)
My report gets printed this way:

Page#1:
--------------PAGE HEADER----------
Subject #1 Name
---------------DETAILS------------------
Finding# a
Finding# b
--------------PAGE FOOTER------------

Page#2:
--------------PAGE HEADER----------
Subject #1 Name
---------------DETAILS------------------
Finding# c
Finding# d --(finding belongs to Subject#2)
--------------PAGE FOOTER------------


How do I set the report to 'not' display finding #d on page 2 but
create page 3 for subject #2 and finding # d ? Please help. If I
didn't explain this clearly, let me know.

Thanks,

Sharon

 

[kingston via AccessMonster.com]

What does your data look like? It needs to be something like:

Subject1 FindingA
Subject1 FindingB
Subject1 FindingC
Subject2 FindingD
...
FindingD is never associated with Subject1. Your report would then be
grouped by Subject and you can keep groups together during printing.

How do i design a report to display/print related data on the same
page/header.

For every [Subject] could have 1 or more [Findings]. And I would like
to be able to fit two findings on 1 page. However, when the [Subject1]
has only 1 [Finding#1], the [Finding#2] for [Subject2] get printed on
the same page as [Subject1]

For example if Subject#1 has 3 findings (a, b, c) and Subject #2 has 1
finding (d)
My report gets printed this way:

Page#1:
--------------PAGE HEADER----------
Subject #1 Name
---------------DETAILS------------------
Finding# a
Finding# b
--------------PAGE FOOTER------------

Page#2:
--------------PAGE HEADER----------
Subject #1 Name
---------------DETAILS------------------
Finding# c
Finding# d --(finding belongs to Subject#2)
--------------PAGE FOOTER------------

How do I set the report to 'not' display finding #d on page 2 but
create page 3 for subject #2 and finding # d ? Please help. If I
didn't explain this clearly, let me know.

Thanks,

Sharon