kunkasurendra

Hi , To Achive this edit feature you need to set the below properties either in Java or jrxml design Java: JRDocxExporterParameter.FLEXIBLE_ROW_HEIGHT to true jrxml then you can able to edit the generated output.

Hi, I am trying to generate the word (docx) document with Page header and footer like how we generate the document using MS word. Could you please some one help me how to generate the document with header and Footer using the Jasper reports. I am attaching the expected output from jasper.

Changed Assigned User from - to @User_306070

This can be achieved using the Scriptlet concept. follow the steps 1 . Create parameter in report design PRM_JOIN_CONDITION 2 . Create New Java class, which extends the JRDefaultScriptlets create New Method to prepare the Join condition based on your creteria. Ex: public class JoinScriptlet extends JRDefaultScriptlet { StringBuffer buffer = new StringBuffer(); public String getJoinCondition() throws JRScriptletException { String product = (String)this.getParameterValue("product"); or String product = (String)this.getFieldValue("product"); buffer.append("AND table1.id = table2.id"); return buffer; } Note : Create jar file and place this in a classpath. 3 . Scriptlet can be associated with a Report by adding a scriptletClass property to the JasperReports tag 4 . Call the getJoinCondition() method from the PRM_JOIN_CONDITION defaultExpression $P{REPORT_SCRIPTLET}.getJoinCondition() 5 . Add the PRM_JOIN_CONDITION parameter to your query select * from table1, table2 where table1.id= ? $P!{PRM_JOIN_CoNDITION} This may help you to resolve your issue.

Issue : Extra column is added while exporting excel report from Jasperserver. I am facing the issue while exporting the excel report from JasperServer. I have designed the report in iReport 3.7 and tested, It i working fine without any extra column.Each filed width = Multipules of TenHight = 20 pixels Same JRXML is uploaded to Jasperserver 4.2 and exported the excel report from Jasperserver.It is giving the extra column in the excel report. could you please any body help on fix this issue.

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. when I tried to re-run the existing template , I got the below error in the jasperserver log. 2012-02-10 06:22:41,236 ERROR ViewAdhocReportAction,[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)':186 - error setting up repo rt java.lang.NullPointerException at com.jaspersoft.ji.semantic.service.SemanticDataService.rdq(SemanticDataService.java:832) at com.jaspersoft.commons.semantic.impl.SchemaImpl.getResourceObjectById(SchemaImpl.java:365) Please help to resolve the issue.

1 . For these kind of scenarios, you can go for the Scriptlets. Step 1 : Create ScriptletXXXXX.Java Step 2 : Create a method public String prepareWhereClause() { // Read PARAMETERS using the below code String companyName = (String) getParameterValue("COMPANY_NAME"); String companyStatus = (String) getParameterValue("COMPANY_STATUS"); String whereClause = "Where companies.copm_name LIKE '"+companyName+"' AND companies.comp_status LIKE '"+companyStatus+"'; return whereClause; } From JRXML : Create parameters : COMPANY_NAME COMPANY_STATUS PRM_WHERECLAUSE For PRM_WHERECLAUSE : Default Value Expression : $P{REPORT_SCRIPTLET}.prepareWhereClause()

Hi, I am trying to deploy a jasperserver.war file under Weblogic10.3...Server but i am not able to getting login page.... after hitting the URL:http://locahost:7001/jasperserver/ the following error i am getting Error 500--Internal Server Error java.lang.ClassCastException:weblogic.jsp.internal.BinaryRoot can not be cast to weblogic.jsp.internal.SourceFile please help me out ... Thanks in advance... Surendra

I am also not able to login , please help us in resolving the issue.

HI, I am facing the issue in the JasperServer, when I am trying to export the report to Excel(XLS , XLSX and CSV), Main problem is ,I have created the report with Page Header and Footer and exported in Jasperserver, When I am exporting to excel, Header and footer is getting displayed in between the rows.Because of this calculations are getting effected. Please see the attached current and expected excel sheets with this post. In Current Result.xls, Header is occupied the Row1, but In Expected result, I did not occipied any row. In Current Result.xls, Footer is occupied the Row48, but In Expected result, I did not occipied any row. In Current Result.xls, Header is occupied the Row51, but In Expected result, I did not occipied any row. Is there any JasperServer configurations required to get the Expectedresult.xls ? Is it possible to display the Current Result.xls as Expected Result.xls Please help us in to resolve this issue.It is stopped to continue the developement work.

HI, I am facing the issue in the JasperServer, when I am trying to export the report to Excel(XLS , XLSX and CSV), Main problem is ,I have created the report with Page Header and Footer and exported in Jasperserver, When I am exporting to excel, Header and footer is getting displayed in between the rows.Because of this calculations are getting effected. Please see the attached current and expected excel sheets with this post. In Current Result.xls, Header is occupied the Row1, but In Expected result, I did not occipied any row. In Current Result.xls, Footer is occupied the Row48, but In Expected result, I did not occipied any row. In Current Result.xls, Header is occupied the Row51, but In Expected result, I did not occipied any row. Is there any JasperServer configurations required to get the Expectedresult.xls ? Is it possible to display the Current Result.xls as Expected Result.xls Please help us in to resolve this issue.It is stopped to continue the developement work. Thanks, Surendra.

HI, I am facing the issue in the JasperServer, when I am trying to export the report to Excel(XLS , XLSX and CSV), Main problem is ,I have created the report with Page Header and Footer and exported in Jasperserver, When I am exporting to excel, Header and footer is getting displayed in between the rows.Because of this calculations are getting effected. Please see the attached current and expected excel sheets with this post. In Current Result.xls, Header is occupied the Row1, but In Expected result, I did not occipied any row. In Current Result.xls, Footer is occupied the Row48, but In Expected result, I did not occipied any row. In Current Result.xls, Header is occupied the Row51, but In Expected result, I did not occipied any row. Is it possible to display the Current Result.xls as Expected Result.xls. Is there any JasperReports API option is abailable to get this done? Please help us in to resolve this issue.It is stopped to continue the developement work. Thanks, Surendra

HI, I am facing the issue in the JasperServer, when I am trying to export the report to Excel(XLS , XLSX and CSV), Main problem is ,I have created the report with Page Header and Footer and exported in Jasperserver, When I am exporting to excel, Header and footer is getting displayed in between the rows.Because of this calculations are getting effected. Please see the attached current and expected excel sheets with this post. In Current Result.xls, Header is occupied the Row1, but In Expected result, I did not occipied any row. In Current Result.xls, Footer is occupied the Row48, but In Expected result, I did not occipied any row. In Current Result.xls, Header is occupied the Row51, but In Expected result, I did not occipied any row. Is it possible to display the Current Result.xls as Expected Result.xls Please help us in to resolve this issue.It is stopped to continue the developement work.

Hi All, I have a problem while implementing the Conditional styles on Currecy formats. I need to apply the Conditional Currency Styles based on conditions. I have created one Text field with BigDecimal. I need to apply the Conditional Currency style on the TextField based on the conditions. If PRM_REPORT_TYPE = TA , I need to display the Amount field with currency format. If PRM_REPORT_TYPE = TC , I don't need to display any currency format. I have created the style as i mentioned in below. It is working only for fonts. Could you please help in to resole the issue. Thanks. Code:<style name="AmtStyle" isDefault="true" pattern="¤ #,##0.00" fontSize="12"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($P{PRM_REPORT_TYPE}.equals("TC"))]]></conditionExpression> <style isDefault="false" style="AmtStyle" mode="Opaque" pattern="¤ #,##0.00" fontSize="8"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[$P{PRM_REPORT_TYPE} == "TC"]]></conditionExpression> <style isDefault="false" style="AmtStyle" mode="Opaque" pattern="¤ #,##0.00" fontSize="12"/> </conditionalStyle> </style>

Hi, I am not clear , how the Pagination is working in JasperServer, when we request 100000 records. When we request 100000 records,Jasperserver will show some 20 records per page.when you click on next page,weather the Jasperserver will load all the 100000 recods and store it in momorry or It will fire the Query again to retrive the next 20 records, Could you please clarify how this pagination is happining in Jasperserver.