Excel Buffer table - AddInfoColumn vs AddColumn?

Mike_HWG
Mike_HWG Member Posts: 104
edited 2011-10-27 in NAV/Navision Classic Client
(NAV 5.0 SP1)

I've been learning how to output to Excel from a report by using report 10145 Item Sales by Customer as an example.

I noticed that they make use of AddInfoColumn() and AddColumn().

Can you tell me when I would want to use one of the functions over the other?
Michael Hollinger
Systems Analyst
NAV 2009 R2 (6.00.34463)

Answers

  • SPost29
    SPost29 Member Posts: 148
    Mike,
    If you export report 10145 to excel,
    you will see an information sheet and a data sheet.
    Info you want on the information sheet uses AddInfoColumn

    Data you want on the data sheet use AddColumn
    notice the type of information on either sheet

    Steve

    PS I use AddColumn 95% of the time
  • Mike_HWG
    Mike_HWG Member Posts: 104
    That makes sense, especially since I don't see a way to create more than the two sheets without adding modification to the Excel Buffer table.

    Thanks, sir. :thumbsup:
    Michael Hollinger
    Systems Analyst
    NAV 2009 R2 (6.00.34463)

Categories