Jump to content

aruninvitesu

Members
 View Profile  See their activity

  • Posts

    6

  • Joined

  • Last visited

 Content Type 

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

Posts posted by aruninvitesu

    Problem in adding users to jasperserver-pro 3.7

    in Products

    Posted

    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);

    error while loading jrxml file from java

    in Products

    Posted

    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 advance
    arun

     

     

     

    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>

    error while loading jrxml file from java

    in Products

    Posted

    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

    in Products

    Posted

    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')

    want to generate weekly report for selected month

    in Products

    Posted

     

    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

     

×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore