469,625 Members | 1,802 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

Sub Reports

DS
Where do you add a Sub-Report? To the detail Section?
Thanks
DS
Nov 13 '05 #1
5 1337
"DS" <bo******@optonline.net> wrote in message
news:yV*************@fe08.lga...
Where do you add a Sub-Report? To the detail Section?
Thanks
DS


Most often that's where they belong, but they could go anywhere. Sticking
to the polite locations to place them, suppose the main report was based on
Contacts and the sub-report was based on a related table ContactNotes, then
the detail section shows for each contact, and so if the subreport was here,
you'd see the related notes for each contact.
If however, you subreport showed a breakdown summary of your contacts table,
eg number of contacts per sales territory, then you could have this in a
report header, so you see an overall summary of the contacts followed by a
section for each contact.

Nov 13 '05 #2
DS
Eric Schittlipz wrote:
"DS" <bo******@optonline.net> wrote in message
news:yV*************@fe08.lga...
Where do you add a Sub-Report? To the detail Section?
Thanks
DS

Most often that's where they belong, but they could go anywhere. Sticking
to the polite locations to place them, suppose the main report was based on
Contacts and the sub-report was based on a related table ContactNotes, then
the detail section shows for each contact, and so if the subreport was here,
you'd see the related notes for each contact.
If however, you subreport showed a breakdown summary of your contacts table,
eg number of contacts per sales territory, then you could have this in a
report header, so you see an overall summary of the contacts followed by a
section for each contact.

Its not really a Sub Report. I tried putting it in details and got a
mess. I need it to be in its own section. I guess I'm trying to print
4 reports one after the other on the same report. Any ideas? Thanks.
DS
Nov 13 '05 #3
"DS" <bo******@optonline.net> wrote in message
news:Jh*************@fe08.lga...
Eric Schittlipz wrote:
"DS" <bo******@optonline.net> wrote in message
news:yV*************@fe08.lga...
Where do you add a Sub-Report? To the detail Section?
Thanks
DS

Most often that's where they belong, but they could go anywhere.
Sticking to the polite locations to place them, suppose the main report
was based on Contacts and the sub-report was based on a related table
ContactNotes, then the detail section shows for each contact, and so if
the subreport was here, you'd see the related notes for each contact.
If however, you subreport showed a breakdown summary of your contacts
table, eg number of contacts per sales territory, then you could have
this in a report header, so you see an overall summary of the contacts
followed by a section for each contact.

Its not really a Sub Report. I tried putting it in details and got a mess.
I need it to be in its own section. I guess I'm trying to print 4 reports
one after the other on the same report. Any ideas? Thanks.
DS

From the example above, imagine you wanted to produce a contact analysis
report where numbers of of contacts were broken down in 4 various ways, eg
by country, by sales territory, by industry type, etc then you could have 4
subreports on the main report. If the main report itself was not based on
any datasource - ie had a blank 'Record Source' property then it wouldn't
matter in which section you placed them - report header, detail or footer.
You simply place them one after the other.
I suppose the question is: Does the main report need a record source and if
so, how does it relate to the record source of the subreports.?


Nov 13 '05 #4
DS
Eric Schittlipz wrote:
"DS" <bo******@optonline.net> wrote in message
news:Jh*************@fe08.lga...
Eric Schittlipz wrote:
"DS" <bo******@optonline.net> wrote in message
news:yV*************@fe08.lga...
Where do you add a Sub-Report? To the detail Section?
Thanks
DS
Most often that's where they belong, but they could go anywhere.
Sticking to the polite locations to place them, suppose the main report
was based on Contacts and the sub-report was based on a related table
ContactNotes, then the detail section shows for each contact, and so if
the subreport was here, you'd see the related notes for each contact.
If however, you subreport showed a breakdown summary of your contacts
table, eg number of contacts per sales territory, then you could have
this in a report header, so you see an overall summary of the contacts
followed by a section for each contact.


Its not really a Sub Report. I tried putting it in details and got a mess.
I need it to be in its own section. I guess I'm trying to print 4 reports
one after the other on the same report. Any ideas? Thanks.
DS


From the example above, imagine you wanted to produce a contact analysis
report where numbers of of contacts were broken down in 4 various ways, eg
by country, by sales territory, by industry type, etc then you could have 4
subreports on the main report. If the main report itself was not based on
any datasource - ie had a blank 'Record Source' property then it wouldn't
matter in which section you placed them - report header, detail or footer.
You simply place them one after the other.
I suppose the question is: Does the main report need a record source and if
so, how does it relate to the record source of the subreports.?


The main report is based on a Query. I have 3 other "Sub-Reports" to
add to this main one.
DS
Nov 13 '05 #5

"DS" <bo******@optonline.net> wrote in message
news:jl***************@fe08.lga...
Eric Schittlipz wrote:
"DS" <bo******@optonline.net> wrote in message
news:Jh*************@fe08.lga...
Eric Schittlipz wrote:

"DS" <bo******@optonline.net> wrote in message
news:yV*************@fe08.lga...
>Where do you add a Sub-Report? To the detail Section?
>Thanks
>DS
Most often that's where they belong, but they could go anywhere.
Sticking to the polite locations to place them, suppose the main report
was based on Contacts and the sub-report was based on a related table
ContactNotes, then the detail section shows for each contact, and so if
the subreport was here, you'd see the related notes for each contact.
If however, you subreport showed a breakdown summary of your contacts
table, eg number of contacts per sales territory, then you could have
this in a report header, so you see an overall summary of the contacts
followed by a section for each contact.


Its not really a Sub Report. I tried putting it in details and got a
mess. I need it to be in its own section. I guess I'm trying to print 4
reports one after the other on the same report. Any ideas? Thanks.
DS


From the example above, imagine you wanted to produce a contact analysis
report where numbers of of contacts were broken down in 4 various ways,
eg by country, by sales territory, by industry type, etc then you could
have 4 subreports on the main report. If the main report itself was not
based on any datasource - ie had a blank 'Record Source' property then it
wouldn't matter in which section you placed them - report header, detail
or footer. You simply place them one after the other.
I suppose the question is: Does the main report need a record source and
if so, how does it relate to the record source of the subreports.?


The main report is based on a Query. I have 3 other "Sub-Reports" to add
to this main one.
DS


But still we don't know if they are related in any way and you don't give
any further clues as to what the report should look like. We don't know
whether you need to see a list of related data for each record in the main
datasource (like the contacts/contacts notes example) or whether the four
reports are self-contained (as per the last contact analysis example). This
makes such a big difference because you need to decide if you need entries
for the Link Master and Link Child Fields.
If the four reports are not related, then you could create a fifth report
(with a blank recordsource) and have the other four reports all as
subreports in the detail section (or in fact any other). Alternatively, put
the 3 subreports in the footer section of the first report making sure you
have no unnecessary Link Master and Link Child Fields entered.
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ian | last post: by
3 posts views Thread by Gheaci Maschl | last post: by
1 post views Thread by KEVIN97810 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.