<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0"
					xmlns:content="http://purl.org/rss/1.0/modules/content/"
					xmlns:wfw="http://wellformedweb.org/CommentAPI/"
					xmlns:dc="http://purl.org/dc/elements/1.1/"
					xmlns:atom="http://www.w3.org/2005/Atom"
					xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
				  >
<channel>
<title><![CDATA[Latest Topics]]></title>
<link>http://jasperforge.org/</link>
<description><![CDATA[Forge Latest forum topics]]></description>
<image><title><![CDATA[Latest Topics]]></title>
<link>http://jasperforge.org/</link>
<url>http://jasperforge.org/themes/jasper/images/tools/logo.gif</url>
</image>
<language></language>
<pubDate>Sat, 11 Feb 2012 15:52:16 +0000</pubDate>
<item>
<title><![CDATA[LDAP authentication with sub organization]]></title>
<link>http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95492</link>
<pubDate>Fri, 10 Feb 2012 16:30:05 +0000</pubDate>
<description><![CDATA[<p>We have Jasper-pro. In Jasper, we have created the following org structure:</p>
<p>Our_Org (single organizatin)</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; SubA</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubA1</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubA2&nbsp;</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; SubB</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubB1</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubB2</p>
<p>In stead of getting Org structure info from LDAP and synchronize, we want the user to type-in the predefined org_name (i.e. SubA, or SubA1)&nbsp; and authenticate the user&nbsp;into that&nbsp;org directly.</p>
<p>Anyone has done this or something similar? My thinking is to&nbsp;pass the org_id from login page&nbsp;to <span lang="EN">defaultOrganizationIfNotDetected in applicationContext-multiTenancy-security.xml... </span>&nbsp;Is it possible? How can it be done? Am I heading down the wrong path? Could someone point me to the right direction, please?&nbsp; Thanks.</p>
<p>&nbsp;</p>
<p>&nbsp;</p>]]></description>
<guid isPermaLink="true" >http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95492</guid>
</item>
<item>
<title><![CDATA[RESTful api support in jasper reports 4.5.0 community version]]></title>
<link>http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95488</link>
<pubDate>Fri, 10 Feb 2012 14:43:10 +0000</pubDate>
<description><![CDATA[<p>&nbsp;I was going through the examples in&nbsp;JasperReports-Server-Web-Services-Guide.pdf and all was working until I got to the example on page 24. &nbsp;</p>
<p><span style="font-size: 9.000000pt; font-family: 'CourierNewPSMT'">GET /jasperserver-pro/rest/resource/images/JRLogo?file=attachment HTTP/1.1</span></p>
<p>I entered into my browser:</p>
<p><span style="font-size: 9pt; font-family: CourierNewPSMT; "><a href="http://jasperadmin:jasperadmin@localhost:8080/" target="_blank">http://jasperadmin:jasperadmin@localhost:8080/</a></span><span style="font-family: CourierNewPSMT; ">jasperserver/rest/resource/images/JRLogo?file=attachment</span><span style="font-family: CourierNewPSMT; font-size: 9pt; ">&nbsp; &nbsp;</span></p>
<p>as the example described, but instead of downloading the JRLogo file I was displayed the error message:&nbsp;</p>
<p>
<pre style="word-wrap: break-word; white-space: pre-wrap; ">
request contains unsupported parameters
<br type="_moz" /></pre>
<p><span style="font-family: Arial, Verdana, sans-serif; white-space: normal; ">The only parameter I'm passing is <b>file</b>&nbsp;and the documentation specifically says that it is a parameter that can be passed here.&nbsp; Is this functionality supported in the community version?<br type="_moz" />
</span></p>
<p>Any help would be appreciated, Thanks in advance.</p>
</p>]]></description>
<guid isPermaLink="true" >http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95488</guid>
</item>
<item>
<title><![CDATA[why jasper report is running immidiately instead of specified time]]></title>
<link>http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=107&amp;topicid=95483</link>
<pubDate>Fri, 10 Feb 2012 11:24:40 +0000</pubDate>
<description><![CDATA[<p>Hi,</p>
<p>check the below code. I am making webservice call to schedule a report to run after 5 mins. but this report is running immidiately. how to avoid that??</p>
<p>Thanks.</p><table align="center" border="0" cellpadding="3" cellspacing="1" width="90%"><tbody><tr><td><b>Code:</b></td></tr><tr><td><pre>JobSimpleTrigger trigger = new JobSimpleTrigger();
            trigger.setOccurrenceCount(1);
            Calendar calendar = Calendar.getInstance();
            System.out.println("current calendar --->" + calendar) ;
            calendar.add(Calendar.MINUTE,5);
             System.out.println("After calendar --->" + calendar) ;
            trigger.setStartDate(calendar);
            trigger.setRecurrenceIntervalUnit(IntervalUnit.fromString(jr.getIntervalUnit()));
            job.setSimpleTrigger(trigger);</td></tr></tbody></table>]]></description>
<guid isPermaLink="true" >http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=107&amp;topicid=95483</guid>
</item>
<item>
<title><![CDATA[jasper server is running report immidiately instead of specified time]]></title>
<link>http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95482</link>
<pubDate>Fri, 10 Feb 2012 11:23:46 +0000</pubDate>
<description><![CDATA[<p>Hi,</p>
<p>check the below code. I am making webservice call to schedule a report to run after 5 mins. but this report is running immidiately. how to avoid that??</p>
<p>Thanks.</p><table align="center" border="0" cellpadding="3" cellspacing="1" width="90%"><tbody><tr><td><b>Code:</b></td></tr><tr><td><pre>JobSimpleTrigger trigger = new JobSimpleTrigger();
            trigger.setOccurrenceCount(1);
            Calendar calendar = Calendar.getInstance();
            System.out.println("current calendar --->" + calendar) ;
            calendar.add(Calendar.MINUTE,5);
             System.out.println("After calendar --->" + calendar) ;
            trigger.setStartDate(calendar);
            trigger.setRecurrenceIntervalUnit(IntervalUnit.fromString(jr.getIntervalUnit()));
            job.setSimpleTrigger(trigger);</td></tr></tbody></table>]]></description>
<guid isPermaLink="true" >http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95482</guid>
</item>
<item>
<title><![CDATA[Domain Template issue]]></title>
<link>http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95475</link>
<pubDate>Fri, 10 Feb 2012 07:13:58 +0000</pubDate>
<description><![CDATA[<p>I have created a template for one of my adhoc report domains. Later I changed one database field in the domain.Field A was initially taken from Table A , I changed it to be from table B.</p>
<p>when I tried to re-run the existing template , I got the below error in the jasperserver log.</p>
<p>2012-02-10 06:22:41,236 ERROR ViewAdhocReportAction,[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)':186 - error setting up repo<br />
rt<br />
java.lang.NullPointerException<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.jaspersoft.ji.semantic.service.SemanticDataService.rdq(SemanticDataService.java:832)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.jaspersoft.commons.semantic.impl.SchemaImpl.getResourceObjectById(SchemaImpl.java:365)<br />
&nbsp;</p>
<p>&nbsp;</p>
<p>Please help to resolve the issue.</p>]]></description>
<guid isPermaLink="true" >http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95475</guid>
</item>
<item>
<title><![CDATA[Converting Collection parameter value to SQL-IN clause]]></title>
<link>http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95466</link>
<pubDate>Thu, 09 Feb 2012 21:28:08 +0000</pubDate>
<description><![CDATA[<p>This is really a postgres question but I thought I'd post it here because it starts with a Collection object in a report parameter. If I take that collection and say if my collection contains values 1,2,3 and 4 and I do this:</p>
<p>$P{myCollection}.toString()</p>
<p>The string output from that looks like [1, 2, 3, 4]</p>
<p>I'd like to take that and convert it to something like:</p>
<p>WHERE myTableField IN ('1', '2', '3', '4')</p>
<p>This is similar to what Jasper seems to do in the report query anyway but I have a use case where I need to do this myself. I have this select for postgres that gets me close but it doesn't quite work:</p>
<p>select translate(translate(translate('[1, 2, 3, 4]', '[', ''''), ']', ''''), ', ', ',''') as value</p>
<p>Which outputs this in Postgres 9.1:</p>
<p>'1,'2,'3,'4'</p>
<p>I'm still missing the second quote on the inner numbers and I don't understand why because the last translate function should handle this correctly. I think anyway. Has anyone else done this?</p>
<p>&nbsp;</p>]]></description>
<guid isPermaLink="true" >http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95466</guid>
</item>
<item>
<title><![CDATA[Java Server Postgresql JDBC]]></title>
<link>http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95462</link>
<pubDate>Thu, 09 Feb 2012 19:34:04 +0000</pubDate>
<description><![CDATA[<table width="100%" cellspacing="0" cellpadding="0" border="0">
    <tbody>
        <tr>
            <td align="left"><span class="msgtitle">Jasper server </span> <span title="02/08/2012 20:22" class="msgdate">02/08/2012 20:22</span></td>
            <td align="right"><span class="msgkarma"> 				                             &nbsp;                             </span></td>
        </tr>
        <tr>
            <td valign="top" colspan="2">
            <div class="msgtext">
            <p>Hi all</p>
            <p>&nbsp;</p>
            <p>I publish a report to the Jasper Server and it is not working as expected</p>
            <p>The report uses a jdbc connection against a Postgresql DB.</p>
            <p>The error message on the server log is this one:</p>
            <p>Error Message<br />
            <br />
            com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error executing SQL statement for : report1<br />
            Error Trace<br />
            <br />
            com.jaspersoft.jasperserver.api.JSExceptionWrapper:  net.sf.jasperreports.engine.JRException: Error executing SQL statement  for : report1 at  net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:229)  at  com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:167)  at  com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113)  at  net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:</p>
            <p>So I double checked&nbsp; the postgresql logs and I foud that the jasper server is sending this statement to the postgresql DB inf front of our function call</p>
            <p>SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY (this creates a lock on the tables involved in the function)</p>
            <p>The function is dropping and creating some tables</p>
            <p>&nbsp;</p>
            <p>So that makes the function we are calling to fail.</p>
            <p>How can we disable it ?</p>
            <p>It is something in the jdbc driver?</p>
            <p>The reports works ok in the Ireport designer.</p>
            <p>Thanks</p>
            <p>&nbsp;</p>
            </div>
            </td>
        </tr>
    </tbody>
</table>]]></description>
<guid isPermaLink="true" >http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95462</guid>
</item>
<item>
<title><![CDATA[Jar files on server]]></title>
<link>http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95457</link>
<pubDate>Thu, 09 Feb 2012 18:24:30 +0000</pubDate>
<description><![CDATA[<p>Hello all, </p>
<p>I have a report with parameters using customized class. Report is working fine in i-report and jasper server reporsitory plugin too.&nbsp; </p>
<p>I have added my .jar file that contains the class in "Add resources" section of server. But when I am running its throwing me an error saying "Error evaluating expression $P{dateUtils}.getEndDate( $P{DateChoice}, $P{Time_Interval}, $P{InputDate})". In the parameter I have specified the class which is com.redhat.eng.JasperDateUtils.</p>
<p><parameter name="dateUtils" class="com.redhat.eng.JasperDateUtils" isForPrompting="false"><br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <defaultValueExpression><![CDATA[com.redhat.eng.JasperDateUtils.getInstance()]]></defaultValueExpression><br />
&nbsp;&nbsp;&nbsp; </parameter><br />
&nbsp;&nbsp;&nbsp; <parameter name="endDate" class="java.util.Date" isForPrompting="false"><br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <defaultValueExpression><![CDATA[$P{dateUtils}.getEndDate( $P{DateChoice}, $P{Time_Interval}, $P{InputDate})]]></defaultValueExpression><br />
&nbsp;&nbsp;&nbsp; </parameter></p>
<p>I am wondering why is it not working in japser server. Most probably, it is not able to get the classpath. </p>
<p>&nbsp;</p>
<p>Please help... </p>
<br />]]></description>
<guid isPermaLink="true" >http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95457</guid>
</item>
<item>
<title><![CDATA[Need some serious help with iReport and jasper.]]></title>
<link>http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95443</link>
<pubDate>Thu, 09 Feb 2012 14:25:50 +0000</pubDate>
<description><![CDATA[<p>Hi Guys</p>
<p>I have a huge problem, when I run my report in iReport it works fine but when I run it in jasper it says the report is empty.</p>
<p>&nbsp;</p>
<p>Any suggetions? Please Guys.</p>
<p>&nbsp;</p>
<p>Thanks</p>]]></description>
<guid isPermaLink="true" >http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95443</guid>
</item>
<item>
<title><![CDATA["Save as xls" button in input control area to avoid render resoults in browser]]></title>
<link>http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95441</link>
<pubDate>Thu, 09 Feb 2012 12:45:04 +0000</pubDate>
<description><![CDATA[<p>Hi all, </p>
<p>as html rendering of a big amount of data is quite slow when I run the report from web, and I can't use pagination, I need a way to export the report in xls format (or pdf, it doen't matter) without show the resoults in the browser first (but only when it is necessary, it depends on the parameter, so user should be able to choose it). I can't use the builtin export buttons on the top of report because they work after the report is rendered in the browser. I would add a new button "Save as xls" in the bottom of input control area, beside the "Apply", that lets me execute the report and directly export it in the xls format.</p>
<p>I found an old post in the forum with a (not realy good) solution but It doesn't work, maybe it's no more compatible with latest version of jasperserver.</p>
<p>I know it is possible to do, but I have no clue on jsp/spring. Is there any exemple on how accomplish this? Or is there any other solution that could fulfill my needs?</p>
<p>Thanks in advance.</p>]]></description>
<guid isPermaLink="true" >http://jasperforge.org/plugins/espforum/view.php?group_id=112&amp;forumid=102&amp;topicid=95441</guid>
</item>
</channel>
</rss>
