Another Newbie Question about Reports: how to export?

Build and share your cool customized reports built w/ one sql, Chart.js and Lua

Moderator: Renato

Post Reply
User avatar
aragorn7773
New MMEX User
Posts: 15
Joined: Tue Jul 20, 2021 8:41 pm
Are you a spam bot?: No

Another Newbie Question about Reports: how to export?

Post by aragorn7773 »

Hi,
I'm brand new to MMEX and am trying to figure out how to export a report to a CSV file after I have run it. I can print to pdf but I need the report in CSV so that I an separate things out for my accountant.

Is there a way to save a report to a CSV file?

If so, would someone please show me how?

Thank you so much.

Allen
MartinArmstrong
MVP MMEX User
Posts: 300
Joined: Tue Mar 02, 2021 10:24 am
Are you a spam bot?: No

Re: Another Newbie Question about Reports: how to export?

Post by MartinArmstrong »

1. In MMEX, select all the text of the report you want to export (column headings and number rows).

2. CTRL+C to copy to clipboard

3. In Excel (or your preferred spreadsheet app), CTRL+V to paste.

4. It should be formatted OK but, if not, make any required adjustments.

5. 'Save As' and set the 'Save as type' to CSV.
User avatar
aragorn7773
New MMEX User
Posts: 15
Joined: Tue Jul 20, 2021 8:41 pm
Are you a spam bot?: No

Re: Another Newbie Question about Reports: how to export?

Post by aragorn7773 »

This is a most unusual way to export to csv but ok, I'll use it

That you Martin 😊 😊

UPDATE:

Got it. It works just as you said. Strange, however, to have to print reports this way. Very strange way for such a mature application.
User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Another Newbie Question about Reports: how to export?

Post by Renato »

The file format CSV stands for Comma-separated values and describes the structure of a text file for storing or exchanging simply structured data.
From my point of view, CSV is certainly not intended for storing reports.
MMEX offers .CSV for exporting the stored data.
Renato Forum Administrator
dbolton
Super MMEX User
Posts: 126
Joined: Fri Jan 03, 2020 3:24 pm
Are you a spam bot?: No
Contact:

Re: Another Newbie Question about Reports: how to export?

Post by dbolton »

aragorn7773, out of curiosity, what are you using the CSV files for?
User avatar
aragorn7773
New MMEX User
Posts: 15
Joined: Tue Jul 20, 2021 8:41 pm
Are you a spam bot?: No

Re: Another Newbie Question about Reports: how to export?

Post by aragorn7773 »

Since we cannot sort the reports by more than 1 column, I was going to export the report to CSV and start separating my reports by Month and by Type so that I could do totals for the Months and Grand Totals for the Year.

Is there a way to do Transaction Summary Reports that summarize each month's Revenues and Expenses and that give a Yearly Summation of Revenues and Expenses?
MartinArmstrong
MVP MMEX User
Posts: 300
Joined: Tue Mar 02, 2021 10:24 am
Are you a spam bot?: No

Re: Another Newbie Question about Reports: how to export?

Post by MartinArmstrong »

Is there a way to do Transaction Summary Reports that summarize each month's Revenues and Expenses and that give a Yearly Summation of Revenues and Expenses?

That ought to be doable in MMEX via the General Report Manager. Hopefully someone will be along to point you to an example report that you can import (and modify if required).
User avatar
aragorn7773
New MMEX User
Posts: 15
Joined: Tue Jul 20, 2021 8:41 pm
Are you a spam bot?: No

Re: Another Newbie Question about Reports: how to export?

Post by aragorn7773 »

Thx Martin 😊
User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Another Newbie Question about Reports: how to export?

Post by Renato »

You can also make such reports with Excel.
for example, retrieve all bookings in Excel and evaluate them with Power Pivot.
Here is an example of an account balance:
.
viewtopic.php?f=10&t=9549&p=20427&hilit=odbc#p20427
Renato Forum Administrator
User avatar
aragorn7773
New MMEX User
Posts: 15
Joined: Tue Jul 20, 2021 8:41 pm
Are you a spam bot?: No

Re: Another Newbie Question about Reports: how to export?

Post by aragorn7773 »

Thx Renato,

I have found a couple of reports in MMEX that look like what I need.

Categories Summary

that one helps me the most as along as I have setup my categories well.
Post Reply