Hi, not sure this is the correct method but it works if I add this to each hidden column on the grid..

$col["editrules"] = array("edithidden"=>true);

Thanks

This remove from list, but shows in add/edit/view.
If your grid is readonly, following would suffice.
$col["editrules"] = array("edithidden"=>true);

Otherwise, you can just set:
$col["show"]["list"] = false;

Remove $col["hidden"] = true; if it is there. This would hide it through out.

Thanks Abu, just for reference is there any way to view all table without setting edit to true as above? Guess I am wondering if I can maybe create a link on client name for example which would pop up a form all that rows data in, regardless of the cols hidden? Giving users access to edit would bypass the read only?

You can still set following with editable to false.
$col["show"]["list"] = false;
$col["show"]["view"] = true;

Hi Abu, I added the below to the page and set edit to false, should there be a an icon in actions columns to allow me to view details?

$col = array();
$col["title"] = "Title"; // caption of column
$col["name"] = "Title"; // grid column name
$col["show"]["list"] = false;
$col["show"]["view"] = true;
$cols[] = $col;

Currently view icon is not there with row, Instead you can select and click toolbar button.
You can also connect dblclick row with view dialog show.

Refer: How to show "Edit Record" or "View Record" dialog on row double click / Show dialog on row edit button? in FAQs

How-Tos & FAQs

Brilliant Abu, that is perfect