To find a value from another dataset based on the current dataset field in

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

Question Posted / Ramesh Kumar

1 Answers
179 Views
I also Faced
E-Mail Answers

Answer Posted / Ramesh Kumar

To find a value from another dataset based on the current dataset field in SSRS 2008 R2, you can use Lookup functions. The Lookup function allows you to reference a value from a different dataset within the same report.nnSyntax:=Fields!FieldName.Value From (LookupName, "SortExpression", "FilterExpression", DataSetName)nnFor example:n=Fields!ProductID.Value From (SubDataSet, "ProductID = @ProductID", "", "Dataset1")

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !! You can

Post New Questions

Answer Questions in Different Category