IReport on a Mac
From MTHWiki
| Line 12: | Line 12: | ||
Before starting to use iReport please create a folder on your system where you will be keeping your custom reports and call it 'CustomReports' or similar. | Before starting to use iReport please create a folder on your system where you will be keeping your custom reports and call it 'CustomReports' or similar. | ||
| - | Please locate MyMoney on your system (most likely in Applications folder) and right click on it to see "Show Package Contents". Please navigate inside on the package, please | + | Please locate MyMoney on your system (most likely in Applications folder) and right click on it to see "Show Package Contents". Please navigate inside on the package and copy a system report that you would like to edit, for example to edit report that categorizes transactions please locate '''categorized_p100.jrxml''' under Contents/Resources/system/reports/built-in |
| + | |||
| + | Please also copy report syles file called '''styles.jrtx''' | ||
| + | |||
| + | To connect to MyMoney database you will need to get a special database driver, you can get it from MTH Website at [http://www.mthbuilt.com/iReport/mth_derby.jar] Please save this file to the CustomReports folder as well. | ||
| - | Please copy a system report that you would like to edit, for example to edit report that categorizes transactions please locate categorized_p200.jrxml under Contents/Resources/system/reports/built-in | ||
At this point your CustomReports folder should look like the following: | At this point your CustomReports folder should look like the following: | ||
| Line 22: | Line 25: | ||
| - | To start using iReport with MyMoney you will need to setup the datasource in iReport first. Please start iReport and select | + | To start using iReport with MyMoney you will need to setup the datasource in iReport first. Please start iReport and select preferences, then iReport then Classpath (2nd tab after the General). Please add derby.jar to your classpath by clicking on add JAR then navigating to CustomReports folder and then selecting derby.jar |
| + | |||
| + | |||
| + | To setup new Datasource please click on "Report Datasources" button, it is usually located next to the "Empty Datasource/Sample Datasource" choice list. | ||
| + | |||
When prompted please make the following choices: | When prompted please make the following choices: | ||
DataSource Type: Database JDBC Connection | DataSource Type: Database JDBC Connection | ||
| + | |||
| + | Name: MoneyDB | ||
| + | |||
| + | JDBC Driver: org.apache.derby.jdbc.EmbeddedDriver | ||
| + | |||
| + | JDBC URL: this should be location to your database, for example jdbc:derby:/Users/username/Desktop/Test/Test/moneyDB | ||
Revision as of 04:39, 22 January 2011
Introduction
My Money is using JasperReports as its Reporting engine. Jasper is open sourced, actively developed, has a large community of users and is generally generally well understood (wikipedia) piece of software code. We at MTH Software like it and trust it enough to embed it into our own software.
To actually design a report for My Money you need a front-end software for Jasper reports, there is a bunch of 3rd party tools we prefer iReport, it is free, relatively fast and seems to be bug free.
iReport on Mac
Please download iReport for Mac, you can get it from JasperForge, please get the latest version.
Before starting to use iReport please create a folder on your system where you will be keeping your custom reports and call it 'CustomReports' or similar.
Please locate MyMoney on your system (most likely in Applications folder) and right click on it to see "Show Package Contents". Please navigate inside on the package and copy a system report that you would like to edit, for example to edit report that categorizes transactions please locate categorized_p100.jrxml under Contents/Resources/system/reports/built-in
Please also copy report syles file called styles.jrtx
To connect to MyMoney database you will need to get a special database driver, you can get it from MTH Website at [1] Please save this file to the CustomReports folder as well.
At this point your CustomReports folder should look like the following:
To start using iReport with MyMoney you will need to setup the datasource in iReport first. Please start iReport and select preferences, then iReport then Classpath (2nd tab after the General). Please add derby.jar to your classpath by clicking on add JAR then navigating to CustomReports folder and then selecting derby.jar
To setup new Datasource please click on "Report Datasources" button, it is usually located next to the "Empty Datasource/Sample Datasource" choice list.
When prompted please make the following choices:
DataSource Type: Database JDBC Connection
Name: MoneyDB
JDBC Driver: org.apache.derby.jdbc.EmbeddedDriver
JDBC URL: this should be location to your database, for example jdbc:derby:/Users/username/Desktop/Test/Test/moneyDB
