[RESOLVED] serial no in datareport

[amrita]

I think the only way to add a serial number is to make it a part of the query.Check this

SELECT (select count(a2.emp_no) from tblEMP as a2 
where a1.emp_no<=a2.emp_no) AS [SL No], 
a1.name, a1.address FROM account AS a1 
GROUP BY a1.emp_no, a1.name, a1.address
ORDER BY a1.emp_no DESC