SSRS - Related datasets

Question

Hi,

I have two Datasets: Dataset1 and Dataset2.

Dataset1 retrieves only one record (Fields are - For example -: ID, Name)

Dataset2 need to retrieves some records based on the ID field of the first Dataset.

Note that both Datasets fields are used on Placeolder expresions (On TextBox), I mean, not within table, charts...

Is that possible? If so how?

Regards,

Bader

Answer 1

create a parameter

name para_YourTable_Id

type integer

Default value -> Dataset1.Id

Then in dataset 2, change your query for

select whatEverField

From WhatEverTable

where Id = @para_YourTable_Id

Alex

Answer 2

Hi Bader,

In your scenario, Alex’s suggestion is exactly right. Add a filter to dataset2 can also give you the same result. Add a filter into dataset2 like below:
Expression: ID
Operator:  =
Value: @para_YourTable_Id

Besides, you can use lookup function in the textbox to do it. The expression looks like below:
=lookup(fields!ID.Value, fields!ID.Value, fields!ColumnName.Value, ”DataSet2”)
For more information about lookup function, please see:
http://msdn.microsoft.com/en-us/library/ee210531.aspx

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedbackhere.