Subreport?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
I have a question about report. I am trying to finish someone's
unfinished work. He made 2 reports already, but how should I to put it
together?
One report format looks like this
-----------------------------------------------------
page title
Title
address.....
...........
Sample ID, value.........
1 .. .. .. .. .. .. .. ..(detial)
2 .. .. .. .. .. .. .. ..
3 .. .. .. .. .. .. .. ..
4 .. .. .. .. .. .. .. ..
some comment

page end
--------------------------------------

The other report format
--------------------------------
Sample ID, value.........(a little different items from above, but still in
same query)
1 .. .. .. .. ..
2 .. .. .. .. ..
3 .. .. .. .. ..
4 .. .. .. .. ..
--------------------------------

And we will like to make them looks like this
----------------------------------------
page title
Title
address.....
...........
Sample ID, value.........
1 .. .. .. .. .. .. .. ..(detial)
2 .. .. .. .. .. .. .. ..
3 .. .. .. .. .. .. .. ..
4 .. .. .. .. .. .. .. ..
some comment

Sample ID, value.........(a little different items from above, but still in
same query)
1 .. .. .. .. ..
2 .. .. .. .. ..
3 .. .. .. .. ..
4 .. .. .. .. ..

page end
 
fox said:
I have a question about report. I am
trying to finish someone's unfinished
work. He made 2 reports already, but
how should I to put it together?
One report format looks like this
-----------------------------------------------------
page title
Title
address.....
..........
Sample ID, value.........
1 .. .. .. .. .. .. .. ..(detial)
2 .. .. .. .. .. .. .. ..
3 .. .. .. .. .. .. .. ..
4 .. .. .. .. .. .. .. ..
some comment

page end
--------------------------------------

The other report format
--------------------------------
Sample ID, value.........(a little different items
from above, but still in same query)
1 .. .. .. .. ..
2 .. .. .. .. ..
3 .. .. .. .. ..
4 .. .. .. .. ..
--------------------------------

And we will like to make them looks like this
----------------------------------------
page title
Title
address.....
..........
Sample ID, value.........
1 .. .. .. .. .. .. .. ..(detial)
2 .. .. .. .. .. .. .. ..
3 .. .. .. .. .. .. .. ..
4 .. .. .. .. .. .. .. ..
some comment

Sample ID, value.........(a little different
items from above, but still in
same query)
1 .. .. .. .. ..
2 .. .. .. .. ..
3 .. .. .. .. ..
4 .. .. .. .. ..

page end
Click to expand...

It is possible that you could use the Subreport Control to accomplish what
you want, but seems to me that it would be simpler (if the two reports do
use the same Query as the RecordSource) to just add the Controls for the
second Report to the Detail Section of the first Report. It will, perhaps,
be a little more work now, but it result in a cleaner design and better
database.

If you really want to use a Subreport Control, add it in to the Detail
Section, and set the Master Link Fields and the Child Link Fields to the
Field or Fields that uniquely identify records. I caution, however, that
performance may suffer if you use a Subreport in this particular
circumstance.

Subform and Subreport are very useful for displaying the "one" side of a
one-to-many relationship in the main Report and the "many" side in the
Report embedded in a Subreport Control. They really are not intended for
showing "just some more data from the same record" -- each report will have
executed the RecordSource, and extra work will have to be done to locate the
current Record for the Report (and, it is possible that it may have to
re-execute its RecordSource).

Larry Linson
Microsoft Access MVP
 
Thank you, I wish to use in detail section, but there is a comment between 2
data fields. I check the code with the current "working" version, both have 2
separate reports, but the "working" version will print 2 reports in the same
page follow the format. Do you have any idea how he did this?

Also, I try to use subreport, but the detail field(in the subreport) only
show the last data from the above detail field. How to make it show all data
as the above detail field.

BTW, both detail section show the same data, the only different is the 2nd
one will add more detail.

Thank you.
 
Back
Top