The grouping feature is somewhat limited in JQGrid (js component from github) as it works with paging.
You need to have high number of records in grid page to work properly.

Footer summary is doable but with some code level changes.

So this mean, in grouping we can use sql query with where clause, correct? Also can you please provide code to show Footer summary?
Thanks in Advance

Footer summary with grouping is not ready to release. It's still in development.
However another version of footer summary without grouping is available, that shows listing total, sub-total, grand total etc.

Ok will wait for release of footer summary with grouping. But still for grouping I am unable to use where condition with dynamic variables. Like for example: "SELECT * FROM table WHERE id=".$id, if we hardcode id then its works but not for dynamic. Please help
Thanks

Please check faq question in faq page.
Q) How to load grid based on $_POST data from other page?

yes now post values work with version, can you please provide code for
"footer summary without grouping is available, that shows listing total, sub-total, grand total etc."
Thanks

I've emailed you the demo.

Thanks for demo, but the script doesn't work for me nothing shows in footer, I think JS functions of to set footer Data doesn't work. Please help.
Thanks

This is available as a part of paid version.

Here is the link for demo
http://www.phpgrid.org/demo/demos/appearence/footer-row.php

can you please provide code for
"footer summary without grouping is available, that shows listing total, sub-total, grand total etc."
Thanks

I've emailed you latest build.