Export data from two or more tables to Excel

nikin878
nikin878 Member Posts: 2
edited 2024-01-16 in NAV Three Tier
Hi everyone,
In Dynamics NAV 2015, I need to export information from two tables (e.g Vendor or Customer) to Excel, but depending on the checkbox checked, I must show the information from one or the other table, or both. Is it possible to do this through a report?
How can I define both tables in the DataItem?
Or is it better to use another type of object for this type of requirement?
Thank you so much.

Answers

  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • rsaritzky
    rsaritzky Member Posts: 469
    You can do this in a report, but to get it to Excel, you'll have to use the Excel functions the Excel Buffer table (Table 370).

    You might be better off using an XMLPort, which can export directly to Excel.

    Your comment said "depending on the checkbox checked, I want to show info from one or the other table." If you're talking about before running the export, you want to prompt the user for the "checkbox", for either a report or an XMLPort, you can create a Request Page that has the "checkbox". Then you can add simple logic to bypass either the customer or vendor information as part of the export.
    Ron

Categories