2 reports mix in 1 report?

[fox]

Hi!
I have a question. I have 2 list report format. Now is separate, but I
want to link them together(Second one follow the first one). And sometime the
Second list report need to show two groups(run twice for different group).
How to do it?

fox

First Report
---------------------------
xxxxx xxxxx xxxx

Second Report
---------------------------
xxxxx xxxxx

The report format I need
xxxxx xxxxx xxxx
xxxxx xxxxx xxxx
yyyyy yyyyy yyyy
xxxxx xxxxx xxxx
yyyyy yyyyy yyyy
total #

 

[Marshall Barton]

I have a question. I have 2 list report format. Now is separate, but I
want to link them together(Second one follow the first one). And sometime the
Second list report need to show two groups(run twice for different group).
How to do it?

fox

First Report
---------------------------
xxxxx xxxxx xxxx

Second Report
---------------------------
xxxxx xxxxx

The report format I need
xxxxx xxxxx xxxx
xxxxx xxxxx xxxx
yyyyy yyyyy yyyy
xxxxx xxxxx xxxx
yyyyy yyyyy yyyy
total #

----------------------------
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
total #

The secret to creating reports is to first create a query
that collects the right set of records together. I can't
help you with this until you explain the tables where the
data comes from along with their relevant fields and how
they relate to each other.

Once you have the query producing the desired data, the
report should be fairly easy. Just use Sorting and Grouping
to group the records so you can get the subtotals you want.

 

[fox]

I use the sorting and grouping function, and it sort as I want. But how to
make the label(Header) print once again between the two sorted group? Thank
you.

fox

 

[Marshall Barton]

You should use the group header section for that purpose.
--
Marsh
MVP [MS Access]

I use the sorting and grouping function, and it sort as I want. But how to
make the label(Header) print once again between the two sorted group?

 

[Marshall Barton]

The report has a group header with label already. How to change the format?

The current report
label1 label2 label3
11111 1111 AAA
22222 2222 AAA
33333 3333 AAA
11111 1111 BBB
22222 2222 BBB

The new format will print like this
label1 label2 label3
11111 1111 AAA
22222 2222 AAA
33333 3333 AAA

label2 label2 label3
11111 1111 BBB
22222 2222 BBB

There seems to be some confusion here. You appear to be
talking about the Report Header instead of a Group Header.
If you have used Sorting and Grouping to specify a group on
the third field (you should really use the real names of the
fields in the table), AND you have entered Yes in the Group
Header property in the bottom half of the window, then just
move the labels from the report header to the group header
section.

 

[fox]

Yes, it works as I want now. However, there is one more question. Some data I
use code to hide it, but after it done, the blank line still took the report
space. Is anyway to control it? Thank you.

fox

 

[Marshall Barton]

Dwpends on how you are "hiding" the "data". If you
aresetting the Visible property of the controls in the
detail section, then just set the control's CanShrink
property to Yes.

If you are doing something else, you'll have to explain
before I can determine how to approach your question.

 

[fox]

Yes, I use visible to hide. I change all header and footer to "can shrink",
expect page header and page footer(don't have that option). The space still
there between each data group.

fox

Dwpends on how you are "hiding" the "data". If you
aresetting the Visible property of the controls in the
detail section, then just set the control's CanShrink
property to Yes.

If you are doing something else, you'll have to explain
before I can determine how to approach your question.
--
Marsh
MVP [MS Access]

Yes, it works as I want now. However, there is one more question. Some data I
use code to hide it, but after it done, the blank line still took the report
space. Is anyway to control it? Thank you.

 

[Marshall Barton]

You need to set the CanShrink property of both the text
boxes you are making invisible and the section that contains
them.

Note 1) Blank areas in the report can not shrink, only the
text boxes.
Note 2) A text box will shrink if its value is Null, a ZLS
(empty string) or if it is made invisible.
Note 3) If a control has an attached label, when you make
the control invisible, its attached label will also become
invisible.
Note 4) If a shrinking control has a non-shrinking control
in the same "horizontal band", the section can not shrink to
reclaim that space.