473,387 Members | 1,464 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Subreport Question

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
3 1980
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
"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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Manal/report designer | last post by:
Thank you in advance for any suggestions... I'm using crystal reports version 8 & SQL server. I've created a report that is composed of 2 parts: 1st part contains the main report which uses...
1
by: David | last post by:
I'm in a sad state, not knowing anyone who knows more than the little I do about Access, so I'm having to learn it all from a book. Sometimes I just can't find what I need to know. People in my...
9
by: Downstreamer | last post by:
Design is as follows: A form for the user to input criteria to be used as the where part of the report's recordsource. This includes a multiselect list box as part of the criteria selection. ...
2
by: Keith Wilby | last post by:
A97 I have a report/sub-report setup and for some records in the main report, the sub-report is blank. I want to set the height of the sub-report to zero where it is blank. I've set all the "Can...
7
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those...
1
by: Marie | last post by:
How do you display a total from a subreport on the main report. If it makes a difference, the total is a total of a calculated field (Qty * Price). Does the total on the subreport go in the...
6
by: Steve Jorgensen | last post by:
I tried to fix a problem for a client today in which report sections and even individual text controls in some of their reports are being split across page boundaries. Of course, I was thinking...
1
by: shaqattack1992-newsgroups | last post by:
I know this is kind of a weird question, but is there anyway to give a subreport control of a main report? I posted my situation earlier about having drawings print out after a group. I have a...
1
by: Tim Frawley | last post by:
I have created a Crystal Report with five subreports to represent datagrids on our dataentry application. The largest datagrid is the last item on the report. When empty this last subreport will...
3
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RecordSource of a Master Report is: Me.RecordSource = "TableOrQueryName"
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.