O'Reilly logo

Microsoft Dynamics NAV 2009 Programming Cookbook by Matt Traxinger

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a matrix form

A matrix shows information from multiple tables at the same time. This recipe will show you how to create a matrix that shows the amount a customer has spent on specific items.

How to do it...

  1. Add a global function CalculateData that returns a text variable.
  2. Add a global function ColumnHeader that returns a text variable.
    How to do it...
  3. Add a matrix box to the form.
  4. Set the following properties on the matrix box control:

    Property

    Value

    Name

    MatrixBox

    Editable

    No

    MatrixSourceTable

    Item

    How to do it...
  5. Set the following property on the form:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required