How to put multi-column subreport into a report?

[Edmund]

Hello,

I have a report that is multiple columns (2 to be exact). There are two
TypeIDs and on the TypeID Footer I have [New Row Or Col] set to [After
Selection]. This works fine when I open the report as each MainID has a
page with two columns, one for each TypeID.

I have another report that has details on each MainID record. I put the 2
column TypeID into the MainID Header of the MainID report and linked them on
MainID. The problem is than now when I open the MainID report the TypeID
report is making a new page at the bottom of each column instead of making a
new column on the same MainID page. This results in me getting 3 pages per
MainID. One for each column in the TypeID subreport and one for the
original MainID report.

Does anyone know how to get a multi-column subreport not to make a new page
when it should just make a new column?

Thanks,

Edmund

 

[Marshall Barton]

I have a report that is multiple columns (2 to be exact). There are two
TypeIDs and on the TypeID Footer I have [New Row Or Col] set to [After
Selection]. This works fine when I open the report as each MainID has a
page with two columns, one for each TypeID.

I have another report that has details on each MainID record. I put the 2
column TypeID into the MainID Header of the MainID report and linked them on
MainID. The problem is than now when I open the MainID report the TypeID
report is making a new page at the bottom of each column instead of making a
new column on the same MainID page. This results in me getting 3 pages per
MainID. One for each column in the TypeID subreport and one for the
original MainID report.

Does anyone know how to get a multi-column subreport not to make a new page
when it should just make a new column?

Since subreports are unaware of page related issues, you
need to set the columns to Across then Down.

 

[Edmund]

Yeah - Across and down doesn't look good since the group heading ends up on
the same line as the detail. It would be nice if I could apply the
multi-column so that the new column is not printed beside the heading. For
example, with across then down it now prints like this;

Heading1 Detail1_1
Detail1_2 Detail1_3
Heading2 Detail2_1
Detail2_2

I would like it to print like this;

Heading1
Detail1_1 Detail1_2
Detail1_3
Heading2
Detail2_1 Detail2_2

Is it possible to have a multi-column report do this?

Edmund

I have a report that is multiple columns (2 to be exact). There are two
TypeIDs and on the TypeID Footer I have [New Row Or Col] set to [After
Selection]. This works fine when I open the report as each MainID has a
page with two columns, one for each TypeID.

I have another report that has details on each MainID record. I put the 2
column TypeID into the MainID Header of the MainID report and linked them
on
MainID. The problem is than now when I open the MainID report the TypeID
report is making a new page at the bottom of each column instead of making
a
new column on the same MainID page. This results in me getting 3 pages
per
MainID. One for each column in the TypeID subreport and one for the
original MainID report.

Does anyone know how to get a multi-column subreport not to make a new
page
when it should just make a new column?

Since subreports are unaware of page related issues, you
need to set the columns to Across then Down.

 

[Marshall Barton]

THe only way I can think of that would have that effect is
to rearrange the main report so it has the heading in its
detail section and the multicolumn subreport only has a the
records for that heading (and no grouping).

This might not be too difficult if you can join the main
report data to a query that only returns the heading field
(and the linking field to the subreport details).
--
Marsh
MVP [MS Access]

Yeah - Across and down doesn't look good since the group heading ends up on
the same line as the detail. It would be nice if I could apply the
multi-column so that the new column is not printed beside the heading. For
example, with across then down it now prints like this;

Heading1 Detail1_1
Detail1_2 Detail1_3
Heading2 Detail2_1
Detail2_2

I would like it to print like this;

Heading1
Detail1_1 Detail1_2
Detail1_3
Heading2
Detail2_1 Detail2_2

Is it possible to have a multi-column report do this?

I have a report that is multiple columns (2 to be exact). There are two
TypeIDs and on the TypeID Footer I have [New Row Or Col] set to [After
Selection]. This works fine when I open the report as each MainID has a
page with two columns, one for each TypeID.

I have another report that has details on each MainID record. I put the 2
column TypeID into the MainID Header of the MainID report and linked them
on
MainID. The problem is than now when I open the MainID report the TypeID
report is making a new page at the bottom of each column instead of making
a
new column on the same MainID page. This results in me getting 3 pages
per
MainID. One for each column in the TypeID subreport and one for the
original MainID report.

Does anyone know how to get a multi-column subreport not to make a new
page
when it should just make a new column?

"Marshall Barton" wrote
Since subreports are unaware of page related issues, you
need to set the columns to Across then Down.

 

[Edmund]

That would work but I would not get the clean shrinking of the headers if
there is no information in the multi-column for either or both of the TypeID
groups. I guess it will have to do.

Thanks,

Edmund

THe only way I can think of that would have that effect is
to rearrange the main report so it has the heading in its
detail section and the multicolumn subreport only has a the
records for that heading (and no grouping).

This might not be too difficult if you can join the main
report data to a query that only returns the heading field
(and the linking field to the subreport details).
--
Marsh
MVP [MS Access]

Yeah - Across and down doesn't look good since the group heading ends up
on
the same line as the detail. It would be nice if I could apply the
multi-column so that the new column is not printed beside the heading.
For
example, with across then down it now prints like this;

Heading1 Detail1_1
Detail1_2 Detail1_3
Heading2 Detail2_1
Detail2_2

I would like it to print like this;

Heading1
Detail1_1 Detail1_2
Detail1_3
Heading2
Detail2_1 Detail2_2

Is it possible to have a multi-column report do this?

Edmund wrote:
I have a report that is multiple columns (2 to be exact). There are two
TypeIDs and on the TypeID Footer I have [New Row Or Col] set to [After
Selection]. This works fine when I open the report as each MainID has a
page with two columns, one for each TypeID.

I have another report that has details on each MainID record. I put the
2
column TypeID into the MainID Header of the MainID report and linked
them
on
MainID. The problem is than now when I open the MainID report the
TypeID
report is making a new page at the bottom of each column instead of
making
a
new column on the same MainID page. This results in me getting 3 pages
per
MainID. One for each column in the TypeID subreport and one for the
original MainID report.

Does anyone know how to get a multi-column subreport not to make a new
page
when it should just make a new column?

"Marshall Barton" wrote
Since subreports are unaware of page related issues, you
need to set the columns to Across then Down.

 

[Marshall Barton]

I don't understand that comment. If the subreport has not
information, how would its heading join to the main report's
data?

Don't forget that you can suppress an entire section in the
main report when the subport is empty simply by using the
section's (containing the subreport) Format event:
Me.Section(N).Visible = Me.subreport.Report.HasData
or
Cancel = Not Me.subreport.Report.HasData

If you don't want to "hide" the entire section, note that a
text box (and its attached label) that is invisble will
shrink, so a CanShrink text box can be shrunk by using:
Me.textbox.Visible = Me.subreport.Report.HasData
--
Marsh
MVP [MS Access]

That would work but I would not get the clean shrinking of the headers if
there is no information in the multi-column for either or both of the TypeID
groups. I guess it will have to do.


"Marshall Barton" wrote

THe only way I can think of that would have that effect is
to rearrange the main report so it has the heading in its
detail section and the multicolumn subreport only has a the
records for that heading (and no grouping).

This might not be too difficult if you can join the main
report data to a query that only returns the heading field
(and the linking field to the subreport details).

Yeah - Across and down doesn't look good since the group heading ends up
on
the same line as the detail. It would be nice if I could apply the
multi-column so that the new column is not printed beside the heading.
For
example, with across then down it now prints like this;

Heading1 Detail1_1
Detail1_2 Detail1_3
Heading2 Detail2_1
Detail2_2

I would like it to print like this;

Heading1
Detail1_1 Detail1_2
Detail1_3
Heading2
Detail2_1 Detail2_2

Is it possible to have a multi-column report do this?


Edmund wrote:
I have a report that is multiple columns (2 to be exact). There are two
TypeIDs and on the TypeID Footer I have [New Row Or Col] set to [After
Selection]. This works fine when I open the report as each MainID has a
page with two columns, one for each TypeID.

I have another report that has details on each MainID record. I put the
2
column TypeID into the MainID Header of the MainID report and linked
them
on
MainID. The problem is than now when I open the MainID report the
TypeID
report is making a new page at the bottom of each column instead of
making
a
new column on the same MainID page. This results in me getting 3 pages
per
MainID. One for each column in the TypeID subreport and one for the
original MainID report.

Does anyone know how to get a multi-column subreport not to make a new
page
when it should just make a new column?


"Marshall Barton" wrote
Since subreports are unaware of page related issues, you
need to set the columns to Across then Down.

 

[Edmund]

Now that is quite savy.

I don't understand that comment. If the subreport has not
information, how would its heading join to the main report's
data?

Don't forget that you can suppress an entire section in the
main report when the subport is empty simply by using the
section's (containing the subreport) Format event:
Me.Section(N).Visible = Me.subreport.Report.HasData
or
Cancel = Not Me.subreport.Report.HasData

If you don't want to "hide" the entire section, note that a
text box (and its attached label) that is invisble will
shrink, so a CanShrink text box can be shrunk by using:
Me.textbox.Visible = Me.subreport.Report.HasData
--
Marsh
MVP [MS Access]

That would work but I would not get the clean shrinking of the headers if
there is no information in the multi-column for either or both of the
TypeID
groups. I guess it will have to do.


"Marshall Barton" wrote

THe only way I can think of that would have that effect is
to rearrange the main report so it has the heading in its
detail section and the multicolumn subreport only has a the
records for that heading (and no grouping).

This might not be too difficult if you can join the main
report data to a query that only returns the heading field
(and the linking field to the subreport details).


Edmund wrote:
Yeah - Across and down doesn't look good since the group heading ends up
on
the same line as the detail. It would be nice if I could apply the
multi-column so that the new column is not printed beside the heading.
For
example, with across then down it now prints like this;

Heading1 Detail1_1
Detail1_2 Detail1_3
Heading2 Detail2_1
Detail2_2

I would like it to print like this;

Heading1
Detail1_1 Detail1_2
Detail1_3
Heading2
Detail2_1 Detail2_2

Is it possible to have a multi-column report do this?


Edmund wrote:
I have a report that is multiple columns (2 to be exact). There are
two
TypeIDs and on the TypeID Footer I have [New Row Or Col] set to [After
Selection]. This works fine when I open the report as each MainID has
a
page with two columns, one for each TypeID.

I have another report that has details on each MainID record. I put
the
2
column TypeID into the MainID Header of the MainID report and linked
them
on
MainID. The problem is than now when I open the MainID report the
TypeID
report is making a new page at the bottom of each column instead of
making
a
new column on the same MainID page. This results in me getting 3
pages
per
MainID. One for each column in the TypeID subreport and one for the
original MainID report.

Does anyone know how to get a multi-column subreport not to make a new
page
when it should just make a new column?


"Marshall Barton" wrote
Since subreports are unaware of page related issues, you
need to set the columns to Across then Down.