O'Reilly logo

Building Dashboards with Microsoft Dynamics GP 2016 - Second Edition by Mark Polino, Belinda Allen

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

Merging columns

There will be occasions where you'll want to combine columns together to form a new column. Although it may be advantageous for the data to be separated in a database, it's not always the way we want to see our data in reports. A good example of this in GP is employee and salespeople information. There is a field for the first name and a separate field for the last name in the database. While reporting, we want a single field that uses the whole name, which leaves us with the task of merging these two columns (or fields) together. Using the data, we've already extracted, let's combine the city, state, and zip code for our vendors into a single field:

  1. In Query Editor, select the Vendors query in the Queries pane.
  2. Let's keep the original ...

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