Interested to Buy Any Domain ? << Click Here >> for more details...
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
- 1 Answers
- 186 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to deploy the Report?
What is a dataset and what are the different types of datasets?
How to make conditional sum in ssrs?
What are parameterized reports? What are cascading parameters in ssrs reports?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
how to create “alternate row colour”?
What new data source types were added in ssrs 2014?
Can I disable or restrict ssrs export formats (rendering formats)?
How to identify current user in ssrs report?
Explain how you can deploy an SSRS report?
How would you go about developing a ssrs report?
What is the report model project?
SSRS SQL Server Reporting Services 
