vigneshwaran.ganesan
Members-
Posts
13 -
Joined
-
Last visited
vigneshwaran.ganesan's Achievements
-
Unexpected vertical space List component
vigneshwaran.ganesan replied to vigneshwaran.ganesan's topic in Products
Resolved by changing the JRXML as given below. <detail> <band height="56" splitType="Stretch"> <componentElement> <reportElement x="4" y="1" width="545" height="55" uuid="7d3851e2-9d6c-4b5b-b256-5e3fd1983313"/> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/componentshttp://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical"> <datasetRun subDataset="InnerLineDetail" uuid="581ce50a-7a06-4450-94f4-22b8832ebb05"> <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{shipmentLineItem})]]></dataSourceExpression> </datasetRun> <jr:listContents height="55" width="545"> <textField> <reportElement x="3" y="2" width="39" height="18" isRemoveLineWhenBlank="true" uuid="e90d9058-03d2-4c74-ba58-23c680f547f3"/> <textFieldExpression><![CDATA[$F{itemNumber}]]></textFieldExpression> </textField> <textField> <reportElement x="43" y="2" width="113" height="18" isRemoveLineWhenBlank="true" uuid="05366782-7ca3-4c40-aa6b-f827ad1dcd8e"/> <textFieldExpression><![CDATA[$F{materialNumber}]]></textFieldExpression> </textField> <textField> <reportElement x="158" y="1" width="253" height="20" isRemoveLineWhenBlank="true" uuid="f34a79f3-abaa-4e96-8c96-61b76151606b"/> <textElement textAlignment="Left"/> <textFieldExpression><![CDATA[$F{description}]]></textFieldExpression> </textField> <textField> <reportElement x="232" y="21" width="257" height="17" isRemoveLineWhenBlank="true" uuid="0e50363f-f50b-41e2-b3d6-0b7e83836cf3"/> <textFieldExpression><![CDATA[$F{stoNumber}]]></textFieldExpression> </textField> <textField> <reportElement x="412" y="7" width="52" height="23" isRemoveLineWhenBlank="true" uuid="9bf292e0-eba2-4494-9cf3-5c800a4c134a"/> <textFieldExpression><![CDATA[$F{qtyOrdered}]]></textFieldExpression> </textField> <textField> <reportElement x="487" y="8" width="52" height="23" isRemoveLineWhenBlank="true" uuid="6471b280-20cf-4c68-9998-4eb916a0b0ce"/> <textFieldExpression><![CDATA[$F{qtyShipped}]]></textFieldExpression> </textField> <staticText> <reportElement x="167" y="21" width="73" height="17" uuid="566341a8-c707-4d8a-a6b9-c0792dd6f3f1"/> <textElement> <font fontName="SansSerif" size="10" isBold="true"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[sTO Number:]]></text> </staticText> <staticText> <reportElement x="167" y="37" width="91" height="17" uuid="566341a8-c707-4d8a-a6b9-c0792dd6f3f1"/> <textElement> <font fontName="SansSerif" size="10" isBold="true"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Tracking Number:]]></text> </staticText> <componentElement> <reportElement x="253" y="37" width="247" height="16" uuid="33288373-3faa-40c0-a220-7ee76fe720d8"/> <jr:list printOrder="Vertical"> <datasetRun subDataset="trackingDetail" uuid="581ce50a-7a06-4450-94f4-22b8832ebb05"> <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{trackingNumbers})]]></dataSourceExpression> </datasetRun> <jr:listContents height="16" width="247"> <textField> <reportElement x="0" y="0" width="247" height="16" uuid="a8b5b3e6-9014-42ec-91de-511f3a63053f"/> <textFieldExpression><![CDATA[$F{trackingnumber}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> </jr:listContents> </jr:list> </componentElement> </band> </detail> -
Unexpected vertical space List component
vigneshwaran.ganesan replied to vigneshwaran.ganesan's topic in Products
Resolved by using Jasper Studio plugin to Eclipse. Working JRXML: <detail> <band height="56" splitType="Stretch"> <componentElement> <reportElement x="4" y="1" width="545" height="55" uuid="7d3851e2-9d6c-4b5b-b256-5e3fd1983313"/> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical"> <datasetRun subDataset="InnerLineDetail" uuid="581ce50a-7a06-4450-94f4-22b8832ebb05"> <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{shipmentLineItem})]]></dataSourceExpression> </datasetRun> <jr:listContents height="55" width="545"> <textField> <reportElement x="3" y="2" width="39" height="18" isRemoveLineWhenBlank="true" uuid="e90d9058-03d2-4c74-ba58-23c680f547f3"/> <textFieldExpression><![CDATA[$F{itemNumber}]]></textFieldExpression> </textField> <textField> <reportElement x="43" y="2" width="113" height="18" isRemoveLineWhenBlank="true" uuid="05366782-7ca3-4c40-aa6b-f827ad1dcd8e"/> <textFieldExpression><![CDATA[$F{materialNumber}]]></textFieldExpression> </textField> <textField> <reportElement x="158" y="1" width="253" height="20" isRemoveLineWhenBlank="true" uuid="f34a79f3-abaa-4e96-8c96-61b76151606b"/> <textElement textAlignment="Left"/> <textFieldExpression><![CDATA[$F{description}]]></textFieldExpression> </textField> <textField> <reportElement x="232" y="21" width="257" height="17" isRemoveLineWhenBlank="true" uuid="0e50363f-f50b-41e2-b3d6-0b7e83836cf3"/> <textFieldExpression><![CDATA[$F{stoNumber}]]></textFieldExpression> </textField> <textField> <reportElement x="412" y="7" width="52" height="23" isRemoveLineWhenBlank="true" uuid="9bf292e0-eba2-4494-9cf3-5c800a4c134a"/> <textFieldExpression><![CDATA[$F{qtyOrdered}]]></textFieldExpression> </textField> <textField> <reportElement x="487" y="8" width="52" height="23" isRemoveLineWhenBlank="true" uuid="6471b280-20cf-4c68-9998-4eb916a0b0ce"/> <textFieldExpression><![CDATA[$F{qtyShipped}]]></textFieldExpression> </textField> <staticText> <reportElement x="167" y="21" width="73" height="17" uuid="566341a8-c707-4d8a-a6b9-c0792dd6f3f1"/> <textElement> <font fontName="SansSerif" size="10" isBold="true"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[sTO Number:]]></text> </staticText> <staticText> <reportElement x="167" y="37" width="91" height="17" uuid="566341a8-c707-4d8a-a6b9-c0792dd6f3f1"/> <textElement> <font fontName="SansSerif" size="10" isBold="true"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Tracking Number:]]></text> </staticText> <componentElement> <reportElement x="253" y="37" width="247" height="16" uuid="33288373-3faa-40c0-a220-7ee76fe720d8"/> <jr:list printOrder="Vertical"> <datasetRun subDataset="trackingDetail" uuid="581ce50a-7a06-4450-94f4-22b8832ebb05"> <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{trackingNumbers})]]></dataSourceExpression> </datasetRun> <jr:listContents height="16" width="247"> <textField> <reportElement x="0" y="0" width="247" height="16" uuid="a8b5b3e6-9014-42ec-91de-511f3a63053f"/> <textFieldExpression><![CDATA[$F{trackingnumber}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> </jr:listContents> </jr:list> </componentElement> </band> </detail> -
Unexpected vertical space List component
vigneshwaran.ganesan replied to vigneshwaran.ganesan's topic in Products
I am unable to upload the pdf or screen shot -
I have used nested component list in the detail band and noticed extra space inside the inner list. Can someone suggest me to remove the additional space between Tracking Number: 1Z90AV790311117898 and 1Z90AV790311117899. JRXML: <detail> <band height="56" splitType="Stretch"> <componentElement> <reportElement x="4" y="1" width="545" height="55" uuid="7d3851e2-9d6c-4b5b-b256-5e3fd1983313"/> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical"> <datasetRun subDataset="InnerLineDetail" uuid="581ce50a-7a06-4450-94f4-22b8832ebb05"> <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{shipmentLineItem})]]></dataSourceExpression> </datasetRun> <jr:listContents height="55" width="545"> <textField> <reportElement x="3" y="2" width="39" height="18" isRemoveLineWhenBlank="true" uuid="e90d9058-03d2-4c74-ba58-23c680f547f3"/> <textFieldExpression><![CDATA[$F{itemNumber}]]></textFieldExpression> </textField> <textField> <reportElement x="43" y="2" width="113" height="18" isRemoveLineWhenBlank="true" uuid="05366782-7ca3-4c40-aa6b-f827ad1dcd8e"/> <textFieldExpression><![CDATA[$F{materialNumber}]]></textFieldExpression> </textField> <textField> <reportElement x="158" y="1" width="253" height="20" isRemoveLineWhenBlank="true" uuid="f34a79f3-abaa-4e96-8c96-61b76151606b"/> <textElement textAlignment="Left"/> <textFieldExpression><![CDATA[$F{description}]]></textFieldExpression> </textField> <textField> <reportElement x="164" y="22" width="257" height="17" isRemoveLineWhenBlank="true" uuid="0e50363f-f50b-41e2-b3d6-0b7e83836cf3"/> <textFieldExpression><![CDATA[$F{stoNumber}]]></textFieldExpression> </textField> <textField> <reportElement x="412" y="7" width="52" height="23" isRemoveLineWhenBlank="true" uuid="9bf292e0-eba2-4494-9cf3-5c800a4c134a"/> <textFieldExpression><![CDATA[$F{qtyOrdered}]]></textFieldExpression> </textField> <textField> <reportElement x="487" y="8" width="52" height="23" isRemoveLineWhenBlank="true" uuid="6471b280-20cf-4c68-9998-4eb916a0b0ce"/> <textFieldExpression><![CDATA[$F{qtyShipped}]]></textFieldExpression> </textField> <staticText> <reportElement x="99" y="22" width="73" height="17" uuid="566341a8-c707-4d8a-a6b9-c0792dd6f3f1"/> <textElement> <font fontName="SansSerif" size="10" isBold="true"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[sTO Number:]]></text> </staticText> <staticText> <reportElement x="99" y="38" width="91" height="17" uuid="566341a8-c707-4d8a-a6b9-c0792dd6f3f1"/> <textElement> <font fontName="SansSerif" size="10" isBold="true"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Tracking Number:]]></text> </staticText> <componentElement> <reportElement x="1" y="1" width="541" height="51" uuid="7d3851e2-9d6c-4b5b-b256-5e3fd1983313"/> <jr:list printOrder="Vertical"> <datasetRun subDataset="trackingDetail" uuid="581ce50a-7a06-4450-94f4-22b8832ebb05"> <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{trackingNumbers})]]></dataSourceExpression> </datasetRun> <jr:listContents height="51" width="541"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="190" y="37" width="179" height="14" isRemoveLineWhenBlank="true" uuid="6471b280-20cf-4c68-9998-4eb916a0b0ce"/> <textFieldExpression><![CDATA[$F{trackingnumber}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> </jr:listContents> </jr:list> </componentElement> </band> </detail>
-
Hi All, I am using Jasper Report dependencies with Spring boot to generate reports. It works without any issue in local. After I deploy to PCF getting below error. Can anyone help me and its blocking me. Line of Exception in the Code - PCF JasperPrint printedReport = JasperFillManager.fillReport(sourceFileName, parameters, beanColDataSource); Exception message":"java.lang.IllegalArgumentException: namentat sun.misc.URLClassPath$Loader.findResource(URLClassPath.java:693)ntat sun.misc.URLClassPath.findResource(URLClassPath.java:215)ntat java.net.URLClassLoader$2.run(URLClassLoader.java:569)ntat java.net.URLClassLoader$2.run(URLClassLoader.java:567)ntat java.security.AccessController.doPrivileged(Native Method)ntat java.net.URLClassLoader.findResource(URLClassLoader.java:566)ntat org.springframework.boot.loader.LaunchedURLClassLoader.findResource(LaunchedURLClassLoader.java:58)ntat java.lang.ClassLoader.getResource(ClassLoader.java:1096)ntat net.sf.jasperreports.engine.util.JRResourcesUtil.findClassLoaderResource(JRResourcesUtil.java:569)ntat net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:108)ntat net.sf.jasperreports.repo.InputStreamPersistenceService.load(InputStreamPersistenceService.java:45)ntat net.sf.jasperreports.repo.DefaultRepositoryService.getResource(DefaultRepositoryService.java:149)ntat net.sf.jasperreports.repo.RepositoryUtil.findInputStream(RepositoryUtil.java:190)ntat net.sf.jasperreports.repo.RepositoryUtil.getBytesFromLocation(RepositoryUtil.java:206)ntat net.sf.jasperreports.renderers.util.RendererUtil.getNonLazyRenderable(RendererUtil.java:163)ntat net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:553)ntat net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:484)ntat net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:383)ntat net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:506)ntat net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:412)ntat net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:373)ntat net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:234)ntat net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:99)ntat net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:607)ntat net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:405)ntat net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:140)ntat net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:583)ntat net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:929)ntat com.example.util.CommonUtil.createJasperPdf(CommonUtil.java:644)ntat
-
I am using JasperStudio plugin in the eclipse using Java. I have scenario to generate barcode 93 in the reports. Currently barcode 93 is not available in the plugin. Can anyone tell me how to add barcode 93 to jasper report? Appreciate your help.
-
I am using JasperStudio plugin in the eclipse using Java. I have below scenario to generate reports in detail band. IdLineItem1 1 SourceNumber:1 DestinationNumber:1 2 3 42 2 SourceNumber:10 DestinationNumber:10 20 30 40 Java Bean: public class Advance { private String id; private List<LineItem> lineItem; } public class LineItem { private String lineNumber; private String sourceNumber; private List<String> destinationNumber; } I was able to use sub dataset and list component to populate the lineItem but unable to get the list of destinationNumber inside the list. How to display the list<String> destinationNumber in my reports. Appreciate your help. <subDataset name="dataset1" uuid="d0f9f7bb-3ece-4b2a-8f3d-286f16bb428c"> <field name="lineNumber" class="java.lang.String"/> </subDataset> <detail> <band height="25" splitType="Stretch"> <componentElement> <reportElement x="4" y="0" width="548" height="20" uuid="320e66be-b719-4e1d-b1c8-9215179d7200"/> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical"> <datasetRun subDataset="dataset1" uuid="056d45ca-4628-4bc5-bb1f-f44bb6d74c82"> <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{lineDetails})]]></dataSourceExpression> </datasetRun> <jr:listContents height="20" width="548"> <textField> <reportElement x="0" y="0" width="100" height="20" uuid="db39f665-58b9-43ba-89dc-0d93e2f02a77"/> <textFieldExpression><![CDATA[$F{lineNumber}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> </band> </detail> Appreciate your help
-
I have resolved this issue by adding jar file path. Now I have created JRXML with static and dynamic fields Outline -> Right Click and choose Dataset and Query Dialog -> Java Bean tab -> Enter the class name which holds fields name Fields are not listing out and its showing as Class not found: com.xxx.StudentScore Can anyone help me to list out the fields
-
I have created Java bean and connection factory in separate project and exported as Jar Java Version - 1.8 Downloaded TIBCO Jaspersoft Studio 6.4.0 community edition Created project - Added bean jar dependencies Clicked the new adapter - > Collection of JavaBeans Chosen factory class and static method from jar that added to project Tested the connection and getting below error. Please help me to resolve this issue Exception net.sf.jasperreports.engine.JRException: java.lang.ClassNotFoundException: com.xxx.Student cannot be found by net.sf.jasperreports_6.4.0.final at net.sf.jasperreports.data.bean.BeanDataAdapterService.contributeParameters(BeanDataAdapterService.java:101) at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:122) at com.jaspersoft.studio.data.DataAdapterEditorPart$1.widgetSelected(DataAdapterEditorPart.java:166) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4418) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4236) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3824) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1121) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1022) at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:150) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:693) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:610) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148) at com.jaspersoft.studio.rcp.intro.Application.start(Application.java:91) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:673) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:610) at org.eclipse.equinox.launcher.Main.run(Main.java:1519) Caused by: java.lang.ClassNotFoundException: com.xxx.Student cannot be found by net.sf.jasperreports_6.4.0.final at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:461) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:372) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:364) at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:161) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:348) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:174) at net.sf.jasperreports.data.bean.BeanDataAdapterService.contributeParameters(BeanDataAdapterService.java:83) ... 29 more
-
I need to generate PDF using Spring boot Microservice call. I was not able to find working example. Can someone share me example. Appreciate your help.
-
Thanks for your response. JaspersoftStudio-6.4.0 is open source? Appreciate your help.
-
Hi All, I have created the jrxml using IReport and tried to map the java bean sources to text fields in the JRXML. It was not able to recognized the class file. When I tried to run the application in Java 8, empty pdf is generated. Any help will be great.