vaxim

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

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

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>

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

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

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

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.

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.

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

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?

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

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

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.

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

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