Ask Question
Home > DeveloperSection > Forums > How to get Next Record in SSRS
Manoj Pandey

Total Post:26

Points:188
Posted on    September-08-2016 1:12 AM

 C# Reporting  SQL Server 2012 
Ratings:


 1 Reply(s)
 820  View(s)
Rate this:
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
 

Manoj Pandey

Total Post:26

Points:188
Posted on    September-13-2016 7:05 AM

Finally 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







Modified On Sep-13-2016 07:07:12 AM
report abuse

Don't want to miss updates? Please click the below button!

Follow MindStick

Copyright © 2010 - 2015 MindStick Software Pvt. Ltd. All Rights Reserved.