Skip or Hide Row in bvbgrid

[udgeet]

If value of specific field is NULL in Row then i have to skip whole row associated with this field value. How to achieve this in bvbgrid.

[imonteiro]

Hi,

You can't do this in your query?

[udgeet]

Well,
I can change in query but it's too too complex because i have to use rollup and total of all column values and hide the row having associated null valued column . so if there's some functionality in grid to hide whole row based on some specific column it would be better.

[imonteiro]

Isn't the perfect solution, but for now you can achieve this using $grid->addClassRowCondition() to hide to row by css:
http://stackoverflow.com/questions/1144123/how-can-i-hide-an-html-table-row-tr-so-that-it-takes-up-no-space

I would prefer achieve this using SQL query. You can SUM based on a subquery... but it will depend of what you want. I found this two topics:
http://stackoverflow.com/questions/8757061/sumsubquery-in-mysql
http://stackoverflow.com/questions/7562873/sum-a-subquery