"chieko" <chieko@discussions.microsoft.com> wrote in message
news:34A18DAA-DC21-4075-9F4F-CB1838D13C98@microsoft.com...
> Bruce,
>
> How can I create a single report with multiple datasets ?
> I did lot of research on this but I can't find any information...
>
> Thanks in advance
>
> Chieko
> "Bruce L-C [MVP]" wrote:
>
>> The steps you should go through is to first develop your subreport as a
>> stand alone report with parameters. Test and make sure it works. Then
>> decide
>> how you want to make the subreport parameters when it is embedded in a
>> report. For instance, are you mapping a parameter of the subreport to a
>> field of a dataset? Are you mapping it to a parameter in the main report?
>>
>> My suggestion is to back up and make sure you know how to do this before
>> attempted 11 subreports. Plus, note that you do not have to use
>> subreports
>> just because you have multiple datasets. You can have multiple datasets
>> in a
>> single report and it is faster not to use subreports unless you have to.
>>
>> You want a step by step but I cannot solve you problem for you. The steps
>> themselves are straight forward which does not mean solving you problem
>> is.
>> Steps:
>> 1. Create report to use as subreport as a stand alone report with
>> parameters. Test report.
>> 2. Drag report onto containing report.
>> 3. Right mouse click on subreport, parameters (menu might be called
>> something else, I am doing this from memory). Map your subreport
>> parameters
>> to either the containing report parameters or to a field in the
>> containing
>> report.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Eskimo" <Eskimo@discussions.microsoft.com> wrote in message
>> news:72A4A30B-40F8-452A-ABDE-951023693421@microsoft.com...
>> > *hello* I asked for a how-to
>> > step by step example please....
>> >
>> > I have 11 tables that are not related in a 1-1-1 in a traditional sense
>> >
>> > but are related as
>> > party 0..n address4party
>> > address4party 1.1 address
>> > address 1..1 address type
>> > address 1..1 cities
>> > address 1..1 states
>> > address 1..1 county
>> > party 0..n email
>> > party 0..n phones 1..1 phone type
>> >
>> > and I don't get to change the database relation(s) around as "addresses
>> > are
>> > not related to phones, emails, etc. but to parties."
>> >
>> > --
>> > tym, Eskimo
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Hmmm. I never saw that. What I have always done is drag the report I
>> >> want
>> >> as
>> >> a subreport onto the report. On the right where you have the list of
>> >> reports
>> >> just click on it, drag and drop.
>> >>
>> >> Then right click on it to set the parameters.
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
>> >> news:OjB6sihiFHA.3328@TK2MSFTNGP10.phx.gbl...
>> >> > In the toolbar there is a subreport control... Drag it to the report
>> >> > like
>> >> > you would a text box, and click it to configure...
>> >> >
>> >> > --
>> >> > Wayne Snyder, MCDBA, SQL Server MVP
>> >> > Mariner, Charlotte, NC
>> >> > www.mariner-usa.com
>> >> > (Please respond only to the newsgroups.)
>> >> >
>> >> > I support the Professional Association of SQL Server (PASS) and it's
>> >> > community of SQL Server professionals.
>> >> > www.sqlpass.org
>> >> >
>> >> > "Eskimo" <Eskimo@discussions.microsoft.com> wrote in message
>> >> > news:C19A9761-1B3F-42AC-B103-7E71802D300A@microsoft.com...
>> >> >> Hi,
>> >> >>
>> >> >> I have a report I want to add subreports to....but the books online
>> >> >> are
>> >> >> worthless in this regard of a howto...any help?
>> >> >>
>> >> >> --
>> >> >> tym, Eskimo
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

"chieko" <chieko@discussions.microsoft.com> wrote in message
news:83580A60-B2F7-4A4D-A07E-2FF321E82AA1@microsoft.com...
> Thanks for your quick response.
> Yes, I read sub-report articles, but all examples show using input
> parameter.
> Is it possible to create a sub report (or parent-child report ) without
> input parameter?
>
> What I want to create is that a report which displays a store name (Parent
> report) and 8 chiled reports within 1 page.
>
> What would be the best approach to create such a report?
>
> Thanks
> Chieko
>
> "Bruce L-C [MVP]" wrote:
>
>> It is easy to create a report with multiple datasets. I believe the issue
>> is
>> that you want to join the datasets and you cannot do that. What you can
>> do
>> is to have two reports, one embedded inside another. Multiple datasets is
>> easy (but you cannot use the report wizard for this). In the dataset tab
>> you
>> click on the ... and you will see an option for another dataset. Then you
>> drag another table in the layout and drag and drop fields. Again, this is
>> multiple datasets, it is not two datasets joined together. Multiple
>> datasets
>> work great for the situation where the user specifies parameters that
>> return
>> one record for the first dataset and then these parameters will return
>> multiple records for the second dataset. I.e. 1-M where I am only showing
>> one record on the left side and all the corresponding records on the
>> right.
>>
>> Have you read up on subreports?
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "chieko" <chieko@discussions.microsoft.com> wrote in message
>> news:34A18DAA-DC21-4075-9F4F-CB1838D13C98@microsoft.com...
>> > Bruce,
>> >
>> > How can I create a single report with multiple datasets ?
>> > I did lot of research on this but I can't find any information...
>> >
>> > Thanks in advance
>> >
>> > Chieko
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> The steps you should go through is to first develop your subreport as
>> >> a
>> >> stand alone report with parameters. Test and make sure it works. Then
>> >> decide
>> >> how you want to make the subreport parameters when it is embedded in a
>> >> report. For instance, are you mapping a parameter of the subreport to
>> >> a
>> >> field of a dataset? Are you mapping it to a parameter in the main
>> >> report?
>> >>
>> >> My suggestion is to back up and make sure you know how to do this
>> >> before
>> >> attempted 11 subreports. Plus, note that you do not have to use
>> >> subreports
>> >> just because you have multiple datasets. You can have multiple
>> >> datasets
>> >> in a
>> >> single report and it is faster not to use subreports unless you have
>> >> to.
>> >>
>> >> You want a step by step but I cannot solve you problem for you. The
>> >> steps
>> >> themselves are straight forward which does not mean solving you
>> >> problem
>> >> is.
>> >> Steps:
>> >> 1. Create report to use as subreport as a stand alone report with
>> >> parameters. Test report.
>> >> 2. Drag report onto containing report.
>> >> 3. Right mouse click on subreport, parameters (menu might be called
>> >> something else, I am doing this from memory). Map your subreport
>> >> parameters
>> >> to either the containing report parameters or to a field in the
>> >> containing
>> >> report.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Eskimo" <Eskimo@discussions.microsoft.com> wrote in message
>> >> news:72A4A30B-40F8-452A-ABDE-951023693421@microsoft.com...
>> >> > *hello* I asked for a how-to
>> >> > step by step example please....
>> >> >
>> >> > I have 11 tables that are not related in a 1-1-1 in a traditional
>> >> > sense
>> >> >
>> >> > but are related as
>> >> > party 0..n address4party
>> >> > address4party 1.1 address
>> >> > address 1..1 address type
>> >> > address 1..1 cities
>> >> > address 1..1 states
>> >> > address 1..1 county
>> >> > party 0..n email
>> >> > party 0..n phones 1..1 phone type
>> >> >
>> >> > and I don't get to change the database relation(s) around as
>> >> > "addresses
>> >> > are
>> >> > not related to phones, emails, etc. but to parties."
>> >> >
>> >> > --
>> >> > tym, Eskimo
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Hmmm. I never saw that. What I have always done is drag the report
>> >> >> I
>> >> >> want
>> >> >> as
>> >> >> a subreport onto the report. On the right where you have the list
>> >> >> of
>> >> >> reports
>> >> >> just click on it, drag and drop.
>> >> >>
>> >> >> Then right click on it to set the parameters.
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in
>> >> >> message
>> >> >> news:OjB6sihiFHA.3328@TK2MSFTNGP10.phx.gbl...
>> >> >> > In the toolbar there is a subreport control... Drag it to the
>> >> >> > report
>> >> >> > like
>> >> >> > you would a text box, and click it to configure...
>> >> >> >
>> >> >> > --
>> >> >> > Wayne Snyder, MCDBA, SQL Server MVP
>> >> >> > Mariner, Charlotte, NC
>> >> >> > www.mariner-usa.com
>> >> >> > (Please respond only to the newsgroups.)
>> >> >> >
>> >> >> > I support the Professional Association of SQL Server (PASS) and
>> >> >> > it's
>> >> >> > community of SQL Server professionals.
>> >> >> > www.sqlpass.org
>> >> >> >
>> >> >> > "Eskimo" <Eskimo@discussions.microsoft.com> wrote in message
>> >> >> > news:C19A9761-1B3F-42AC-B103-7E71802D300A@microsoft.com...
>> >> >> >> Hi,
>> >> >> >>
>> >> >> >> I have a report I want to add subreports to....but the books
>> >> >> >> online
>> >> >> >> are
>> >> >> >> worthless in this regard of a howto...any help?
>> >> >> >>
>> >> >> >> --
>> >> >> >> tym, Eskimo
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>