Jump to content

victor_33

Members
 View Profile  See their activity

  • Posts

    10

  • 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 victor_33

    Iterate Arraylist

    in Products

    Posted

    I have a report that i would like to iterate a arraylist. The arraylist is a parameter, i found that i can use it as a datasource for a subreport, but i need to compare the values of the array with values of a query and make some calculations. And show it on the detail as rows. Example:

    Array values    Query values   Result

    10                     10                    0

    10                     20                    10

    30                    10                    -20

     

    How can i do this ?

    Data source on jasperserver

    in Products

    Posted

    I have a report that is simple, it has a few string paramters that receive all the data that i need. The strings are like this "1;2;3", "bob;john;mary". And i just need to show the data in rows. And it is working on jaspersoft. BUT not on jasperserver, when i run the report on jaspersoft server, it doesnt show the data.

    I use .split(";") on the strings and cast it to arraylist  and use it as datasource for my subreports. It is ugly but works, at least on jaspersoft. But it just doesnt on jasperserver. 

    The data comes from a angular project, and is filled by the user.

    I think its a problem on the way im using the datasource on the subreports but im not sure. Im new to jaspersoft. If this is not the wasy i should be doing this, pls say so, any help is appreciated

    Here is my report code:

    <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.13.0.final using JasperReports Library version 6.13.0-46ada4d1be8f3c5985fd0b6146f3ed44caed6f05  --><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="OcorrenciasBancarias"              pageWidth="595" pageHeight="842" columnWidth="555"              leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"              uuid="8fbddf4a-554c-4f04-9941-b9e16c98b10d">    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>    <property name="com.jaspersoft.studio.data.defaultdataadapter"              value="RK ERP Devel"/>    <property name="ireport.jasperserver.url"              value="http://192.168.0.205:11001/jasperserver/"/>    <property name="ireport.jasperserver.user" value="jasperadmin"/>    <property name="ireport.jasperserver.report.resource"              value="/reports/telas/quitacao_multiplas_contas/arquivo_retorno/ocorrenciasBancarias_files/main_jrxml"/>    <property name="ireport.jasperserver.reportUnit"              value="/reports/telas/quitacao_multiplas_contas/arquivo_retorno/ocorrenciasBancarias"/>    <parameter name="CLIENTE" class="java.lang.String"/>    <parameter name="DOCUMENTO" class="java.lang.String"/>    <parameter name="NOSSONUMERO" class="java.lang.String"/>    <parameter name="VALOR" class="java.lang.String"/>    <parameter name="VENCIMENTO" class="java.lang.String"/>    <parameter name="OCORRENCIA" class="java.lang.String"/>    <parameter name="CLIENTELIST" class="java.util.List">        <defaultValueExpression>            <![CDATA[Arrays.asList($P{CLIENTE}.split(";"))]]>        </defaultValueExpression>    </parameter>    <parameter name="DOCUMENTOLIST" class="java.util.List">        <defaultValueExpression>            <![CDATA[Arrays.asList($P{DOCUMENTO}.split(";"))]]>        </defaultValueExpression>    </parameter>    <parameter name="NOSSONUMEROLIST" class="java.util.List">        <defaultValueExpression>            <![CDATA[Arrays.asList($P{NOSSONUMERO}.split(";"))]]>        </defaultValueExpression>    </parameter>    <parameter name="VALORLIST" class="java.util.List">        <defaultValueExpression>            <![CDATA[Arrays.asList($P{VALOR}.split(";"))]]>        </defaultValueExpression>    </parameter>    <parameter name="VENCIMENTOLIST" class="java.util.List">        <defaultValueExpression>            <![CDATA[Arrays.asList($P{VENCIMENTO}.split(";"))]]>        </defaultValueExpression>    </parameter>    <parameter name="OCORRENCIALIST" class="java.util.List">        <defaultValueExpression>            <![CDATA[Arrays.asList($P{OCORRENCIA}.split(";"))]]>        </defaultValueExpression>    </parameter>    <queryString language="SQL">        <![CDATA[select 1]]>    </queryString>    <background>        <band splitType="Stretch"/>    </background>    <pageHeader>        <band height="40" splitType="Stretch">            <property name="com.jaspersoft.studio.unit.height" value="px"/>            <textField pattern="dd/MM/yyyy">                <reportElement positionType="Float" x="379" y="0"                               width="80" height="20" forecolor="#27272F"                               uuid="a29fce94-a139-4d14-b782-9fe95ed43793">                    <property name="com.jaspersoft.studio.unit.width" value="px"/>                    <property name="com.jaspersoft.studio.unit.height" value="px"/>                    <property name="com.jaspersoft.studio.unit.x" value="px"/>                </reportElement>                <textElement textAlignment="Right">                    <font size="8"/>                </textElement>                <textFieldExpression>                    <![CDATA[new java.util.Date()]]>                </textFieldExpression>            </textField>            <textField pattern="HH:mm">                <reportElement positionType="Float" x="432" y="0"                               width="50" height="20" forecolor="#27272F"                               uuid="22d51de7-fdb2-4681-a3d4-bc3ba4a4cc65">                    <property name="com.jaspersoft.studio.unit.width" value="px"/>                    <property name="com.jaspersoft.studio.unit.height" value="px"/>                    <property name="com.jaspersoft.studio.unit.x" value="px"/>                </reportElement>                <textElement textAlignment="Right">                    <font size="8"/>                </textElement>                <textFieldExpression>                    <![CDATA[new java.util.Date()]]>                </textFieldExpression>            </textField>            <frame>                <reportElement positionType="Float" stretchType="ContainerHeight"                               x="0" y="20" width="554" height="20"                               isRemoveLineWhenBlank="true"                               isPrintInFirstWholeBand="true"                               uuid="58d13352-4653-4587-827c-ea222229bbbe">                    <property name="com.jaspersoft.studio.unit.height" value="px"/>                    <property name="com.jaspersoft.studio.unit.width" value="px"/>                    <printWhenExpression>                        <![CDATA[new Boolean($V{PAGE_NUMBER} == 1)]]>                    </printWhenExpression>                </reportElement>                <frame>                    <reportElement positionType="Float" mode="Opaque"                                   x="0" y="0" width="554" height="20"                                   backcolor="#D9D9D9"                                   uuid="7199097a-7296-410a-91f4-250495caab85">                        <property name="com.jaspersoft.studio.layout"                                  value="com.jaspersoft.studio.editor.layout.FreeLayout"/>                        <property name="com.jaspersoft.studio.unit.height" value="px"/>                        <property name="com.jaspersoft.studio.unit.y" value="px"/>                        <property name="com.jaspersoft.studio.unit.width" value="px"/>                    </reportElement>                    <box leftPadding="1" bottomPadding="1" rightPadding="1">                        <pen lineColor="#9FEDE5"/>                        <topPen    lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                        <leftPen   lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                        <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                        <rightPen  lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                    </box>                    <staticText>                        <reportElement positionType="Float" x="0" y="0" width="552"                                       height="20" forecolor="#27272F"                                       uuid="592cfe50-8cc4-473d-bac5-93c67922aedd">                            <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                            <property name="com.jaspersoft.studio.unit.width"  value="px"/>                        </reportElement>                        <box topPadding="1" leftPadding="1" bottomPadding="1" rightPadding="1"/>                        <textElement textAlignment="Center" verticalAlignment="Middle">                            <font size="10" isBold="true"/>                        </textElement>                        <text><![CDATA[iNFO FROM PARAMETERS]]></text>                    </staticText>                </frame>            </frame>            <textField evaluationTime="Master">                <reportElement positionType="Float" x="442" y="0" width="112"                               height="20" forecolor="#27272F"                               uuid="921629e5-89b3-4d65-886d-fe20c21fa84b">                    <property name="com.jaspersoft.studio.unit.height" value="px"/>                    <property name="com.jaspersoft.studio.unit.width" value="px"/>                    <property name="com.jaspersoft.studio.unit.x" value="px"/>                </reportElement>                <textElement textAlignment="Right">                    <font size="8"/>                </textElement>                <textFieldExpression>                    <![CDATA["Página "+$V{MASTER_CURRENT_PAGE}+" de "+$V{MASTER_TOTAL_PAGES}]]>                </textFieldExpression>            </textField>        </band>    </pageHeader>    <columnHeader>        <band height="14" splitType="Stretch">            <property name="com.jaspersoft.studio.unit.height" value="px"/>            <line>                <reportElement x="0" y="13" width="555" height="1" forecolor="#595959"                               uuid="34831667-1d80-4cae-a91d-d6651c1cf3f4">                    <property name="com.jaspersoft.studio.unit.x" value="px"/>                    <property name="com.jaspersoft.studio.unit.height" value="px"/>                </reportElement>            </line>            <staticText>                <reportElement x="0" y="0" width="32" height="14" forecolor="#27272F"                               uuid="549ff20c-f7e6-46b8-b431-d361f478c4a5">                    <property name="com.jaspersoft.studio.spreadsheet.connectionID"                              value="4a6727e1-e6e7-4a70-8291-1a81b0a10118"/>                    <property name="com.jaspersoft.studio.unit.width" value="px"/>                </reportElement>                <textElement verticalAlignment="Middle">                    <font size="8" isBold="true"/>                </textElement>                <text><![CDATA[Cliente]]></text>            </staticText>            <staticText>                <reportElement x="130" y="0" width="60" height="14"                               forecolor="#27272F"                               uuid="835a1ff7-8ed8-4a88-b5f1-00cd6677957c">                    <property name="com.jaspersoft.studio.spreadsheet.connectionID"                              value="88aaba7a-4029-4a82-b1c2-ee8e93b1feb2"/>                    <property name="com.jaspersoft.studio.unit.width" value="px"/>                    <property name="com.jaspersoft.studio.unit.x" value="px"/>                </reportElement>                <textElement verticalAlignment="Middle">                    <font size="8" isBold="true"/>                </textElement>                <text><![CDATA[Documento]]></text>            </staticText>            <staticText>                <reportElement x="200" y="0" width="70" height="14"                               forecolor="#27272F"                               uuid="dd5bfaf9-d080-4499-86f2-a7e0e4d3b492">                    <property name="com.jaspersoft.studio.spreadsheet.connectionID"                              value="5c2a2b79-9bac-4851-b7b3-c7642b0976ad"/>                    <property name="com.jaspersoft.studio.unit.width" value="px"/>                    <property name="com.jaspersoft.studio.unit.x" value="px"/>                </reportElement>                <textElement verticalAlignment="Middle">                    <font size="8" isBold="true"/>                </textElement>                <text><![CDATA[Nosso Número]]></text>            </staticText>            <staticText>                <reportElement x="280" y="0" width="70" height="14"                               forecolor="#27272F"                               uuid="33fb80ff-5f98-4c6f-ae62-1695b0b08490">                    <property name="com.jaspersoft.studio.spreadsheet.connectionID"                              value="d4028cee-3416-4e73-8c8d-56b544671f27"/>                    <property name="com.jaspersoft.studio.unit.width" value="px"/>                </reportElement>                <textElement verticalAlignment="Middle">                    <font size="8" isBold="true"/>                </textElement>                <text><![CDATA[Valor]]></text>            </staticText>            <staticText>                <reportElement x="350" y="0" width="60" height="14"                               forecolor="#27272F"                               uuid="056f347b-d9a2-49ee-8674-8d31e9b07ea8">                    <property name="com.jaspersoft.studio.spreadsheet.connectionID"                              value="8e8f8fed-a90c-4c5b-b2cc-d0ad1c49dc1a"/>                    <property name="com.jaspersoft.studio.unit.width" value="px"/>                </reportElement>                <textElement verticalAlignment="Middle">                    <font size="8" isBold="true"/>                </textElement>                <text><![CDATA[Vencimento]]></text>            </staticText>            <staticText>                <reportElement x="420" y="0" width="134" height="14"                               forecolor="#27272F"                               uuid="af29b7ba-2bc2-45be-a78a-f70bda792540">                    <property name="com.jaspersoft.studio.spreadsheet.connectionID"                              value="8e8f8fed-a90c-4c5b-b2cc-d0ad1c49dc1a"/>                    <property name="com.jaspersoft.studio.unit.width" value="px"/>                </reportElement>                <textElement verticalAlignment="Middle">                    <font size="8" isBold="true"/>                </textElement>                <text><![CDATA[Ocorrência]]></text>            </staticText>        </band>    </columnHeader>    <detail>        <band height="30" splitType="Stretch">            <property name="com.jaspersoft.studio.unit.height" value="px"/>            <subreport>                <reportElement x="0" y="0" width="130" height="30"                               uuid="914c099d-14bb-48a7-a696-73973de7093b">                    <property name="com.jaspersoft.studio.unit.y" value="px"/>                    <property name="com.jaspersoft.studio.unit.height" value="px"/>                    <property name="com.jaspersoft.studio.unit.width" value="px"/>                </reportElement>                <dataSourceExpression>                    <![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($P{CLIENTELIST})]]>                </dataSourceExpression>                <subreportExpression>                    <![CDATA["SUBREPORT.jasper"]]>                </subreportExpression>            </subreport>            <subreport>                <reportElement x="130" y="0" width="70" height="30"                               uuid="924b44a1-81c6-4634-929d-e0ece1e11e2a">                    <property name="com.jaspersoft.studio.unit.y" value="px"/>                    <property name="com.jaspersoft.studio.unit.height" value="px"/>                </reportElement>                <dataSourceExpression>                    <![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($P{DOCUMENTOLIST})]]>                </dataSourceExpression>                <subreportExpression>                    <![CDATA["SUBREPORT_VALOR.jasper"]]>                </subreportExpression>            </subreport>            <subreport>                <reportElement x="200" y="0" width="80" height="30"                               uuid="c957a547-8e5f-4985-83fd-cc7eebbe8568"/>                <dataSourceExpression>                    <![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($P{NOSSONUMEROLIST})]]>                </dataSourceExpression>                <subreportExpression>                    <![CDATA["SUBREPORT_NUMERO.jasper"]]>                </subreportExpression>            </subreport>            <subreport>                <reportElement x="280" y="0" width="70" height="30"                               uuid="735a18c3-59ff-425f-9752-4a54a29b7ccf">                    <property name="com.jaspersoft.studio.unit.y" value="px"/>                    <property name="com.jaspersoft.studio.unit.height" value="px"/>                </reportElement>                <dataSourceExpression>                    <![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($P{VALORLIST})]]>                </dataSourceExpression>                <subreportExpression>                    <![CDATA["SUBREPORT_VALOR.jasper"]]>                </subreportExpression>            </subreport>            <subreport>                <reportElement x="350" y="0" width="70" height="30"                               uuid="417264e1-2694-462b-8cdc-a2768c3ef18c"/>                <dataSourceExpression>                    <![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($P{VENCIMENTOLIST})]]>                </dataSourceExpression>                <subreportExpression>                    <![CDATA["SUBREPORT_VALOR.jasper"]]>                </subreportExpression>            </subreport>            <subreport>                <reportElement x="420" y="0" width="135" height="30"                               uuid="5b686650-452c-4286-8513-163fa164f3ce">                    <property name="com.jaspersoft.studio.unit.y" value="px"/>                    <property name="com.jaspersoft.studio.unit.height" value="px"/>                </reportElement>                <dataSourceExpression>                    <![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($P{OCORRENCIALIST})]]>                </dataSourceExpression>                <subreportExpression>                    <![CDATA["SUBREPORT_OCORRENCIA.jasper"]]>                </subreportExpression>            </subreport>        </band>    </detail></jasperReport>[/code]

     

    Convert string to collection

    in Products

    Posted

    Can i use this method when i call the report from jasperserver?
    Since the data is not static, the data is filled by the user, so i dont know if it works. Btw im not programming in java, and i dont know much about java, its a angular project.

    Convert string to collection

    in Products

    Posted

    I call the report in my code when a button is pressed, and some parameters are sent, 2 of them are strings that i need to show in the detail band. I dont run any sql in this report. Its all about the data i get from the parameters to build the report.

    Convert string to collection

    in Products

    Posted

    So, i have a report that has 2 parameters that are strings and look like this, "1,2,3" "john,dave,bob", and i want to iterate them into the detail band, how can i do that? I tried to cast them to collection using .split(",") but cant seem to iterate them. Any help would be appreciated.

×
×
  • Create New...

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

Products

Explore