Subreport Question

[Matt]

Hi All,

I currently have 2 reports. One report shows Transaction History (I
will refer to as "TH") and the other shows Account Summary (I will
refer to as "AS"). I want to combine the reports into one report
using a sub report. (I still want to view "AS" seperately by itself).

What I have working:
On the "TH" report I have added "AS" as a subreport, linking them on
Social Security Number. It is showing the "TH" report correctly, but
only showing the detail section of the "AS" report (Is displaying all
accounts for that customer correctly).

What I would like to see:
I would like to not only see the detail section, but also the page
header of the "AS" report. I have looked at all obvious settings (I
think) and have not been able to get this to work. I am sure it is an
easy fix and I am just missing something.


Thanks in advance for all of your help!!!

 

[Guest]

You won't be able to show the page header from the AS report when its used as
a subreport, I'm afraid.

A possible solution would be to create another copy of the AS report by
opening it in design view and then selecting Save As from the File menu,
saving it under a different name. In the new copy group the report by
customer and cut and paste the header controls into the group header from the
page header. Set the header's RepeatSection property to True. Use this
report as the subreport.

You should then find that the group header shows in the subreport above each
customer's account summary data. If the summary data spans several pages the
RepeatSection setting for the group header should cause the header to repeat
on the second and any subsequent pages. To be honest I'm not 100 percent
sure on this last point when the report is used as a subreport, but I think
from memory of similar scenarios that it's the case.

Ken Sheridan
Stafford, England

 

[Matt]

You won't be able to show the page header from the AS report when its used as
a subreport, I'm afraid.

A possible solution would be to create another copy of the AS report by
opening it in design view and then selecting Save As from the File menu,
saving it under a different name. In the new copy group the report by
customer and cut and paste the header controls into the group header from the
page header. Set the header's RepeatSection property to True. Use this
report as the subreport.

You should then find that the group header shows in the subreport above each
customer's account summary data. If the summary data spans several pages the
RepeatSection setting for the group header should cause the header to repeat
on the second and any subsequent pages. To be honest I'm not 100 percent
sure on this last point when the report is used as a subreport, but I think
from memory of similar scenarios that it's the case.

Ken Sheridan
Stafford, England









- Show quoted text -

Thanks Ken ... I ended up just making both a page and report header
and then hiding the page header on page 1, but your insight that I
couldnt show the page header is what got me there!

Thanks again!!