Where do you add a Sub-Report? To the detail Section?
Thanks
DS
Thanks
DS
-
-
Re: Sub Reports
"DS" <bootybox@opton line.net> wrote in message
news:yVord.58$9 94.13@fe08.lga. ..[color=blue]
> Where do you add a Sub-Report? To the detail Section?
> Thanks
> DS[/color]
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.
-
Re: Sub Reports
Eric Schittlipz wrote:[color=blue]
> "DS" <bootybox@opton line.net> wrote in message
> news:yVord.58$9 94.13@fe08.lga. ..
>[color=green]
>>Where do you add a Sub-Report? To the detail Section?
>>Thanks
>>DS[/color]
>
>
> 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.
>
>
>[/color]
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
Comment
-
Re: Sub Reports
"DS" <bootybox@opton line.net> wrote in message
news:Jhqrd.63$C P4.19@fe08.lga. ..[color=blue]
> Eric Schittlipz wrote:[color=green]
>> "DS" <bootybox@opton line.net> wrote in message
>> news:yVord.58$9 94.13@fe08.lga. ..
>>[color=darkred]
>>>Where do you add a Sub-Report? To the detail Section?
>>>Thanks
>>>DS[/color]
>>
>>
>> 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.
>>
>>
>>[/color]
> 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[/color]
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.?
Comment
-
Re: Sub Reports
Eric Schittlipz wrote:[color=blue]
> "DS" <bootybox@opton line.net> wrote in message
> news:Jhqrd.63$C P4.19@fe08.lga. ..
>[color=green]
>>Eric Schittlipz wrote:
>>[color=darkred]
>>>"DS" <bootybox@opton line.net> wrote in message
>>>news:yVord.5 8$994.13@fe08.l ga...
>>>
>>>
>>>>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.
>>>
>>>
>>>[/color]
>>
>>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[/color]
>
>
>
> 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.?
>
>
>
>
>
>[/color]
The main report is based on a Query. I have 3 other "Sub-Reports" to
add to this main one.
DS
Comment
-
Re: Sub Reports
"DS" <bootybox@opton line.net> wrote in message
news:jlvrd.302$ IY7.118@fe08.lg a...[color=blue]
> Eric Schittlipz wrote:[color=green]
>> "DS" <bootybox@opton line.net> wrote in message
>> news:Jhqrd.63$C P4.19@fe08.lga. ..
>>[color=darkred]
>>>Eric Schittlipz wrote:
>>>
>>>>"DS" <bootybox@opton line.net> wrote in message
>>>>news:yVord. 58$994.13@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
>>>>ContactNote s, 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[/color]
>>
>>
>>
>> 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.?
>>
>>
>>
>>
>>
>>[/color]
> The main report is based on a Query. I have 3 other "Sub-Reports" to add
> to this main one.
> DS[/color]
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.
Comment
Comment