Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2010-02-15 : 10:16:19
|
| Hi I have a table and want to include data from different datasets on the same row.For instance:=iif(First(Fields!Unit_Long_Name.Value, "Unit_Code") = Fields!MemCaption.Value, First(Fields!Unit.Value, "Unit_Code"), "")This doesnt work as it brings the first result in the table, is it possible to scan through all instead of just returning the first.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-15 : 10:46:07
|
| nope. this is not possible inside report. why cant you bring these related data together from dataset itself?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2010-02-15 : 10:49:36
|
Because one dataset contains data that comes from a 3rd party application the company has invested in. Its like financial consolidation tool. I can do it with subreport in the same table - matrix but for exports this doesnt work in 2005. So just trying to add via query from different dataset to see if it makes difference.Any other ideas?quote:
Originally posted by visakh16
nope. this is not possible inside report. why cant you bring these related data together from dataset itself?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-15 : 10:54:13
|
| Is there any way by which you can get the data imported on to a temporary table in your system and then use it in join?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2010-02-15 : 10:58:14
|
No its not possible, otherwise would have done that awhile ago :(quote:
Originally posted by visakh16
Is there any way by which you can get the data imported on to a temporary table in your system and then use it in join?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-15 : 11:28:32
|
| do you need to do row by row processing or are you trying for some aggregation from other dataset?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2010-02-15 : 11:29:35
|
Row by row pleasequote:
Originally posted by visakh16
do you need to do row by row processing or are you trying for some aggregation from other dataset?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
|
|
|
Multi dataset table links