How to make serial No. in PDF report?

Scriptcase 9
#1

I want to make serial No. automatically in PDF report as existing data
like this screen shoot:

image
image273×769 2.84 KB

image
image439×840 112 KB

There is any code to make serial No.?

#2

Hi, you can do this in your query for example. This is for Mysql

select name,
      @rownum := @rownum + 1 as row_number
from your_table
cross join (select @rownum := 0) r
order by name
2 Likes
#3

Thank you very much for your response, But It shows me this error

image
image1567×403 24 KB

#4

Many thanks .
Itried it again, and It worked very good.