How to get Next Record in SSRS
4995
08-Sep-2016
I am creating a report Which Show Previous,Current and Next id on Report. We can get Previous id via Preveious(Fields!Id.Value) but how can get next Id. Here is no function as Crystal report Next(Fields!ID.value) in ssrs
Updated on 13-Sep-2016
Manoj Pandey
13-Sep-2016Finally I have found solution
First you have need add Rownumber in query.
Now add below code in Next id textbox expression-
=Lookup(Fields!Row.Value+1,Fields!Row.Value,Fields!ID.Value,"YourDatSetName")
Now result is -:
Note : Don't use RowNumber(FieldName, "YourDatasetName") instead of Row.
Thanks