Reporting Services - Dataset multiple

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » Reporting Services - Dataset multiple

Reporting Services - Dataset multiple

Rate Topic

Display Mode

Topic Options

Author

Message

02perla

Posted Monday, May 18, 2009 4:24 AM

Forum 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

Luke L

Posted Monday, May 18, 2009 8:47 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:12 PM
Points: 2,891, Visits: 5,857

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

Syed Asim Rizvi

Posted Tuesday, January 22, 2013 12:54 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 12:48 PM
Points: 109, Visits: 155

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

« Prev Topic | Next Topic »

Permissions