[2 different Database in one report]

I have been looking into doing something similar and found this wiki helpful. 

http://community.jaspersoft.com/wiki/how-use-two-different-connections-databases-ireport

 

 

[Currency format not working]

The pattern for currency is ¤ #,##0.00         EXAMPLE <textField pattern="¤ #,##0.00">

When exporting to excel I get a weird pattern so I change it to this - $ #,##0.00        EXAMPLE <textField pattern="$ #,##0.00"> 

Why are you adding " " to the variable? 

[exporting to excel with unprotected worksheet by default]

I am trying to make my exported excel report editable by default. How can I turn the protection off so that it will allow editing by default?

 

**UPDATE I noticed that if I run a report in ireport 3.7.4 the excel output is unprotected and if I run the very same report in ireport 5.1 it is now protected so that leads me to believe that it is a setting in the exporter or ireport itself. I checked every setting in ireport and could not find anything that would fit this problem.

**UPDATE 2 I am pretty sure it has to do with the report export engine and what version of POI is running. Also I found that sometimes it will export as unprotected in the xlsx format. I am going to say it is a bug in 5.1 with the version of POI.

Thoughts anyone?