[javax.net.ssl.SSLHandshakeException using Jasperreport Studio instead of iReport]

I had this issue and it was resolved more easily than the above solutions:

1. Close Studio.
2. Find the 'Jaspersoft Studio Professional.ini' file which should be found in the folder where Studio was installed.
3. Add the following line at the bottom of the 'Jaspersoft Studio Professional.ini' file:

 -Djsse.enableSNIExtension=false

 

[Currency symbol improperly displayed in JasperReports Server]

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%"/>

 

[List of recently viewed reports]

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

[Jasperreport server installs but can't do anything]

To use it in ie, this worked for me

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

[Jasper reports failing to load in IE 9]

This worked for me

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

[Dynamic List Input control in JasperReport 5]

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)

[How to get Last Viewed date programmatically]

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