Having the ability to customize the views of your data is an important component to mrc’s tools, and the CSV output feature is no exception.
And, formatting the CSV output in your applications is easy to do with the m-Painter feature.
To start, go to the Manage Reports screen, and click the paint icon next to the report you wish to alter.
Then, in the painter toolbar, click the PAGE drop down list on the right side of the screen.
Click the ‘CSV and XML Output’ option.
Now, in this section we can determine whether we are showing grand total level values, adding Total Level Calculations, and the like.
Scroll to the very bottom of the file (after END_DATATABLE_XML) .
To make the changes you want, just remove the appropriate substitution. Make sure to leave the “”, as it will hold the place of the data you just removed and keeps the structure of your file intact.
In this example, I will remove the customer number from the grand total level as I am not interested in the overall sum of each customer number.
Save the file, and execute.
*Note: if you ever overwrite the .html on a recompile, the changes you have just made will be erased.”
Here is the final product:
Note that in the grand total line, the customer number has not been summed.
Total Level Calculations in CSV Files
Now, if you’d like, you are also able to utilize Total Level Calculations in a CSV file. To do this, you would use the F_EXPR expression. If you would like to add F_EXPR you would insert it in the same section you edited above. Be sure to remove any quotations around the F_EXPR.