Report delima

[Fysh]

First off I was given this project from someone else and
to cause even more problems the tables are not
normalized. However, this is my last task that I need to
accomplish so they can review it, in which during this
time I will be able to normalize the DB and will be able
to make changes much more easily. That be said I have a
report with a subreport. The report is based on a table
with all there training information including weak areas.
Each of these requirements also has subrequirements and
weak areas (Once again all in the same table). Now the
main report has an individual's information. The
subreport has the training requirements. This part works
fine. My problem is I have to figure a way to get the
information for the subrequirements to match the main
requirement. So I decided to make another subreport2 of
the subreport. So far so good. I have the subreport
sorting by the training requirements with the subreport2
in the header of the subreport. However, when I run the
report from a form the report displays each of the weak
areas including the sub weak areas each time for each
requirement.
for example:

Name blah blah

Requirement1 comments
weak area1 comments
weak area2 comments

Requirement2 comments
weak area1 comments
etc

I need it to look like

Name blah blah

Requirement1 comments
weak area1 comments

Requirement2 comments
weak area2 comments
etc

Requirement3 comments

Requirement4 comments
weak area4 comments

Each of these reuirements has an identifier say test00,
test10, etc. all ending in 0. Each of the subrequirements
has an identifier as well like test01, test02, test11,
etc. and each of these has a column to identify which main
requirement it is matched to once again with test00,
test10, etc. items.

Can someone assist me on this? Thanks in advance

 

[Larry Linson]

Without understanding the relationships, keys, and foreign keys you have in
your tables, it is unlikely that anyone can help.

I also am puzzled by what I understood you to say that you have a
first-level subreport, but the second-level subreport is in the _header_ of
that first level subreport. That would be very unusual, and, would seem to
me, to be unintuitive to the reader. I have rarely used sub-subreports, and
they were always associated with the _detail_ of the report embedded in the
higher-level subreport control.

If you can clarify, perhaps someone can offer some useful suggestions.

Larry Linson
Microsoft Access MVP