how to link multiple datasets's parameters?

I created three datasets. Every one has the same parameter and I need to link
them together. How to do it?
Thx.You can create a global report parameter and link it to the parameters in
your query. See the sample Sales Invoice report included in the RS samples.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Mia" <Mia@.discussions.microsoft.com> wrote in message
news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>I created three datasets. Every one has the same parameter and I need to
>link
> them together. How to do it?
> Thx.|||Where do I find these sample reports?
I can't find any mention of global report parameters in BOL
"Teo Lachev [MVP]" wrote:
> You can create a global report parameter and link it to the parameters in
> your query. See the sample Sales Invoice report included in the RS samples.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >I created three datasets. Every one has the same parameter and I need to
> >link
> > them together. How to do it?
> >
> > Thx.
>
>|||Install the sample reports that come with RS. With RS 2000, there should be
a link to the installer in the Reporting Services group. I called them
"global" because they are report-level parameters.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"David" <David@.discussions.microsoft.com> wrote in message
news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> Where do I find these sample reports?
> I can't find any mention of global report parameters in BOL
> "Teo Lachev [MVP]" wrote:
>> You can create a global report parameter and link it to the parameters in
>> your query. See the sample Sales Invoice report included in the RS
>> samples.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Mia" <Mia@.discussions.microsoft.com> wrote in message
>> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>> >I created three datasets. Every one has the same parameter and I need to
>> >link
>> > them together. How to do it?
>> >
>> > Thx.
>>|||OK, I have that report and opened it.
There is 2 datasets and each datasets as the same parameter name in the query.
Is the Global Report Paremeter, that you are refering to, this dialog box:
REPORT>REPORT PARAMETERS
If so, how do you go about linking this parameter to the parameters in your
query?
Normally, when you create the parameter in your query, it appears
automatically in this dialog box. But what do you do if it doesn't?
"Teo Lachev [MVP]" wrote:
> Install the sample reports that come with RS. With RS 2000, there should be
> a link to the installer in the Reporting Services group. I called them
> "global" because they are report-level parameters.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "David" <David@.discussions.microsoft.com> wrote in message
> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> > Where do I find these sample reports?
> >
> > I can't find any mention of global report parameters in BOL
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> You can create a global report parameter and link it to the parameters in
> >> your query. See the sample Sales Invoice report included in the RS
> >> samples.
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >> >I created three datasets. Every one has the same parameter and I need to
> >> >link
> >> > them together. How to do it?
> >> >
> >> > Thx.
> >>
> >>
> >>
>
>|||1. You use a placeholder for this parameter in your dataset query, e.g.:
WHERE (SOH.SalesOrderNumber = @.SalesOrderNumber)
2. You open the dataset properties and in the Parameters tab you link the
query parameter to the report-level parameter, like so:
Name Value
-- ---
@.SalesOrder Header =Parameters!SalesOrderNumber.Value
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"David" <David@.discussions.microsoft.com> wrote in message
news:168C68E8-B032-4668-9AB3-A52EBB4E3342@.microsoft.com...
> OK, I have that report and opened it.
> There is 2 datasets and each datasets as the same parameter name in the
> query.
> Is the Global Report Paremeter, that you are refering to, this dialog box:
> REPORT>REPORT PARAMETERS
> If so, how do you go about linking this parameter to the parameters in
> your
> query?
>
> Normally, when you create the parameter in your query, it appears
> automatically in this dialog box. But what do you do if it doesn't?
>
> "Teo Lachev [MVP]" wrote:
>> Install the sample reports that come with RS. With RS 2000, there should
>> be
>> a link to the installer in the Reporting Services group. I called them
>> "global" because they are report-level parameters.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "David" <David@.discussions.microsoft.com> wrote in message
>> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
>> > Where do I find these sample reports?
>> >
>> > I can't find any mention of global report parameters in BOL
>> >
>> > "Teo Lachev [MVP]" wrote:
>> >
>> >> You can create a global report parameter and link it to the parameters
>> >> in
>> >> your query. See the sample Sales Invoice report included in the RS
>> >> samples.
>> >>
>> >> --
>> >> HTH,
>> >> ---
>> >> Teo Lachev, MVP, MCSD, MCT
>> >> "Microsoft Reporting Services in Action"
>> >> "Applied Microsoft Analysis Services 2005"
>> >> Home page and blog: http://www.prologika.com/
>> >> ---
>> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
>> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>> >> >I created three datasets. Every one has the same parameter and I need
>> >> >to
>> >> >link
>> >> > them together. How to do it?
>> >> >
>> >> > Thx.
>> >>
>> >>
>> >>
>>|||Thank You!
Thank You!
Thank You!
I have been having a hell of a time trying to figure out the solution top
this problem.
I was developing a report that had the WHERE clause hard code with a value.
Once I completed development, I change the hard code to a parameter. RS would
not recognize it as a parameter and kept telling my variables were unbound.
I was all over the net and this forum trying to find the answer.
"Teo Lachev [MVP]" wrote:
> 1. You use a placeholder for this parameter in your dataset query, e.g.:
> WHERE (SOH.SalesOrderNumber = @.SalesOrderNumber)
> 2. You open the dataset properties and in the Parameters tab you link the
> query parameter to the report-level parameter, like so:
> Name Value
> -- ---
> @.SalesOrder Header =Parameters!SalesOrderNumber.Value
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "David" <David@.discussions.microsoft.com> wrote in message
> news:168C68E8-B032-4668-9AB3-A52EBB4E3342@.microsoft.com...
> > OK, I have that report and opened it.
> >
> > There is 2 datasets and each datasets as the same parameter name in the
> > query.
> >
> > Is the Global Report Paremeter, that you are refering to, this dialog box:
> > REPORT>REPORT PARAMETERS
> >
> > If so, how do you go about linking this parameter to the parameters in
> > your
> > query?
> >
> >
> > Normally, when you create the parameter in your query, it appears
> > automatically in this dialog box. But what do you do if it doesn't?
> >
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> Install the sample reports that come with RS. With RS 2000, there should
> >> be
> >> a link to the installer in the Reporting Services group. I called them
> >> "global" because they are report-level parameters.
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "David" <David@.discussions.microsoft.com> wrote in message
> >> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> >> > Where do I find these sample reports?
> >> >
> >> > I can't find any mention of global report parameters in BOL
> >> >
> >> > "Teo Lachev [MVP]" wrote:
> >> >
> >> >> You can create a global report parameter and link it to the parameters
> >> >> in
> >> >> your query. See the sample Sales Invoice report included in the RS
> >> >> samples.
> >> >>
> >> >> --
> >> >> HTH,
> >> >> ---
> >> >> Teo Lachev, MVP, MCSD, MCT
> >> >> "Microsoft Reporting Services in Action"
> >> >> "Applied Microsoft Analysis Services 2005"
> >> >> Home page and blog: http://www.prologika.com/
> >> >> ---
> >> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> >> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >> >> >I created three datasets. Every one has the same parameter and I need
> >> >> >to
> >> >> >link
> >> >> > them together. How to do it?
> >> >> >
> >> >> > Thx.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

How to link datasets for reporting?

I have 2 datasets for a single report. One dataset(1) returns value(s), the
second dataset(2) has many records for each value(s) of dataset(1). Yes, one
to many. On the report I wish to display a result of dataset(1) with a
wrapping text box with the many values of dataset(2), then pagebreak and page
two will be the next result of dataset(1) with the many records of dataset(2)
in a wrapbox etc... I have a key column in both datasets. I need to first
figure out how to link them and use the data on report as I described. thanks
!!Read up on subreports. That is how to solve this problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"T" <T@.discussions.microsoft.com> wrote in message
news:5722C5FE-4DD1-4FAA-ACF8-86FCA2B15ACA@.microsoft.com...
>I have 2 datasets for a single report. One dataset(1) returns value(s),
>the
> second dataset(2) has many records for each value(s) of dataset(1). Yes,
> one
> to many. On the report I wish to display a result of dataset(1) with a
> wrapping text box with the many values of dataset(2), then pagebreak and
> page
> two will be the next result of dataset(1) with the many records of
> dataset(2)
> in a wrapbox etc... I have a key column in both datasets. I need to
> first
> figure out how to link them and use the data on report as I described.
> thanks
> !!|||I have come across similar scenarios and tried to solved it with two
datasets, but each time I come back to include alla data in one "flat"
dataset and use gropuing instead.
Ex. If you have one dataset with adresses and one dataset with related phone
numbers. Like:
Adress
1, "MyStreet", "MyCity"
2, "MySecondStreet", "MyCity"
Phone
1, 1, "Phone", "+46-123456"
2, 1, "Fax", "+46-8-232323"
3, 2, "Phone", "+46-654321"
4, 2, "Fax", "+46-8-44444"
Then join them into one dataset instead of two, like:
1, "MyStreet", "MyCity", 1, 1, "Phone", "+46-123456"
1, "MyStreet", "MyCity", 2, 1, "Fax", "+46-8-232323"
2, "MySecondStreet", "MyCity", 3, 2, "Phone", "+46-654321"
2, "MySecondStreet", "MyCity", 4, 2, "Fax", "+46-8-44444"
Create a new Report using this Dataset.
Set property "HideDuplicates = true" on the Adress columns.
Create a group with "AddressId" as group value, if you like to SUM some
values one on "adress-level"
This way you "simulate" related datasets.
Regards Martin Bring
**********************
"T" wrote:
> I have 2 datasets for a single report. One dataset(1) returns value(s), the
> second dataset(2) has many records for each value(s) of dataset(1). Yes, one
> to many. On the report I wish to display a result of dataset(1) with a
> wrapping text box with the many values of dataset(2), then pagebreak and page
> two will be the next result of dataset(1) with the many records of dataset(2)
> in a wrapbox etc... I have a key column in both datasets. I need to first
> figure out how to link them and use the data on report as I described. thanks
> !!