DB LOOK UP

Hello,
Is there a way to use something like LOOKUP COMBO in reporting services.
What I want to do is, to be able to GO AND LOOK FOR some value from another
table
in a report..
The report name is mainreport
mainreport :
[Product Code] 1243
Intervention# LabourCost MaterialCost
43 5$ 3$
45 7$ 8$
SUBTOTAL
#interventions:2 12$ 11$ --> Can
we make a lookup to SALES table where we can find
--> sales QTY of product 1243'
SALES : 50 ,
2*100/50 = %4
[Product Code] xxxxx
....
Thank you so much!This is a basic heterogeneous (cross dataset) join, which are not in the
current version of Reporting Services. Is there no way you can do the join
in the query?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"zitus" <zitus@.community.nospam> wrote in message
news:%23xiY4KoNFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Is there a way to use something like LOOKUP COMBO in reporting services.
> What I want to do is, to be able to GO AND LOOK FOR some value from
> another
> table
> in a report..
> The report name is mainreport
> mainreport :
> [Product Code] 1243
> Intervention# LabourCost MaterialCost
> 43 5$ 3$
> 45 7$ 8$
> SUBTOTAL
> #interventions:2 12$ 11$ -->
> Can
> we make a lookup to SALES table where we can find
> --> sales QTY of product 1243'
> SALES : 50 ,
> 2*100/50 = %4
> [Product Code] xxxxx
> ....
> Thank you so much!
>|||I will try..
Will it be possible in SP2 ? or RS2005 ? ( cross dataset )
"Brian Welcker" <bwelcker@.online.microsoft.com> wrote in message
news:e2KVbXoNFHA.644@.TK2MSFTNGP14.phx.gbl...
> This is a basic heterogeneous (cross dataset) join, which are not in the
> current version of Reporting Services. Is there no way you can do the join
> in the query?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "zitus" <zitus@.community.nospam> wrote in message
> news:%23xiY4KoNFHA.1396@.TK2MSFTNGP10.phx.gbl...
> > Hello,|||Sorry, no.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"zitus" <zitus@.community.nospam> wrote in message
news:u$MW8doNFHA.2736@.tk2msftngp13.phx.gbl...
>I will try..
> Will it be possible in SP2 ? or RS2005 ? ( cross dataset )
> "Brian Welcker" <bwelcker@.online.microsoft.com> wrote in message
> news:e2KVbXoNFHA.644@.TK2MSFTNGP14.phx.gbl...
>> This is a basic heterogeneous (cross dataset) join, which are not in the
>> current version of Reporting Services. Is there no way you can do the
>> join
>> in the query?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "zitus" <zitus@.community.nospam> wrote in message
>> news:%23xiY4KoNFHA.1396@.TK2MSFTNGP10.phx.gbl...
>> > Hello,
>