How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
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 |
Mention what are the core components of ssrs?
How to backup SQL Server Reporting Services ?
What is bookmark link in ssrs?
What are cascading parameters in ssrs reports?
Would you store your query in a ssrs report or a database server? State the reason why?
What are the new features of sql server 2012 reporting service?
What is the name of reporting services config file and what’s it’s used for?
What are the types of ssrs?
In which sql server version report builder introduced?
What are the export options of ssrs?
Can we deploy SSRS reports on our personal website?
How to create percentile function?