Hello,

is there a way to export the data from the ledger into a SQL query (e.g. SQL-86) so that I can import the data into a RDBMS and can produce my own queries/reporting?
Alternatively a CSV file would do the trick as well.

I want to create my own reports that are not available in KMM.

Looking forward to hear from some experts.
TIA

I think the easiest way would be to do a Save As, and select the SQL back end of your choice. Just remember then to re-open your file based data, or KMM will continue to use the RDBMS.

Just did that, Save as... storage type 'SQL' Database Type: tried all 4 options. Every time KMM crashes without a notification why

If you run KMM from command line, you should get more of an error message, although I admit it might be somewhat cryptic. It's been a while since I did save as an SQL database, but some of the issues I remember had to do with database permissions - you might need to create the empty database, and then use that name when you do the SaveAs.