---
title: "How to get  Next Record in SSRS"  
description: "How to get  Next Record in SSRS"  
author: "Manoj Pandey"  
published: 2016-09-08  
updated: 2016-09-13  
canonical: https://www.mindstick.com/forum/34173/how-to-get-next-record-in-ssrs  
category: "c#"  
tags: ["reporting", "sql server 2012"]  
reading_time: 1 minute  

---

# How to get  Next Record in SSRS

I am creating a report Which Show [Previous](https://yourviews.mindstick.com/view/81421/unlock-2-0-is-just-like-previous-corona-lockdowns),Current and Next id on Report. We can get Previous id via **Preveious([Fields](https://www.mindstick.com/forum/159126/sql-query-for-all-tables-and-fields-in-an-oracle-db)!Id.Value)** but how can get next Id. Here is no [function as](https://www.mindstick.com/forum/212/can-be-declare-a-static-function-as-virtual) [Crystal report](https://www.mindstick.com/articles/930/crystal-report-in-visual-studio-2010) **Next(Fields!ID.value)** in [ssrs](https://www.mindstick.com/articles/12008/creating-ssrs-sql-server-reporting-service-in-mssql-server-2014) ![How to get  Next Record in SSRS](https://www.mindstick.com/mindstickforums/a0a73eb0-a911-456d-84a7-f96f0d7a8587/images/557c4e0e-40f1-44cc-abba-be4d5e94c1f4.png)

## Replies

### Reply by Manoj Pandey

Finally I have found solution

First you have need add Rownumber in query.

![How to get  Next Record in SSRS](https://www.mindstick.com/mindstickforums/a0a73eb0-a911-456d-84a7-f96f0d7a8587/images/d1a86933-efc1-4cbe-8e47-95186f71a93b.png)

Now add below code in Next id textbox expression-

=Lookup(Fields!Row.Value+1,Fields!Row.Value,Fields!ID.Value,"YourDatSetName")

Now result is -:

![How to get  Next Record in SSRS](https://www.mindstick.com/mindstickforums/a0a73eb0-a911-456d-84a7-f96f0d7a8587/images/07ce10d2-5fcd-4172-b91f-4fb49855bf7b.png)

**Note : Don't use RowNumber(FieldName, "YourDatasetName") instead of Row.**

## Thanks\

\

\


---

Original Source: https://www.mindstick.com/forum/34173/how-to-get-next-record-in-ssrs

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.