Multiple reports in one main report

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have used advice from an earlier thread to have multiple reports as
sub reports in a main, unbound, report in order to get sequential
numbering.

That has worked well as far as the numbering is concerned. My
difficulty is that the page headers, which exist on the original
reports, do not appear in the combined report.

Thanks,

Robin Chapple
 
In the design view of each subreport, add a new primary sorting and grouping
level with the field/expression of:
=1
Display the header for this group level. View the properties dialog for the
Group =1 header and set the Repeat Section property to Yes.

This new =1 Group Header can then serve as a Page Header in the subreport.
 
Duane,

Thanks for that information. I would never have found that.

I have moved the labels into the =1 Group header and I now have the
header over each individual record.

Robin
 
Thanks,

I have done that and find it difficult to describe things. The
original report is the "alpha" report and the unbound report is the
"combined" report and they are illustrated here:

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

I have gained a border around the whole report and still don't have
page headers.

Thanks again,

Robin Chapple
 
Did you create a new primary sorting and grouping level in your subreport?
Did you display this groups header?
Did you set this group headers Repeat Section to Yes?
 
You didn't move any of your former page header controls into the =1 group
header section.
 
Thanks again Duane,

I had looked in the subreport by itself not when it was part of the
complete report. That is settled.

This saga is as big as "Ben Hur" <G>

I am outputting a page break between subreports so that a new report
starts on a new page.

I added a second subreport without a problem.

Then I added a third report that has columns.

The story is illustrated here:

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

When I have this finished I need to know about the "=1".

Many thanks,

Robin Chapple
 
What's your problem. I can see the views on your web page but I don't like
guessing at what you need resolved. Have you tried googling for any of these
answers? I and many others have posted answers to these exact questions many
times in the past.
 
What's your problem.
Click to expand...

My apology. I expected that visuals would explain better than my
words.

i) The report prints as expected in it's original form.
ii) When the =1 grouping is added the columns do not print as
expected.
iii) when the sub report is added to the complete report yet another
form at is printed.
Have you tried googling for any of these
answers? I and many others have posted answers to these exact questions many
times in the past.
Click to expand...

I have searched Google and found 34,000 answers. I have not read all
34,000 messages. None of those that I did read referred specifically
to this topic.
 
Subreports printing multiple columns work when printing Across then Down.
There are some complex solutions that allow you to create the view that you
desire (I think). 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.
 
Good Morning Duane,

I have the same issue as Robin, but when I do the process you outlined, I
get the header above each record. I don't want this -- I only want the page
header at the top of the page - once. Aany help would be appreciated.

Thanks!

dawn
 
dawn said:
Good Morning Duane,

I have the same issue as Robin, but when I do the process you
outlined, I get the header above each record. I don't want this -- I
only want the page header at the top of the page - once. Aany help
would be appreciated.
Click to expand...

Did you move the new group to the top-most level? It needs to be.
 
Perfect!!! Works like a charm. I had it as the 2nd line in the sort.

Thank You! I might get this project done yet!

dawn
 
Did you move the new group to the top-most level? It needs to be.
Click to expand...

I have failed to understand this detailed instruction from Duane:

What is a calculated column? Search has not helped.

Thanks,

Robin Chapple
 
A calculated column in a record source is a calculated expression in a
query. For instance, a calculated column in a query of OrderDetails might
look like:

CostExtended: Qty * UnitPrice * (1-PctDiscount)
 
In my case the two fields are:

[PostCode] and [FullName]

How do I perform a calculation please?
 
Back
Top