By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Subreport Question

P: n/a
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!!!

Mar 1 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I may be wrong (I was once before back in the 80's) but I believe
subreports can only show report headers/footers and not page headers/
footers.

On Mar 1, 10:40 am, "Matt" <mdw233...@yahoo.comwrote:
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!!!

Mar 1 '07 #2

P: n/a
"ManningFan" <ma********@gmail.comwrote in
news:11*********************@h3g2000cwc.googlegrou ps.com:
I may be wrong (I was once before back in the 80's) but I
believe subreports can only show report headers/footers and
not page headers/ footers.
Your date of last error is unchanged. The Page header and footer
are supressed when used in a subreport. Report and group headers
are still available,

Matt,

You can probably redesign your AS report to put the data in a
Group header, instead of page header, and have the report start
a new page on each group.
On Mar 1, 10:40 am, "Matt" <mdw233...@yahoo.comwrote:
>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!!!



--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Mar 1 '07 #3

P: n/a
On Mar 1, 5:28 pm, Bob Quintal <rquin...@sPAmpatico.cawrote:
"ManningFan" <manning...@gmail.comwrote innews:11*********************@h3g2000cwc.googlegr oups.com:
I may be wrong (I was once before back in the 80's) but I
believe subreports can only show report headers/footers and
not page headers/ footers.

Your date of last error is unchanged. The Page header and footer
are supressed when used in a subreport. Report and group headers
are still available,

Matt,

You can probably redesign your AS report to put the data in a
Group header, instead of page header, and have the report start
a new page on each group.


On Mar 1, 10:40 am, "Matt" <mdw233...@yahoo.comwrote:
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!!!

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account fromhttp://www.teranews.com- Hide quoted text -

- Show quoted text -


Thanks ... I created a Page and Report header (Exactly the same), and
did not show the page header on page 1 ... fixed it.

Thanks for the help!!

Mar 2 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.