2 Level Matrix

casanova

Hi all,
is that possible to create matrix form with 2 level?
columns usually show the date...
let say 01/08/13 02/08/13 03/08/13 ....................... and so on
but i want to differentiate the date become 2 : AM and PM
01/08/13 02/08/13 03/08/13
AM PM AM PM AM PM

to more clearly, please check my attachment
thx

deV.ch

I did something like this but its not a true 2-level structure. The only thing i was able to do, was to include the high level caption in the low level caption and separated them with a CR+LF, then the user can set the matrix caption to be 2-Row (Every user needs to set that because it is a user dependent UI setting).

You can see how it looks like in the picture attached:

casanova

deV.ch wrote:

I did something like this but its not a true 2-level structure. The only thing i was able to do, was to include the high level caption in the low level caption and separated them with a CR+LF, then the user can set the matrix caption to be 2-Row (Every user needs to set that because it is a user dependent UI setting).

You can see how it looks like in the picture attached:

but i need to separate it
1 column as 1 record
so.. it could be 01/08/2013 AM
and then next record could be 01/08/2013 PM

deV.ch

Well then you create a table with a Date and a Option/Text/Code field for AM/PM as PrimaryKey.
This table then could be used as a replacement for the virtual "Date" table which is usually used.
Would that work for you?

lakshanvindana

this is possible.

you need to add another column child group for your DATE group.
2 options :
option 1 : send "AM" & "PM" from Integer data item
option 2 : new child group create using Group Value "1"

let me know if not clear