How to Add Serial Numbers to a Grid Widget with an SQL Server Data Connection

Published:

This article will guide you through adding serial numbers to a grid widget with an SQL Server data connection.

It is important to note that the solution presented in this article is specifically created for the SQL Server data connection.

Create the following expression in the expression designer to generate the serial numbers and Configure the created expression in the grid widget.
Expression syntax : CAST(ROW_NUMBER() OVER(ORDER BY (SELECT SUM(1))) as varchar)
On the context menu of the setting icon, select Sort.
Select the Data Source order in the advanced sorting options to sort the specific column based on the data source order.
The specific column sorting will be updated, as shown in the following image.