aruninvitesu
Members-
Posts
6 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by aruninvitesu
-
Problem With Jasperserver-pro 3.7.0 Integration
aruninvitesu replied to slvinoth's topic in Products
Vinoth, me to have the same problem.Let me know if you get any solution. -
Im adding external users and their roles from my application to jasperserver When i trying to get or put users and roles using ExternalUserService i get the exception below .. com.jaspersoft.jasperserver.api.JSException: Tenant not found with Tenant ID "organizations" at com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.getRepoTenant(TenantServiceImpl.java:80) at com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.getPersistentTenant(TenantServiceImpl.java:287) .. . . . . .. etc., Code:ExternalUserService externalUserService = someMethod.getExternalUserService(); String userName = account.getAccountId(); User user = externalUserService.getUser(null, account .getAccountId()); externalUserService.removeAllRoles(null, user); externalUserService.maintainInternalUser(userName, (org.springframework.security.GrantedAuthority[]) grantedAuthorities.toArray(new GrantedAuthority[0])); user = externalUserService.getUser(null, userName); user.setUsername("vinoth"); user.setPassword("arun"); user.setEmailAddress("arun@hh.nj"); //user.setTenantId("2"); user.setRoles(roles); user.setExternallyDefined(true); user.setEnabled(true); externalUserService.putUser(null, user);
-
HI Thanks for your reply i used iReport 3.5.0 for designing jrxml. and used jasperreports1.3.1.jar in my application if i load and compile simple jrxml file its working fine but getting error for style applied jrxml file. below i mentioned my java implementation and jrxml file. String fileName="F:\\test.jrxml"; File file=new File(fileName); System.out.println("ifile exist"+file.exists()); JasperDesign jasperDesign = JRXmlLoader.load(file); System.out.println("design"+ jasperDesign.getName()); jasperReport = JasperCompileManager.compileReport(jasperDesign); Map parameters = new HashMap(); String pdfPath = triggerContext.getServices().getJasperService().getJasperReportasPDF(jasperReport,parameters); here's my java code. any more ideas Thanks in advancearun Code:<?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="test" pageWidth="612" pageHeight="792" columnWidth="552" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20"> <property name="com.jaspersoft.ji.adhoc" value="1"/> <property name="net.sf.jasperreports.export.pdf.tagged" value="true"/> <property name="net.sf.jasperreports.export.pdf.tag.language" value="EN-US"/> <style name="ReportDefault" isDefault="true" mode="Transparent" forecolor="#111133" backcolor="#FFFFFF" hAlign="Left" vAlign="Middle" fontName="Arial" fontSize="11" pdfFontName="Helvetica"> <box> <pen lineColor="#003399"/> </box> </style> <style name="PageHeaderFooter" isDefault="false" style="ReportDefault" forecolor="#666666" vAlign="Top" fontName="Arial" fontSize="9"> <pen lineWidth="1.0" lineStyle="Solid"/> </style> <style name="Group1HeaderFooter" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#FCFBDF" fontName="Arial" fontSize="12" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="Group1Header" isDefault="false" style="Group1HeaderFooter"/> <style name="Group1Footer" isDefault="false" style="Group1HeaderFooter"/> <style name="Group2HeaderFooter" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#DEEBFF" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="Group2Header" isDefault="false" style="Group2HeaderFooter"/> <style name="Group2Footer" isDefault="false" style="Group2HeaderFooter"/> <style name="Group3HeaderFooter" isDefault="false" style="ReportDefault" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="Group3Header" isDefault="false" style="Group3HeaderFooter"/> <style name="Group3Footer" isDefault="false" style="Group3HeaderFooter"/> <style name="ColumnHeaderFooter" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#000000" backcolor="#FFFFFF" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> <topPen lineWidth="0.5" lineStyle="Solid"/> <leftPen lineWidth="0.5" lineStyle="Solid"/> <bottomPen lineWidth="0.5" lineStyle="Solid"/> <rightPen lineWidth="0.5" lineStyle="Solid"/> </box> </style> <style name="TableSummaries" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#E5E5E4" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> <topPen lineWidth="0.5" lineStyle="Solid"/> <bottomPen lineWidth="0.5" lineStyle="Solid"/> </box> </style> <style name="Title" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#FFFFFF" backcolor="#18397B" hAlign="Center" fontName="Arial" fontSize="14" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> <topPen lineWidth="0.0" lineStyle="Solid"/> </box> </style> <style name="Details" isDefault="false" style="ReportDefault" mode="Opaque"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{PRIORITY}.equals("Severity 0"))]]></conditionExpression> <style isDefault="false" style="Details" forecolor="#000000" backcolor="#FE7352"/> </conditionalStyle> </style> <style name="colorCode" isDefault="false" style="Details" mode="Opaque"> <box> <pen lineColor="#003399"/> <leftPen lineWidth="0.5" lineStyle="Solid"/> <bottomPen lineWidth="0.5" lineStyle="Solid"/> <rightPen lineWidth="0.5" lineStyle="Solid"/> </box> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{PRIORITY}.equals("Severity 3"))]]></conditionExpression> <style isDefault="false" style="colorCode" forecolor="#000000" backcolor="#A3C29C"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{PRIORITY}.equals("Severity 2"))]]></conditionExpression> <style isDefault="false" style="colorCode" forecolor="#000000" backcolor="#BDE8FC"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{PRIORITY}.equals("Severity 1-E"))]]></conditionExpression> <style isDefault="false" style="colorCode" forecolor="#1B0F0F" backcolor="#F4F08A"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{PRIORITY}.equals("Severity 1"))]]></conditionExpression> <style isDefault="false" style="colorCode" forecolor="#1E1515" backcolor="#FFAFAF"/> </conditionalStyle> </style> <style name="CrosstabDefaults" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#111133" vAlign="Middle" fontName="Arial" fontSize="11" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabTitleStyle" isDefault="false" style="ReportDefault" mode="Transparent" forecolor="#003399" hAlign="Center" vAlign="Middle" fontName="Arial" fontSize="13" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabColumn1" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#FFFFFF" backcolor="#4D7DDE" hAlign="Center" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabColumn2" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#E5E5E4" hAlign="Center" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabColumn3" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#F3F7FD" hAlign="Center" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabRow1" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#FCFBDF" hAlign="Left" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabRow2" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#DEEBFF" hAlign="Left" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabRow3" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#F3F7FD" hAlign="Left" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabGrandTotal" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#FFFFFF" backcolor="#4D7DDE" hAlign="Center" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabColumnWidth" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#111133" vAlign="Middle" fontName="Arial" fontSize="11" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabRowWidth" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#111133" vAlign="Middle" fontName="Arial" fontSize="11" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabMeasureCell" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#111133" backcolor="#FFFFFF" vAlign="Middle" fontName="Arial" fontSize="10" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="ChartReportTitle" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#FFFFFF" backcolor="#4D7DDE" hAlign="Center" fontName="Arial" fontSize="18" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> <topPen lineWidth="0.0" lineStyle="Solid"/> </box> </style> <style name="ChartTitle" isDefault="false" forecolor="#003399" fontName="Arial" fontSize="12" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="ChartSubtitle" isDefault="false" forecolor="#111133" fontName="Arial" fontSize="9" isBold="false" pdfFontName="Helvetica"/> <style name="ChartLegend" isDefault="false" forecolor="#111133" backcolor="#FFFFFF" fontName="Verdana" fontSize="9" isBold="false" pdfFontName="Helvetica"/> <style name="ChartSeriesColor0" isDefault="false" backcolor="#CCE0FF"/> <style name="ChartSeriesColor1" isDefault="false" backcolor="#003399"/> <style name="ChartSeriesColor2" isDefault="false" backcolor="#FCFBDF"/> <style name="ChartSeriesColor3" isDefault="false" backcolor="#4D7DDE"/> <style name="ChartSeriesColor4" isDefault="false" backcolor="#E5E5E4"/> <style name="ChartSeriesColor5" isDefault="false" backcolor="#FCDBCF"/> <style name="ChartSeriesColor6" isDefault="false" backcolor="#FFFFFF"/> <style name="ChartSeriesColor7" isDefault="false" backcolor="#E8FCCA"/> <style name="ChartCategoryAxisLabelFormat" isDefault="false" forecolor="#3366CC" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="ChartCategoryAxisTickFormat" isDefault="false" forecolor="#111133" fontName="Verdana" fontSize="9" isBold="false" pdfFontName="Helvetica"/> <style name="ChartValueAxisLabelFormat" isDefault="false" forecolor="#3366CC" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="ChartValueAxisTickFormat" isDefault="false" forecolor="#111133" fontName="Verdana" fontSize="9" isBold="false" pdfFontName="Helvetica"/> <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["/home/arun/Desktop/reports/final reports/Reports for Motorolo/"]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECT (SELECT COUNT(RTC.ID) FROM CORE RTC ,PROBLEM RTP WHERE RTC.ID=RTP.ID AND RTC.ROLLUP_STATUS ='Open' total_count, RTC.ID,RTC.TITLE,RTC.PRIORITY,RTC.ASSIGNEE,RTC.MODIFIEDTIME FROM CORE RTC , PROBLEM RTP WHERE ASSIGNEDGROUP ='' ORDER BY PRIORITY LIMIT 8]]> </queryString> <field name="total_count" class="java.lang.Long"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="ID" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="TITLE" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="PRIORITY" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="ASSIGNEE" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="MODIFIEDTIME" class="java.sql.Timestamp"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <variable name="InnerRowCount" class="java.lang.Integer" resetType="None"> <variableExpression><![CDATA[$V{REPORT_COUNT}]]></variableExpression> </variable> <variable name="COUNT(RTC.ID)_1" class="java.lang.Long" calculation="Sum"> <variableExpression><![CDATA[]]></variableExpression> </variable> <title> <band height="55"> <staticText> <reportElement x="0" y="0" width="125" height="30"/> <textElement> <font isBold="true"/> </textElement> <text><![CDATA[Total Incidents Open:]]></text> </staticText> <staticText> <reportElement key="staticText" style="Title" x="0" y="30" width="552" height="25"/> <box> <pen lineWidth="0.5" lineColor="#130707"/> <topPen lineWidth="0.5" lineColor="#130707"/> <leftPen lineWidth="0.5" lineColor="#130707"/> <bottomPen lineWidth="0.5" lineColor="#130707"/> <rightPen lineWidth="0.5" lineColor="#130707"/> </box> <textElement textAlignment="Center"/> <text><![CDATA[incident - NOC/Open]]></text> </staticText> <textField> <reportElement x="128" y="0" width="229" height="30"/> <textElement> <font isBold="true"/> </textElement> <textFieldExpression class="java.lang.Long"><![CDATA[$F{total_count} == null ? new Long (0) : $F{total_count}]]></textFieldExpression> </textField> </band> </title> <pageHeader> <band/> </pageHeader> <columnHeader> <band height="25"> <frame> <reportElement style="ColumnHeaderFooter" isPrintRepeatedValues="false" mode="Opaque" x="0" y="0" width="552" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.table" value="start"/> <property name="net.sf.jasperreports.export.pdf.tag.tr" value="full"/> </reportElement> <box> <pen lineWidth="0.5" lineColor="#170707"/> <topPen lineWidth="0.5" lineColor="#170707"/> <leftPen lineWidth="0.5" lineColor="#170707"/> <bottomPen lineWidth="0.5" lineColor="#170707"/> <rightPen lineWidth="0.5" lineColor="#170707"/> </box> <textField isBlankWhenNull="true"> <reportElement style="ColumnHeaderFooter" positionType="Float" x="0" y="0" width="80" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/> </reportElement> <box> <pen lineWidth="0.0" lineColor="#0D0909"/> <topPen lineWidth="0.0" lineColor="#0D0909"/> <leftPen lineWidth="0.0" lineColor="#0D0909"/> <bottomPen lineWidth="0.0" lineColor="#0D0909"/> <rightPen lineWidth="0.0" lineColor="#0D0909"/> </box> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA["Id"]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement style="ColumnHeaderFooter" x="81" y="0" width="197" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/> </reportElement> <box> <pen lineWidth="0.0" lineColor="#150909"/> <topPen lineWidth="0.0" lineColor="#150909"/> <leftPen lineWidth="0.0" lineColor="#150909"/> <bottomPen lineWidth="0.0" lineColor="#150909"/> <rightPen lineWidth="0.0" lineColor="#150909"/> </box> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA["Title"]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement style="ColumnHeaderFooter" x="279" y="0" width="74" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/> </reportElement> <box> <pen lineWidth="0.0" lineColor="#0A0303"/> <topPen lineWidth="0.0" lineColor="#0A0303"/> <leftPen lineWidth="0.0" lineColor="#0A0303"/> <bottomPen lineWidth="0.0" lineColor="#0A0303"/> <rightPen lineWidth="0.0" lineColor="#0A0303"/> </box> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA["Priority"]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement style="ColumnHeaderFooter" x="354" y="0" width="81" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/> </reportElement> <box> <pen lineWidth="0.0" lineColor="#0C0A0A"/> <topPen lineWidth="0.0" lineColor="#0C0A0A"/> <leftPen lineWidth="0.0" lineColor="#0C0A0A"/> <bottomPen lineWidth="0.0" lineColor="#0C0A0A"/> <rightPen lineWidth="0.0" lineColor="#0C0A0A"/> </box> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA["Assignee"]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement style="ColumnHeaderFooter" x="436" y="0" width="116" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/> </reportElement> <box> <pen lineWidth="0.0" lineColor="#0B0707"/> <topPen lineWidth="0.0" lineColor="#0B0707"/> <leftPen lineWidth="0.0" lineColor="#0B0707"/> <bottomPen lineWidth="0.0" lineColor="#0B0707"/> <rightPen lineWidth="0.0" lineColor="#0B0707"/> </box> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA["Modified Time"]]></textFieldExpression> </textField> <line> <reportElement x="80" y="0" width="1" height="25"/> </line> <line> <reportElement x="278" y="0" width="1" height="25"/> </line> <line> <reportElement x="353" y="0" width="1" height="25"/> </line> <line> <reportElement x="435" y="0" width="1" height="25"/> </line> </frame> </band> </columnHeader> <detail> <band height="25"> <frame> <reportElement style="colorCode" positionType="Float" isPrintRepeatedValues="false" mode="Opaque" x="0" y="0" width="552" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.tr" value="full"/> </reportElement> <box> <pen lineWidth="0.5" lineColor="#100606"/> <topPen lineWidth="0.5" lineColor="#100606"/> <leftPen lineWidth="0.5" lineColor="#100606"/> <bottomPen lineWidth="0.5" lineColor="#100606"/> <rightPen lineWidth="0.5" lineColor="#100606"/> </box> <textField isStretchWithOverflow="true" isBlankWhenNull="true" hyperlinkType="Reference" hyperlinkTarget="Blank"> <reportElement key="textField" x="0" y="0" width="80" height="25" forecolor="#0000FF"> <property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/> </reportElement> <box leftPadding="5"> <pen lineWidth="0.0" lineColor="#090404"/> <topPen lineWidth="0.0" lineColor="#090404"/> <leftPen lineWidth="0.0" lineColor="#090404"/> <bottomPen lineWidth="0.0" lineColor="#090404"/> <rightPen lineWidth="0.0" lineColor="#090404"/> </box> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{ID}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement key="textField" mode="Transparent" x="81" y="0" width="197" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/> </reportElement> <box leftPadding="5"> <pen lineWidth="0.0" lineColor="#0E0707"/> <topPen lineWidth="0.0" lineColor="#0E0707"/> <leftPen lineWidth="0.0" lineColor="#0E0707"/> <bottomPen lineWidth="0.0" lineColor="#0E0707"/> <rightPen lineWidth="0.0" lineColor="#0E0707"/> </box> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.String"><![CDATA[$F{TITLE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="textField" x="354" y="0" width="81" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/> </reportElement> <box leftPadding="5"> <pen lineWidth="0.0" lineColor="#120808"/> <topPen lineWidth="0.0" lineColor="#120808"/> <leftPen lineWidth="0.0" lineColor="#120808"/> <bottomPen lineWidth="0.0" lineColor="#120808"/> <rightPen lineWidth="0.0" lineColor="#120808"/> </box> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.String"><![CDATA[$F{ASSIGNEE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="textField" x="436" y="0" width="116" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/> </reportElement> <box leftPadding="5"> <pen lineWidth="0.0" lineColor="#060404"/> <topPen lineWidth="0.0" lineColor="#060404"/> <leftPen lineWidth="0.0" lineColor="#060404"/> <bottomPen lineWidth="0.0" lineColor="#060404"/> <rightPen lineWidth="0.0" lineColor="#060404"/> </box> <textElement textAlignment="Left"/> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{MODIFIEDTIME}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="279" y="0" width="74" height="25"/> <box leftPadding="5"> <pen lineWidth="0.0" lineColor="#0D0909"/> <topPen lineWidth="0.0" lineColor="#0D0909"/> <leftPen lineWidth="0.0" lineColor="#0D0909"/> <bottomPen lineWidth="0.0" lineColor="#0D0909"/> <rightPen lineWidth="0.0" lineColor="#0D0909"/> </box> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{PRIORITY}]]></textFieldExpression> </textField> <line> <reportElement x="80" y="0" width="1" height="25"/> </line> <line> <reportElement x="278" y="0" width="1" height="25"/> </line> <line> <reportElement x="353" y="0" width="1" height="25"/> </line> <line> <reportElement x="435" y="0" width="1" height="25"/> </line> </frame> </band> </detail> <columnFooter> <band/> </columnFooter> <summary> <band/> </summary></jasperReport>
-
Hi, I created a jrxml file using iReport 3.5.0 . in that jrxml file i applied some style condition. while loading that jrxml from java code i get error. but if i run a jrxml without style property jrxml file loaded and compiled in java. i get the following error while running jrxml with style property java.lang.ClassCastException: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at net.sf.jasperreports.engine.xml.JRBoxFactory.createObject(JRBoxFactory.java:49) at org.apache.commons.digester.FactoryCreateRule.begin(FactoryCreateRule.java:390) at org.apache.commons.digester.Digester.startElement(Digester.java:1453) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.startElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1745) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151) at net.sf.jasperreports.engine.JasperManager.loadXmlDesign(JasperManager.java:971) at com.radaptive.rdpv.runtime.service.triggeraction.JasperReportTriggerAction.execute(JasperReportTriggerAction.java:35) at com.radaptive.rdpv.runtime.service.impl.TriggerHandler.applyAttachedTriggers(TriggerHandler.java:232) at com.radaptive.rdpv.runtime.service.impl.FormServiceImpl.postFormProcess(FormServiceImpl.java:310) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.radaptive.common.ExceptionInterceptor.invoke(ExceptionInterceptor.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy58.postFormProcess(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy59.postFormProcess(Unknown Source) at com.radaptive.rdpv.runtime.service.impl.FormServiceImpl.createForm(FormServiceImpl.java:211) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.radaptive.common.ExceptionInterceptor.invoke(ExceptionInterceptor.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy58.createForm(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy59.createForm(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy59.createForm(Unknown Source) at com.radaptive.webapp.action2.runtime.FormAction.saveForm(FormAction.java:1908) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.radaptive.webapp.action2.common.BaseAction.execute(BaseAction.java:89) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:434) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:273) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:235) at com.radaptive.webapp.interceptor.ParamMapInterceptor.intercept(ParamMapInterceptor.java:64) at com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvocation.java:230) at com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvocation.java:229) at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:456) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:227) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:170) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86) at com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvocation.java:230) at com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvocation.java:229) at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:456) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:227) at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:477) at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:467) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229) at com.radaptive.webapp.filter.UserPreferencesAwareFilter.doFilter(UserPreferencesAwareFilter.java:45) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) any suggestions, Thanks in advance , Arun
-
want to generate weekly report for selected month
aruninvitesu replied to aruninvitesu's topic in Products
i had used this query and got the output with for sales entry of that specified month. now i want generate weekly sales report for that specified month between('01-04-09') and ('31-05-09') my report has to like this name | 01-04-09 | 08-04-09 | 15-04-09 | 22-04-09 | 29-04-09 | Total | 06-05-09 | 13-05-09 | 20-05-09 | 27-05-09 | Total Arun 20 | - | 60 | 30 | 90 | 200 | 20 | - | 60 | 90 | 200 babu 20 | - | 60 | 30 | 90 | 200 | 20 | - | 60 | 90 | 170 din 20 | - | 60 | 30 | 90 | 200 | 20 | - | 60 | 90 | 170 Grand total - 550 For this i tried using Cross tab but i cant figure out for weekly wise Any idea.. plz help me Thanks in advance Arun Code:select line.Line_name, area.Area_name,cust.Customer_name,item.Item_name,item.No_of_units,Sales.Sale_Qty,sale_Rate,date_format(sale_date,"%d-%m-%y") as sale_Date from Line_master line left join (Area_master area left join (Customer_master cust left join (Sales_Entry sales left join Item_master item on item.Item_code=sales.Item_code) on cust.cust_sales_code=sales.Customer_code) on cust.Area_code=area.Area_code) on line.Area_code = area.Area_code where sale_Date between('01-04-09') and ('31-04-09') -
Hi all, i want to generate weekly report for selected month in ireport . if i selected month from january to febraury means my report has to generate report for 8 weeks sales with weekwise total i tried using Cross tab and subreport.. but cant ..... Please help me with any solution ... Thanks in Advance, Arun