How can I place a multi column sub rpt in a multi column report?

[GOS]

I have 3 reports that I am trying to merge together. One is a single column
report and the other two are multiple column reports. I can place the single
column report in one of the Multiple column reports, however when I try and
place the other multiple column report it doesn't work. Any ideas.
Much appreciated

 

[Larry Linson]

I have 3 reports that I am trying to merge together. One is a single column
report and the other two are multiple column reports. I can place the
single
column report in one of the Multiple column reports, however when I try
and
place the other multiple column report it doesn't work. Any ideas.
Much appreciated

Multiple column Reports embedded in Subreport Controls must be formattted
"Across then Down." "Down then Across" will not be formatted as you would
expect.

Larry Linson
Microsoft Access MVP

 

[GOS]

HI Larry,

This doesn't work.
I have 3 reports and placed the 2 reports into the one main report as
follows.
Main report - Cash has multiple Columns.
I have placed a single column report in the report header.
So far the report looks somehwhat like this
FUND
21/08/06 XXX Break EUR 100.00
21/08/06 XXX Break EUR 50.00

TOTAL EUR150.00
22/08/06 XXX Break GBP 50.00

TOTAL GBP 50.00

The above is placed in the Report Header
The below is the main multiple column report that has a Column lay out of
Down then across.
CASH
EUR GBP
Breaks 150 50
XXX 50 200
XXX 100 100

TOTAL 300 350

The above two reports look okay together. The problem is when I try and add
the below multiple column report. I have tried both option's with the column
Layout Down then across and with Across then Down. I want the layout to look
as follows
FUND
21/08/06 XXX Break EUR 100.00
21/08/06 XXX Break EUR 50.00

TOTAL EUR150.00
22/08/06 XXX Break GBP 50.00

TOTAL GBP 50.00

CASH
EUR GBP
Breaks 150 50
XXX 50 200
XXX 100 100

TOTAL 300 350

EQUITY
EUR GBP
XXX 50 500
XXX 150 100

TOTAL 200 600

Instead the report looks like what I have out lined below.
CASH
EUR GBP
Breaks 150 50
XXX 50 200
XXX 100 100

TOTAL 300 350

EQUITY
XXX
XXX

XXX
TOTAL

EUR 50
EUR 100

GBP 50
GBP 200

Again if you can help me I would greatly appreciate it.

Thanks

Grace

 

[Larry Linson]

Could you detail the Tables / Queries that you are using? It's not clear to
me that we are talking about the same thing, or why what you show, in fact,
a multi-column report.

When I talk about multicolumn, I mean that I have a report with
identically-formatted records that I am simply arranging in columns. And, it
appears that you are talking about something different, more like a tablular
report than what I expected. Very brief columnar Reports _may_ work in
Subreports with Down Then Across -- I don't recall trying one that was only
two or three lines long.

Larry Linson
Microsoft Access MVP

 

[GOS]

Hello Larry,
I created the report using Design view. When I say it is a multi column
report, I am referring to the page set up. In the Page set up /Columns tab,
I have set the grid settings set to 14 as being the total no of column
displayed.

I am only starting out with Access and there are numerous queries and tables
( 16 tables and 63 queries), I presume far more than needed but as I learn I
will be able to achieve results in bigger steps rather than a number of tiny
ones.
I had only given a brief sample of the layout of the report as the finished
report should have about 50-100 lines of text.
Apologies if I am not clear in what I am specifically looking for, I'm still
coming to grips with Access .

Many thanks for your response.
Grace

 

[Larry Linson]

The maximum page width in a Report, including margins is 22 inches. If you
arrange that in 14 columns, with margins and gutter-space between, those are
very narrow columns which would not be able to contain much text nor many
fields, and I don't understand how you could then include a multi-column
subreport within the columns -- which is what I understood you planned to
do.

Is it possible to simplify what you are doing to the simplest form that
doesn't work as you expect and perhaps we could work from that sample? We'd
like to help, if we can, but long-distance debugging assistance is not
always easy.

Larry Linson
Microsoft Access MVP