|Posted: 05/24/2011, 12:00 PM
When you use an SQL statement, you may get "...not counted" instead of the count of the grid's rows. Here's a quick and dirty way to get the count you need.
Add code such as the following in a BeforeExecuteSelect Event.
$myCountSQL="select count(*) from (".$oldSQL.") as CountTable";
Change the "MyGridName" to the name of your grid. That's it.