May 18, 2009 at 4:24 am
Hi
I have a problem with use of Dataset multiple.
I would want to create a 'similar' join between two dataset various in the visual Studio 2005 (development Tool)
I would have to associate cod- 1*dataset with cod - 2*dataset
I would want put up results:
1* Dataset
- Cod
- Name
2* dataset
- cod
- prod
result:
Cod , Name, prod
May 18, 2009 at 8:47 am
Is there any reason why you can't just do this all in one query in your database using a Join?
Instead of creating 2 datasets, just create one dataset and in the query do something like the following...
Select t1.cod, t1.Name, t2.Prod
FROM table1 as t1
INNER JOIN table2 t2
ON t1.cod = t2.cod
-Luke.
January 22, 2013 at 12:54 pm
It is recommended to use one query using JOINS, but if that is not possible, you can use LOOKUP in SSRS 2008 R2. Lookup is not available in SSRS 2008 or prior versions.
You can write an expression like:
=Lookup(Fields!cod.Value, Fields!cod.Value, Fields!prod.Value, "dataset2")
August 31, 2013 at 8:17 am
If you could use SSRS 2008 R2 or later version, you can utilize the SSRS Lookup features that joins multiple datasets. Follow the below link to use multiple datasets in report using LOOKUP:
http://www.sqlcircuit.com/2012/03/ssrs-2008-r2-lookup-how-to-use-multiple.html
Thanks,
Vishal
October 14, 2013 at 11:49 am
Luke L (5/18/2009)
Is there any reason why you can't just do this all in one query in your database using a Join?Instead of creating 2 datasets, just create one dataset and in the query do something like the following...
Select t1.cod, t1.Name, t2.Prod
FROM table1 as t1
INNER JOIN table2 t2
ON t1.cod = t2.cod
-Luke.
I agree with Luke L. Try constructing a single dataset to have all data available and then utilize it. Lookup, Shared Dataset is not available in 2005.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply