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
"GOS" <(E-Mail Removed)> wrote in message
news:373BB927-03FA-43A5-B969-(E-Mail Removed)...
> 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" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:B49C8EF6-6594-45AF-BECB-(E-Mail Removed)...
>> > 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" wrote:
>> >
>> >>
>> >> "GOS" <(E-Mail Removed)> wrote in message
>> >> news:E2869400-D1FA-457E-97E4-(E-Mail Removed)...
>> >> >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
>> >>
>> >>
>> >>
>>
>>
>>
|
Similar Threads
