forum.mthbuilt.com

How does one print reports in landscape in your OS X version? I found a post somewhere that explains how to do this in windows by editing templates with a jrxml extension, however when I search my mac with that string, nothing comes up.

Hello,


Unfortunately changing report orientation is not a simple one-click operation, one would need to open report template manually and change parameters manually.

We have a wiki article published on how to do it on windows here - http://wiki.mthbuilt.com/How_to_customi ... and_height

If this is something that you think you would like to try we can update it with Mac information as well


Thanks

No problem, I just need to know what file on Mac to edit. Thanks in advance.

Absolutely, I would like to do this. Thanks in advance.

Hello,


We updated the wiki page with instructions for Mac,


Thanks,

You got me excited. Everything was easy to find and edit...added in the orientation="Landscape" into the editor. Opened up MyMoney, found the User Report, but alas still no Landscape. Portrait as usual. There must be another parameter in the file that I need to adjust? What else do you suggest?

I think we are almost there.

BTW...this and other custom reporting, I consider a very important feature of any financial software. It is one thing to collect data, but without a means of presenting it properly (landscape is a somple means to enable one to display more information on a given line than portrait), the application is kind of neutered! I am submitting a suggestion for more custom reporting features such as easy portrait/landscape, word wrap (for the comment field), 'Save as Favorite Report", etc. on your roadmap in future versions of MyMoney...pretty please!

Hello,

1) Did you flip width and height?

2) Custom reports: MyMoney will run user-designed reports, the format is open-sourced and we use industry standard reporting tools (iReport, etc)
here is the wiki article explaining how: http://wiki.mthbuilt.com/IReport_on_a_Mac

Thanks

Looks like a great tool, but I am having trouble connecting to MoneyDB. I downloaded your mth_derby.jar driver, and added it to 'Classpath'.

When I create a new Connection / Database:
DataSource Type: Database JDBC Connection
Name: MoneyDB
JDBC Driver: org.apache.derby.jdbc.EmbeddedDriver (THIS DRIVER DOES NOT EXIST IN THE LIST)
JDBC URL: jdbc:derby:/Users/********/Documents/*********/yemon/MyMoney/moneyDB

Checked into the "How_to_create_a_custom_Tax_report_in_My_Money#Some_common_problems_that_you_may_encounter_while_connecting_to_database_from_iReport", typed in "org.apache.derby.jdbc.EmbeddedDriver" as the JDBC Driver as the article suggested. Removed 'All Users", from my MyMoney, so it is no longer password protected.

However, cannot get a connection to the database. Typical, never, never, ever works the first time!

When I attempt a 'Test', regardless of just having to remove all password protection from MyMoney database, I still get prompted for a password. I choose blank <OK> as there is no database password set (the result of following the steps above to get rid of it), and then I get:

Exception

Message:
java.sql.SQLException: Failed to start database '/Users/*********/Documents/********/yemon/MyMoney/moneyDB' with class loader com.jaspersoft.ireport.designer.IRURLClassLoader@1bfc9484, see the next exception for details.
Level:
SEVERE
Stack Trace:
Failed to start database '/Users/********/Documents/********/yemon/MyMoney/moneyDB' with class loader com.jaspersoft.ireport.designer.IRURLClassLoader@1bfc9484, see the next exception for details.

yadda, yadda, jadda....

What am I missing here. I have followed the instructions to a tee, and obviously a step has been left out!

Many thanks in advance for your assistance.

It may be that the driver has gotten out of sync from MyMoney - let us try to reproduce the steps and see if we can connect to a sample database

We will keep you posted


Thanks

Great please do. Looking forward to hearing back from you.

Let me know if you need any help testing