Monthly Feature
Each month we will describe a different feature of our software. Please come back and see each feature as they are posted.
CSV REPORT GENERATOR
Our CSV report generator can report on any file in the Energy-Pro or Fuel-Pro systems. It allows the user to enter selection criteria for the program to select the records in the data file they want. It also allows them to select the fields of data they want to export out of the data files. All the export fields will go into an Excel .CSV file. The program will even start Excel and display the data on the screen. Once in Excel the user can do whatever needs to be done with the data including printing it.
CSV REPORT GENERATOR
Our CSV report generator can report on any file in the Energy-Pro or Fuel-Pro systems. It allows the user to enter selection criteria for the program to select the records in the data file they want. It also allows them to select the fields of data they want to export out of the data files. All the export fields will go into an Excel .CSV file. The program will even start Excel and display the data on the screen. Once in Excel the user can do whatever needs to be done with the data including printing it.
Selection Line:
The above report will make a list of all “Will Call” customers (schedule = ‘W’)that have not had a delivery since March 15, 2012 (date_lastd < {03/15/12}).
Output Line:
The output from this report will include the customer’s account number, name, date of last delivery and their phone number.
The output file is read in by Excel and will be displayed as below:
The above report will make a list of all “Will Call” customers (schedule = ‘W’)that have not had a delivery since March 15, 2012 (date_lastd < {03/15/12}).
Output Line:
The output from this report will include the customer’s account number, name, date of last delivery and their phone number.
The output file is read in by Excel and will be displayed as below:
When done the program will ask if you want to save the report criteria so it can be reran at any time.