Is it possible to use different datasets in the same region in the report.
Let's say I have 2 sources which I need to combine, I have a field in each
source I need to add together and see that result for a list of different
accounts.
I tried to do it in an expression choosing the datasets, It works with sums
but how to make it work with the single field and not the total ?
I get this error
g:\surround\reportingservice\axapta\test flere kilder\FlereKilder.rdl The
value expression for the textbox 'textbox12' contains an error: [BC30198]
')' expected.
Here is the Expression
= (Fields!VAREBELXB.Value, "DataSet1") + (Fields!VAREBELXB.Value, "C5_300")
Thx
JackNo, you can only get aggregated values from the other dataset that is not
bound to the region. I would gravitate toward doing the merging at the data
source.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Jack" <jackdSPAM@.jackd.dk> wrote in message
news:%2372mERr6FHA.636@.TK2MSFTNGP10.phx.gbl...
> Is it possible to use different datasets in the same region in the report.
> Let's say I have 2 sources which I need to combine, I have a field in each
> source I need to add together and see that result for a list of different
> accounts.
> I tried to do it in an expression choosing the datasets, It works with
> sums but how to make it work with the single field and not the total ?
> I get this error
> g:\surround\reportingservice\axapta\test flere kilder\FlereKilder.rdl The
> value expression for the textbox 'textbox12' contains an error: [BC30198]
> ')' expected.
> Here is the Expression
> = (Fields!VAREBELXB.Value, "DataSet1") + (Fields!VAREBELXB.Value,
> "C5_300")
>
> Thx
> Jack
>|||The problem is that it is from two different sources, one informix database
and one SQL database :(|||What a good reason to use SQL Server 2005 CLR stored procedures :-) Worse
come worse, I would combine the datasets at a application level and pass the
resulting ADO.NET dataset to the report using a custom data extension.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Jack" <jackdSPAM@.jackd.dk> wrote in message
news:O1$gLS26FHA.2628@.TK2MSFTNGP11.phx.gbl...
> The problem is that it is from two different sources, one informix
> database and one SQL database :(
>|||One of my colleagues thinks it's possible to make the solution in vb code,
but I don't know how to get the right data from the second dataset. There
has to be som filtering to get the right data to add, but I have no clue how
to do it in vb code.
Jack
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> skrev i en meddelelse
news:uIM7$e36FHA.472@.TK2MSFTNGP15.phx.gbl...
> What a good reason to use SQL Server 2005 CLR stored procedures :-) Worse
> come worse, I would combine the datasets at a application level and pass
> the resulting ADO.NET dataset to the report using a custom data extension.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Jack" <jackdSPAM@.jackd.dk> wrote in message
> news:O1$gLS26FHA.2628@.TK2MSFTNGP11.phx.gbl...
>> The problem is that it is from two different sources, one informix
>> database and one SQL database :(
>>
>|||I can see the idea of making a combined dataset in a dll with c sharp or
something, but how do I get this dataset into reporting services to use on
the layout tab ?
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> skrev i en meddelelse
news:uIM7$e36FHA.472@.TK2MSFTNGP15.phx.gbl...
> What a good reason to use SQL Server 2005 CLR stored procedures :-) Worse
> come worse, I would combine the datasets at a application level and pass
> the resulting ADO.NET dataset to the report using a custom data extension.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Jack" <jackdSPAM@.jackd.dk> wrote in message
> news:O1$gLS26FHA.2628@.TK2MSFTNGP11.phx.gbl...
>> The problem is that it is from two different sources, one informix
>> database and one SQL database :(
>>
>|||Another option is to link the Informix server as a linked server to your SQL
Server to submit a heterogeneous query (OPENQUERY or OPENROWSET).
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Jack" <jackdSPAM@.jackd.dk> wrote in message
news:OZHpRjD7FHA.736@.TK2MSFTNGP09.phx.gbl...
> One of my colleagues thinks it's possible to make the solution in vb code,
> but I don't know how to get the right data from the second dataset. There
> has to be som filtering to get the right data to add, but I have no clue
> how to do it in vb code.
> Jack
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> skrev i en meddelelse
> news:uIM7$e36FHA.472@.TK2MSFTNGP15.phx.gbl...
>> What a good reason to use SQL Server 2005 CLR stored procedures :-) Worse
>> come worse, I would combine the datasets at a application level and pass
>> the resulting ADO.NET dataset to the report using a custom data
>> extension.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Jack" <jackdSPAM@.jackd.dk> wrote in message
>> news:O1$gLS26FHA.2628@.TK2MSFTNGP11.phx.gbl...
>> The problem is that it is from two different sources, one informix
>> database and one SQL database :(
>>
>>
>
