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

HOW TO GET NEXT RECORD IN SSRS

Manoj Pandey

Total Post:26

Points:188
Posted by  Manoj Pandey
C#
 1197  View(s)
Ratings:
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
 
  1. Manoj Pandey

    Post:26

    Points:188
    Re: How to get Next Record in SSRS

    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 Apr-11-2018 05:11:53 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!

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