Options

2 Level Matrix

casanovacasanova Member Posts: 194
edited 2014-11-20 in NAV Three Tier
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

Comments

  • Options
    deV.chdeV.ch Member Posts: 543
    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:
  • Options
    casanovacasanova Member Posts: 194
    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
  • Options
    deV.chdeV.ch Member Posts: 543
    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?
  • Options
    lakshanvindanalakshanvindana Member Posts: 79
    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 :)
    Lakshan Kulawansa
    ERP Consultant - MS Dynamics NAV
    https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/592
Sign In or Register to comment.