Having this Challenge in NAV Report

luceo

The Entry Type field of the Item ledger Entry table is an Option field, which has the following values; Purchase, Sales, Positive Adjmt, Negative Adjmt, Transfer, consumption, and Output. I am creating a report that will show all these option values as the Header of each column. I am finding it difficult to do these, how do I go about this. Assist me with codes and everything. The report should look something like this.

Items Description | Purchase | Sales | Positive Adjmt | Negative Adjmt | Transfer | Consumption | Output |
football

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

vijay_g

what did you try? i don't think any implications to develop this report if you are a technical. can you please be specific where are you having issue would be easy to help you. Thanks!

xStepa

I think, that he wants to group the Item Ledgers by Item No. (& Location, Years, ...)

Duikmeester

Sounds like a matrix too me. Use the Entry Type as columns and Item No./Description as rows. Then whatever you want inside the cells.

Belias

if Duikmeester guessed what you want to do, it can easily be done throw table wizard, by setting rows, columns Groups and cells