alison.oxton

I had this issue and it was resolved more easily than the above solutions: Close Studio.Find the 'Jaspersoft Studio Professional.ini' file which should be found in the folder where Studio was installed.Add the following line at the bottom of the 'Jaspersoft Studio Professional.ini' file: -Djsse.enableSNIExtension=false

In /WEB-INF/applicationContext.xml Search for <util:map id="formatPatternsMap">Add the following keys to section ‘formatPatternsMap’: <entry key="¤ #,##0" value="$#,##0_);[Red]($#,##0)"/> <entry key="¤ #,##0.00" value="$#,##0.00_);[Red]($#,##0.00)"/> <entry key="¤ #,##0.0" value="$#,##0.00_);[Red]($#,##0.00)"/> <entry key="¤ #,##0;(¤ #,##0)" value="$#,##0_);[Red]($#,##0)"/> <entry key="#,##0 %" value="0%"/> <entry key="#,##0.00 %" value="0.00%"/>

If you have auditing turned on, you can use the jasper.jiauditevent and jasper.jiauditeventproperty tables

To use it in ie, this worked for me http://www.sevenforums.com/tutorials/1196-internet-explorer-compatibility-view-turn-off.html

This worked for me http://www.sevenforums.com/tutorials/1196-internet-explorer-compatibility-view-turn-off.html

You can also use regular expression if you are querying the database: WHERE customer_id IN ( SELECT REGEXP_SUBSTR($P{customer_id_list}, '[^,]+', 1, LEVEL) AS list_of_cids FROM dual CONNECT BY LEVEL <= REGEXP_COUNT($P{customer_id_list}, ',') + 1)

If you have auditing turned on, you could query the jiauditevent table?