Matrix - hiding rows/columns

polonious
polonious Member Posts: 64
edited 2008-12-11 in NAV/Navision Classic Client
Hi Guys,

Hope you can help! I've got a Matrix form with customers listed on the left, and sales (by Product Group) across the right side of the Matrix form. What I need to be able to do is, a) hide customers that have 0 sales, and b) hide Product Groups that have also had no sales. Can anyone think of a good way to do this, particularly (b).

Thanks in advance.

Polo

Comments

  • kine
    kine Member Posts: 12,562
    It is problem, because only visible cells are calculated and if you want to do this, you will need to calculate all cells. But you can use some temporary table where you will prepopulate the values and make the selection. It means when opening the form, there will be some process filling this temp table (with appropriate progress dialog) and after that, the matrix box will open with only needed data. But do not forget, that there can be theoretically unlimited records in both directions and it is why this requirements is not easy to do...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • polonious
    polonious Member Posts: 64
    Thanks Kine, I had thought of a temporary table, but wasn't sure if there was an easier way. Will give it a go.

    Thanks.

Categories