CSV file from a Report

troy.harkness@hotmail.com

I am trying to develop a report that the End User can initiate so that the Check Ledger Entry table is sorted by Check Date. I have all of my columns needed by the Bank, and I have been able to get all of the data exactly the way I want it. The issue I am having is I cannot figure out how to get the code written to export the report as a CSV. I cannot have it as one long line of data, I need it be line for line just as it is in the Check Ledger Entry table. Attached is all of the code that I have that is working for other fields needed.


as well as the fields from the Check Ledger Entry table I am using.

edoderoo

With the XML-port you can define an export in XML pretty easily. Also a CSV-file can me made there, see https://docs.microsoft.com/en-us/dynamics-nav/walkthrough--exporting-data-from-tables-to-csv-files for extra info.