Last post Nov 03, 2015 09:37 AM by Leo D.
Oct 28, 2015 03:32 PM|Leo D.|LINK
I know that I can use something like:
To get the first and last records of my dataset. However, how can I get the ones in between them? What if I have 9 or 10 other records, can it be done?
Thanks in advance,
Oct 30, 2015 04:42 AM|Krunal Parekh|LINK
You can use Lookup function for this.
Please see: https://msdn.microsoft.com/en-us/library/ee210531.aspx
this explains more:
=Lookup(13, Fields!ID.Value, Fields!Name.Value, "Product")
The above example will look for 13 ID in the Product dataset and then return the Name Value.
Nov 03, 2015 09:37 AM|Leo D.|LINK
Thanks Krunal. I appreciate.