override grid settings

[marcPCA]

Situation: a grid with a row expander that has linked grids.
for 2 of these linked grids i use the same grid only apply another filter.
I could choose to use 2 different grids but i like to have as few as possible and use them dynamicly.
I use the override grid settings for changing the filter and that works excellent

DBF.filter = "Type = \"Poortwachter\".AND.Ziekte_Percentage=0"

so far it works ok.
Also i want to hide a few columns in one of these grids using the override settings. I tried several options/notations
like:

field_info[6].Column.Hide = .t.
field_info[6]Column.Hide = .t.
field_info6Column.Hide = .t.
field_info6.Column.Hide = .t.

also all with tmpl. before it but it doesnt work

Also used the existing property like

with field_info[6]
	.Column.Hide = .t.
end with

somebody struggled with this?

[Davidk]

Re: override grid settings

In the onGridExecute event, use this:

e.tmpl.flagMustRecalculateGridLayoutAndControls = .t.
e.tmpl.field_info[2].Column.Hide = .t.

I didn't think you had to use the flagMust... etc. mainly because I haven't really seen it mentioned, but in my test grid it was needed. Look here for more information regarding the format of the Grid... e.g. Form

http://wiki.alphasoftware.com/How+to...outAndControls

[marcPCA]

Re: override grid settings

Hi David,

thanks for the help but i've seen this solution but i think it is not what i'm looking for. The problem is that i have to put that in the 'destination' grid. So to have it dynamicly i also need to send some vars because i do not always want to hide -say- column 2. If i can get it to work in the grid override settings i can use 1 grid several times and that it has several looks and i don't need to worry about sending the vars.
I if can't get it to work with override i'm going to try your suggested way. I guess then i've to "prepare" the grid with probably a select statement to change layout on run time, but i hope it can be easier (or am i thinking totally wrong?)

[Davidk]

Re: override grid settings

I'm not convinced this will work... it seems to be working but for some reason I'm not 100% sure of it. This is a grid with a row expander to open a child grid.

In the parent grid, in the Xbasic Function Declarations I have this function

function setHideCols as c (e as p)
     Dim cp as c
     cp = Left(e._currentRowDataNew.cover_period,1)
     e.session.colsToHide=cp
end function

cp means nothing - it's just picking up data from the grid... the data is "1 day", "2 day" etc. so I'm just grabbing the 1 or 2 to pass along to the child grid, telling it which column to hide.
And I'm setting a session variable to use in the child grid.

In the Parent Grid, in the Javascript System Events, in afterRowExpand, I have

//place this Javascript in your code, and then reference the rowNum variable.
var rowNum = {Grid.Object}._selectedRow;
{grid.Object}.ajaxCallback('G',rowNum,'setHideCols','','_getData=true');

In the Child Grid, Events, OnGridExecute, I have

Dim x as n
x = e.rv.Session.colsToHide

e.tmpl.flagMustRecalculateGridLayoutAndControls = .t.
e.tmpl.field_info[x].Column.Hide = .t.

The results should be that the 1st or 2nd column should be hidden depending on which row of the parent grid you expanded - because the data is either "1 Day" or "2 Day" in my data.
I've testing this with alerts in place to show me what's going on. It works. Taking the alerts out it doesn't work. I think it's a timing issue, but not sure yet.

[Davidk]

Re: override grid settings

I can get this to work if, on the parent grid, I select the row first, then expand it. Works every time. I've tried the ajax callback in the onRowSelect event, and the event does fire before the row gets expanded, but it doesn't work. Any ideas?

[marcPCA]

Re: override grid settings

Hi David
I figured it out. Thanks anyway for your effort and showing anotherway.

With this Alpha5 feature i can work very flexible. I created a (child) grid with all columns i need. In a parent grid I link to the child grid with the use of the row expander. I want to have several different views based on the same grid (only displaying other columns) .
In the override grid settings i hide the columns i don't want to see in a particular view (see attachement).
Like:

DBF.filter = "Type = \"Poortwachter\".AND.Ziekte_Percentage=0"     'override basic filter for this particular view
field_info[6].Column.Hide = .t.     'hide column 6
field_info[10].Column.Hide = .t.
field_info[11].Column.Hide = .t.
field_info[12].Column.Hide = .t.
field_info[13].Column.Hide = .t.
summary.Suppress= .t.               'column 13 has a summary section so this also has to be hidden
flagMustRecalcGridLayout = .t.      'make sure grid is adjusted

It was just finding the right syntax

[cptutrecht]

Re: override grid settings

Hi marc,

Thanks, this was what i needed just right now :-)

Only one thing, did you ever try to show collumns which are initially hidden?
It work for me, only the collumn header doesn't render properly

In my example the override settings are:

HasQuickSearch = .f.
field_info[7].Column.Hide = .t.
field_info[8].Column.Hide = .f.
field_info[8].Column.Header = "Contract Relatie"
field_info[8].Column.Sort = "kontrakt.KONTRAKT_huurder"
field_info[8].Column.InLineStyle = "vertical-align: top;"
flagMustRecalcGridLayout = .t. 'make sure grid is adjusted

but in the grid as collumn header {gridColumnTitle.KONTRAKT_HUURDER} is rendered. Rest works like a charm.

Of course i can stick with showing always all fields and hide when needed, but that is a little waist of effort because in 95% of the cases field 7 has to be shown and 8 must be hidden

UPDATE: if I use flagMustRecalculateAllProperties = .t. I get slightly better result: the collumn header renders the database field name: KONTRAKT_huurder, but of course this is not good enough...


thanks,

[cptutrecht]

Re: override grid settings

Found finally also a solution to standard hide fields and show them through overide settings when linking the grid

Don't use standard show/hide features in grid. Use instead advanced properties tab of the grid and put in a slightly different syntax:

tmpl.field_info[7].Column.Hide = .t.

in overide settings on can use then

field_info[7].Column.Hide = .f. with good results

[westridge]

Re: override grid settings

Using the syntax below hides the columns.

field_info[N1].Column.Hide = .t.
field_info[N2].Column.Hide = .t.
flagMustRecalcGridLayout = .t.

However, the summary "cells" for each hidden column still show.
The net effect is the summary column is shifted to the right, under the wrong column.

Anybody found a fix?