Sub report with columns

R

Robin Chapple

I am a leaner with Access and I have a problem with a subreport and
columns.

I asked advice in "microsoft.public.access.reports" and the advice
from the MVP is aimed at an experienced operator. So I am asking for
simplified advice here.

This is the advice received:

----start----

Subreports printing multiple columns work when printing Across then
Down. The method that I have used involves creating a calculated
column in the subreport's record source that groups the first 10 (or
other number) together and assigns a value of 1. Then next 10 get a
value of 2 etc. The main report has a column with 1 - the number of
groups required in your report. You can then add a single subreport as
a single column and set the link master/child to the calculated
column.

----end----

For a start I don't know what a calculated column is.

I hope that these screen captures may help:

http://www.rotary9790.org.au/test/alumni.htm

Thanks for your patience.

Robin Chapple
 
E

Ed Robichaud

You don't include your original question, so it's hard to guess what you
were trying to accomplish. A calculated column is an unbound control
(normally a textbox) on your form/report that has an expression as its data
source. An example would be " =[myReportQty] *[myReportUnitPrice]" . This
would give the total cost based on values in two other controls (price and
quantity).
-Ed
 
R

Robin Chapple

Ed,

The question is how to display a sub report with columns in order to
achieve page numbering on the combined report. There are four
subreports in the combined report. The URL illustrates the problem.

I first show the report as it is intended to be printed.

The second image shows the same report after it has been prepared to
be a subreport and before it joins the combined report.

The third image shows the sub report as part of the combined report.

You don't include your original question, so it's hard to guess what you
were trying to accomplish. A calculated column is an unbound control
(normally a textbox) on your form/report that has an expression as its data
source. An example would be " =[myReportQty] *[myReportUnitPrice]" . This
would give the total cost based on values in two other controls (price and
quantity).
-Ed


Robin Chapple said:
I am a leaner with Access and I have a problem with a subreport and
columns.

I asked advice in "microsoft.public.access.reports" and the advice
from the MVP is aimed at an experienced operator. So I am asking for
simplified advice here.

This is the advice received:

----start----

Subreports printing multiple columns work when printing Across then
Down. The method that I have used involves creating a calculated
column in the subreport's record source that groups the first 10 (or
other number) together and assigns a value of 1. Then next 10 get a
value of 2 etc. The main report has a column with 1 - the number of
groups required in your report. You can then add a single subreport as
a single column and set the link master/child to the calculated
column.

----end----

For a start I don't know what a calculated column is.

I hope that these screen captures may help:

http://www.rotary9790.org.au/test/alumni.htm

Thanks for your patience.

Robin Chapple
Click to expand...
Click to expand...
 
Top