Seems to work. thanks.
Btw i have following sql for the Properties table
SELECT ....
FROM Properties INNER JOIN Units ON Units.UnitPropertyID = Properties.PID GROUP BY Properties.PID ORDER BY Units.UnitName ASC, Units.UnitSize ASC
And for PropertiesTotal when I use the above SQL, pagination is not visible.
this works & display pagination:
.. FROM Properties INNER JOIN Units ON Units.UnitPropertyID = Properties.PID ORDER BY Units.UnitName ASC, Units.UnitSize ASC
Why is it so when i use GROUP IN SQL for Total it doesnt work.