Can we insert colour in matrix form??

vyanku
vyanku Member Posts: 791
edited 2007-05-15 in NAV/Navision Classic Client
Hi,
Can we insert colour in matrix form ??
like in analysis by dimension form if we select dimension in row and dimension in column. and if the reconsile sites are populated in some other colour it is very usful to find the reconsile site.

Comments

  • Waldo
    Waldo Member Posts: 3,412
    You can use colors in Matrix forms.

    Just go to the OnFormat trigger of the textbox inside your matrix box and write your code...

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Waldo
    Waldo Member Posts: 3,412
    Some useful code:
    CurrForm.Qty.UPDATEFORECOLOR := 16711680;
CurrForm.Qty.UPDATEFONTBOLD := TRUE;

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • vyanku
    vyanku Member Posts: 791
    Thats great.
    But how can I identify that the sites are reconsile.
    Because when the amount of two site becomes equal then only the colour should be changed.
  • Waldo
    Waldo Member Posts: 3,412
    Then I guess you should manually calculate the other site ... .

    Can you explain more what you try to achieve?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • DenSter
    DenSter Member Posts: 8,307 
    IF Qty1 = Qty2 THEN BEGIN
  CurrForm.Qty.UPDATEFORECOLOR := 16711680;
  CurrForm.Qty.UPDATEFONTBOLD := TRUE;
END;
    :?:
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • vyanku
    vyanku Member Posts: 791
    No.
    Actually in intersite reconsilation we have dimension in row and dimension in column.
    Problem is how to identify the same values from different columns from matrix form.

    Because in matrix form there is only one veriable for amount .

Categories