Page 1 of 1
Headings in CSV File
Posted: Thu Jun 05, 2014 6:56 am
by Anne_Phillips
I want to produce a CSV file which has the names of the next 24 months in the headings. eg July 2014, August 2014 etc. If I run it next month, I^d want the headings to start August 2014, September 2014 etc. ie the headings would be dependent on when I ran the report. Is there a way of doing this? We^re using 12.5.001 on a SQL database.
=> RE: Headings in CSV File
Posted: Tue Jun 24, 2014 9:26 am
by cstrasser
[updated:LAST EDITED ON Jun-24-14 AT 09:27 AM (EST)]There are a couple different ways of doing this.____The easiest is to set up the report so that its printed output looks like a CSV:____January 2014,February 2014,March 2014 ...__29391.22,38382.15,48821.99 ...____NOTE that this means you^d explicitly place commas between your data elements on the report layout.____Then, you would go to the export screen and export out the plain text (not text data). You^d also need to click on the last tab and check off "No Margins / Page Breaks.____Give the export filename a CSV extension and it should work as you expected.____As for the changing text of the months, you^d need to create calculated fields based on some starting date and format them appropriately.