[JasperServer portlet]

The latest portlet is for version 3.7.1. I'm not sure that it is working on 4.

[JasperServer portlet]

How can I create a report portlet from JasperServer 4? There is no Liferay portlet file in JasperServer CE starting from version 4.

[config js.quartz.properties to use gmail]

I can make it work.

 

C:\Program Files\jasperreports-server-4.1\apache-tomcat\webapps\jasperserver-pro\WEB-INF\js.quartz.properties

report.scheduler.mail.sender.host=smtp.gmail.com
report.scheduler.mail.sender.username=username@gmail.com
report.scheduler.mail.sender.password=s3cr3t
report.scheduler.mail.sender.from=username@gmail.com
report.scheduler.mail.sender.protocol=smtps
report.scheduler.mail.sender.port=465

 

C:\Program Files\jasperreports-server-4.1\apache-tomcat\webapps\jasperserver-pro\WEB-INF\applicationContext-report-scheduling.xml

    <bean id="reportSchedulerMailSender" class="org.springframework.mail.javamail.JavaMailSenderImpl">
        <property name="host" value="${report.scheduler.mail.sender.host}"/>
        <property name="username" value="${report.scheduler.mail.sender.username}"/>
        <property name="password" value="${report.scheduler.mail.sender.password}"/>
        <property name="protocol" value="${report.scheduler.mail.sender.protocol}"/>
        <property name="port" value="${report.scheduler.mail.sender.port}"/>
        <property name="javaMailProperties">
            <props>
                <prop key="mail.smtps.auth">true</prop>
                <prop key="mail.smtps.starttls.enable">true</prop>
            </props>
        </property>
    </bean>

[consuming a jasperserver web service with visual basic]

I want my VB.NET app to get a report from JasperServer by calling its web service.

I obtained the service from http://localhost:8080/jasperserver-pro/services/repository?wsdl

I wrote the following code.

Dim sr As New ServiceReference1.ManagementServiceClientsr.ClientCredentials.UserName.UserName = "jasperadmin"sr.ClientCredentials.UserName.Password = "jasperadmin"Dim xml = <request operationName="runReport" locale="en">			  <argument name="RUN_OUTPUT_FORMAT">PDF</argument>			  <resourceDescriptor name="" wsType=""				  uriString="/reports/samples/a2">				  <label>null</label>				  <parameter name="param1"><![CDATA[1]]></parameter>			  </resourceDescriptor>		  </request>Dim result As String = sr.runReport(xml)Console.WriteLine(result)

I already edit app.config

<security mode="TransportCredentialOnly">  <transport clientCredentialType="Basic"              proxyCredentialType="Basic"             realm="" />

Instead of getting a report, I got the following result.

<?xml version="1.0" encoding="UTF-8"?><operationResult version="2.0.1">    <returnCode><![CDATA[1]]></returnCode>    <returnMessage><![CDATA[Content is not allowed in prolog.]]></returnMessage></operationResult>

But when I changed the code to:

Dim result As String = sr.runReport(xml.ToString)

I got the following exception.

A first chance exception of type 'System.ServiceModel.ProtocolException' occurred in mscorlib.dll
A first chance exception of type 'System.ArgumentException' occurred in Microsoft.VisualBasic.dll

What is wrong with my code or configuration? Please help.

Post Edited by vaxim at 10/08/2011 05:49

Post Edited by vaxim at 10/08/2011 05:50

Post Edited by vaxim at 10/08/2011 05:54

[config js.quartz.properties to use gmail]

Could someone please give me a config js.quartz.properties that can use gmail to send email?

I tried the following config but it doesn't work.

report.scheduler.mail.sender.host=smtp.gmail.com
report.scheduler.mail.sender.username=myuser
report.scheduler.mail.sender.password=mypass
report.scheduler.mail.sender.from=myuser@gmail.com
report.scheduler.mail.sender.protocol=smtps
report.scheduler.mail.sender.port=465
report.scheduler.mail.smtps.auth=true
report.scheduler.mail.smtps.starttls.auth=true

I got the following error message.

Job: Background Execution (ID: 9) Report unit: /reports/samples/AllAccounts Quartz Job: ReportJobs.job_9 Quartz Trigger: ReportJobs.trigger_9_0 Exceptions: The job error notification was not completed. An error occurred while sending it. org.springframework.mail.MailSendException; nested exception details (1) are: Failed message 1: com.sun.mail.smtp.SMTPSendFailedException: 530-5.5.1 Authentication Required. Learn more at 530 5.5.1 http://mail.google.com/support/bin/answer.py?answer=14257 f24sm38187699yhk.5 at com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1388) at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:959) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:583) at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:403) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:342) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:338) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:1262) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:444) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:230) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

Post Edited by vaxim at 09/28/2011 15:18

[hide table component when no data]

I tried "remove line when blank" but it doesn't work.

[hide table component when no data]

OK.  Let me explain again.

The SQL for the main report is "SELECT * FROM order_table".

A detail band contains fields from each row of order_table.

A data set use $F{id} from from order_table to query for order details.

A detail band contains a table component.  It is used for displaying order details.

When there is no order detail for a particular row, the table component will appears as a line.  I would like the table component to disappear.

[hide table component when no data]

Hi,

I am using a table component in my report.  It shows data from a dataset.  For a row that has no data in the dataset, the table appears as a line.  How can I hide it?

Thank you.

[refer to a dataset variable]

Hello,

How can I refer to a variable in a dataset?  I'd like to know the REPORT_COUNT of the dataset.

[change java.text.BreakIterator to com.ibm.icu.text.DictionaryBasedBreakIterator]

I believe that JasperReport uses an object that is an instance of java.text.BreakIterator to determine the word boundary.  However, I would like to use an instance of com.ibm.icu.text.DictionaryBasedBreakIterator to determine the word boundary instead. How can I do that?

 

["Wingdings" font in ireport /jasper reports v3.7.1]

I also have the same problem.  All characters that use the font appear as rectangles.

[gap between detail and column footer]

Hi Christina,

 

I'm sorry for not explaining well. The rectangles in the column footer and page footer are used for checking whether there is a gap between those bands and the detail band. In the actual report, those rectangles will be removed.

 

Regards,

 

vaxim

[gap between detail and column footer]

Thank you sugita, the gap between the column footer and detail band in my report is removed after I resized the height of summary band to zero.  As shown in the attached files.

[gap between detail and column footer]

Hi Christina,

 

I can put the rectangles into a page footer and a column footer. But there is a gap between the detail and the group footer when I run the report.

 

vaxim

[gap between detail and column footer]

Hi Christina,

Thank you for your reply.  I tried setting the position type to every possible value.  But the result is the same.  Please see the attachment in the 1st post.

vaxim

[gap between detail and column footer]

Hi everyone,

In the design of my report, I draw a rectangle in a detail band and a column footer band.  Two rectangles from those bands attach each other in the design view.  However, in the preview view, there is a gap between those rectangles.  How can I remove the gap?

I already checked the "floating column footer" to true.

Best regards,

vaxim

[cannot count starting from initial value expr]

The question was answered by Teodor at the following link.

 

http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=57793

[purpose of initial value expression]

Hi Teodor,

Thank you very much for clarifying and giving a tip on how to count starting from a particular value.

All the best,

vaxim

[purpose of initial value expression]

Hello,

I have the same question as Ashley Moran-2 posted in the following link.

http://www.nabble.com/What-is-the-point-of-variable-initial-value-expression--td920024.html

What is the purpose of initial value expression of a variable?  If the variable is for counting and I set it to 5, the report doesn't count 5, 6, 7, ...

Regard,

vaxim

[cannot count starting from initial value expr]

Hello,

I have a question about "initial value expression."  I created a variable with the following property in iReport 3.5 plug-in for NetBeans.

Variable Class : java.lang.Integer
Calculation : Count
Reset type : Report
Increment type : None
Variable Expression : $F{id}
Initial Value Expression : new Integer(10)

When I put the variable in Column Header, it display 10.  But when I put the variable in the Detail band, it starts counting at 1 (instead of 11).  How can it start counting from the initial value expression?

Best regards,

Vaxim