Group in grid?

[t4nu]

Hi,
If I want to create a group in grid, what should I do?
What I mean with create group is that evertime certain code in certain field change then the value of that field will occupy the whole row (that row look like merged).

I notice that I can use repeater, but it seems if I want to change the size of certain field, I have to adjust other fields too.

I thought something combining repeater with table, but don't know how to put the value from repeater (as group) to datasource criteria used in table.

Thanks in advance for the help.

[Jon]

The conventional way to do this is to use Nested Tables. There is an example of this in the Ebase Xi Vault http://vault.ebasetech.com/ebase/vaultD ... dRepeaters you can download this straight into a V5 designer by using Help > Ebase Xi Vault.

You need two Ebase tables - one for your groups probably just containing the group name, and one for the rest of your data including the group name. Then you can display the outer table (groups) as a Repeater Control with the inner table (your data) inside it displayed either as a Table Control or a Repeater Control. For the inner Table/Repeater Control configure the Filter Expression property something like: groups-groupname = data-groupname (this is FPL syntax).

You can have problems of alignment using this technique, though these can usually be fixed by setting explicit widths for the columns. If all else fails you always have the option of using two Repeaters with custom layouts, then you can use any HTML you like.

[t4nu]

Thank you very much, Jon.
as usual your answer solved my problem.
I use the repeater and table as the solution.

The conventional way to do this is to use Nested Tables. There is an example of this in the Ebase Xi Vault http://vault.ebasetech.com/ebase/vaultD ... dRepeaters you can download this straight into a V5 designer by using Help > Ebase Xi Vault.

You need two Ebase tables - one for your groups probably just containing the group name, and one for the rest of your data including the group name. Then you can display the outer table (groups) as a Repeater Control with the inner table (your data) inside it displayed either as a Table Control or a Repeater Control. For the inner Table/Repeater Control configure the Filter Expression property something like: groups-groupname = data-groupname (this is FPL syntax).

You can have problems of alignment using this technique, though these can usually be fixed by setting explicit widths for the columns. If all else fails you always have the option of using two Repeaters with custom layouts, then you can use any HTML you like.