Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting Services - Dataset multiple Expand / Collapse
Author
Message
Posted Monday, May 18, 2009 4:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 18, 2009 9:44 AM
Points: 1, Visits: 5
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

Post #718915
Posted Monday, May 18, 2009 8:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 07, 2014 4:50 PM
Points: 2,897, Visits: 5,966
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.


To help us help you read this

For better help with performance problems please read this
Post #719136
Posted Tuesday, January 22, 2013 12:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 6:41 AM
Points: 110, Visits: 184
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")
Post #1410234
Posted Saturday, August 31, 2013 8:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 11:19 PM
Points: 5, Visits: 52
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
Post #1490389
Posted Monday, October 14, 2013 11:49 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 6:12 PM
Points: 827, Visits: 342
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.
Post #1504501
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse