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

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

The question was answered by Teodor at the following link. http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=57793

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

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

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