ismailseylan Posted August 12, 2017 Share Posted August 12, 2017 I created master and subreport with paramaters but i couldn make subreport visible <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.4.0.final using JasperReports Library version 6.4.1 --><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="hasilatlistesi" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="9ceaedd0-93af-4fc5-b90b-c35b20902fd5"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="vt"/> <property name="net.sf.jasperreports.data.adapter" value="vt.xml"/> <parameter name="tarihp" class="java.sql.Date"/> <parameter name="sube" class="java.lang.Integer"> <parameterDescription><![CDATA[]]></parameterDescription> <defaultValueExpression><![CDATA[1]]></defaultValueExpression> </parameter> <queryString language="SQL"> <![CDATA[select h.*, CONCAT(c.sube ,' Günlük Kasa Raporu')subeadi from vt.thasilat hjointsube c on h.sube=c.id where h.tarih =$P{tarihp} and h.sube= $P{sube}]]> </queryString> <field name="hasilatid" class="java.lang.Integer"/> <field name="tarih" class="java.sql.Date"/> <field name="PCCiro" class="java.lang.Double"/> <field name="NakitCiro" class="java.lang.Double"/> <field name="POS" class="java.lang.Double"/> <field name="Sodexo" class="java.lang.Double"/> <field name="MUltinet" class="java.lang.Double"/> <field name="Setcard" class="java.lang.Double"/> <field name="Yemek_ceki" class="java.lang.Double"/> <field name="Yemeksepeti" class="java.lang.Double"/> <field name="EKmek" class="java.lang.Integer"/> <field name="Ayran" class="java.lang.Integer"/> <field name="cola" class="java.lang.Integer"/> <field name="Tavuk" class="java.lang.Double"/> <field name="Et" class="java.lang.Double"/> <field name="aciklama" class="java.lang.String"/> <field name="Nakit" class="java.lang.Double"/> <field name="kasa" class="java.lang.Double"/> <field name="yevmiye" class="java.lang.Double"/> <field name="harcama" class="java.lang.Double"/> <field name="posciro_gerceklesen" class="java.lang.Double"/> <field name="d_nakit" class="java.lang.Double"/> <field name="perid" class="java.lang.Integer"/> <field name="sube" class="java.lang.Integer"/> <field name="subeadi" class="java.lang.String"/> <variable name="dbozukluk" class="java.lang.Float" resetType="Column" calculation="Sum"> <variableExpression><![CDATA[$F{d_nakit}+$F{Nakit}]]></variableExpression> </variable> <group name="hasilatid"> <groupExpression><![CDATA[$F{hasilatid}]]></groupExpression> </group> <group name="tarih"> <groupExpression><![CDATA[$F{tarih}]]></groupExpression> </group> <group name="PCCiro"> <groupExpression><![CDATA[$F{PCCiro}]]></groupExpression> </group> <group name="NakitCiro"> <groupExpression><![CDATA[$F{NakitCiro}]]></groupExpression> </group> <group name="POS"> <groupExpression><![CDATA[$F{POS}]]></groupExpression> </group> <group name="Sodexo"> <groupExpression><![CDATA[$F{Sodexo}]]></groupExpression> </group> <group name="MUltinet"> <groupExpression><![CDATA[$F{MUltinet}]]></groupExpression> </group> <group name="Setcard"> <groupExpression><![CDATA[$F{Setcard}]]></groupExpression> </group> <group name="Yemek_ceki"> <groupExpression><![CDATA[$F{Yemek_ceki}]]></groupExpression> </group> <group name="Yemeksepeti"> <groupExpression><![CDATA[$F{Yemeksepeti}]]></groupExpression> </group> <group name="EKmek"> <groupExpression><![CDATA[$F{EKmek}]]></groupExpression> </group> <group name="Ayran"> <groupExpression><![CDATA[$F{Ayran}]]></groupExpression> </group> <group name="cola"> <groupExpression><![CDATA[$F{cola}]]></groupExpression> </group> <group name="Tavuk"> <groupExpression><![CDATA[$F{Tavuk}]]></groupExpression> </group> <group name="Et"> <groupExpression><![CDATA[$F{Et}]]></groupExpression> </group> <group name="aciklama"> <groupExpression><![CDATA[$F{aciklama}]]></groupExpression> </group> <group name="Nakit"> <groupExpression><![CDATA[$F{Nakit}]]></groupExpression> </group> <group name="kasa"> <groupExpression><![CDATA[$F{kasa}]]></groupExpression> </group> <group name="yevmiye"> <groupExpression><![CDATA[$F{yevmiye}]]></groupExpression> </group> <group name="harcama"> <groupExpression><![CDATA[$F{harcama}]]></groupExpression> </group> <group name="posciro_gerceklesen"> <groupExpression><![CDATA[$F{posciro_gerceklesen}]]></groupExpression> </group> <group name="d_nakit"> <groupExpression><![CDATA[$F{d_nakit}]]></groupExpression> </group> <group name="perid"> <groupExpression><![CDATA[$F{perid}]]></groupExpression> </group> <group name="sube"> <groupExpression><![CDATA[$F{sube}]]></groupExpression> </group> <background> <band splitType="Stretch"/> </background> <columnHeader> <band height="242" splitType="Stretch"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> <textField> <reportElement x="-18" y="99" width="71" height="22" uuid="b74f3eef-474d-443d-b202-788a468a6f8d"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{PCCiro}]]></textFieldExpression> </textField> <textField> <reportElement x="66" y="99" width="71" height="22" uuid="eb07bfa5-1ab2-4256-977a-dfc4bfed8e87"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{NakitCiro}]]></textFieldExpression> </textField> <textField> <reportElement x="145" y="99" width="55" height="22" uuid="e50dcac8-1b8e-409e-aa14-10f29027d2ee"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{kasa}]]></textFieldExpression> </textField> <textField> <reportElement x="210" y="99" width="71" height="22" uuid="2c296084-6924-48f8-9d04-b20ad41cc133"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{yevmiye}]]></textFieldExpression> </textField> <frame> <reportElement mode="Opaque" x="-20" y="80" width="595" height="20" backcolor="#F70C30" uuid="fbca62f4-efa8-4f61-bdfc-55146861d0c8"/> <staticText> <reportElement x="0" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="3710ba30-36c1-4f80-a697-2468b82a8ce8"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Pc Ciro]]></text> </staticText> <staticText> <reportElement x="82" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="b867c1ee-29a2-42d3-9dd7-f113f16dee3b"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Nakit Ciro]]></text> </staticText> <staticText> <reportElement x="161" y="0" width="59" height="20" forecolor="#FFFFFF" uuid="c90ee9f7-a6bd-426a-8e60-62b03ff5e5ac"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Kasa]]></text> </staticText> <staticText> <reportElement x="220" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="5a307d72-a611-4c67-b255-899e6af00dfb"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Yevmiye]]></text> </staticText> <staticText> <reportElement x="290" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="a77f2050-8c36-4e2f-972f-d0c2a731586e"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Masraf]]></text> </staticText> <staticText> <reportElement x="370" y="0" width="81" height="20" forecolor="#FFFFFF" uuid="a9aeae4f-a139-4261-a03b-d0b7a22b6e8a"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[D. Bozukluk]]></text> </staticText> <staticText> <reportElement x="451" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="0e6179e3-45a9-4502-9d8d-c3938c1e35b9"/> <textElement textAlignment="Left"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[b. Bozukluk]]></text> </staticText> <staticText> <reportElement x="522" y="-1" width="71" height="20" forecolor="#FFFFFF" uuid="3827289a-b029-4779-ab64-32be6eac9657"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[bozukluk]]></text> </staticText> </frame> <textField> <reportElement x="281" y="100" width="63" height="22" uuid="9f7c247c-42e0-49bc-bef6-45e8d186ebc7"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{harcama}]]></textFieldExpression> </textField> <textField> <reportElement x="430" y="100" width="71" height="22" uuid="49f739c8-06f9-49f1-8a35-5f35abdfb227"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{d_nakit}]]></textFieldExpression> </textField> <textField> <reportElement x="510" y="100" width="51" height="22" uuid="421074f6-1c54-4916-aadd-f9af4b875fea"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{Nakit}]]></textFieldExpression> </textField> <textField> <reportElement x="360" y="100" width="63" height="22" uuid="d37e6e98-26f2-4a58-bcc7-3e22d8ae6770"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{d_nakit}.floatValue()+$F{Nakit}.floatValue()]]></textFieldExpression> </textField> <textField> <reportElement x="-13" y="148" width="71" height="22" uuid="51e9edc4-525c-40ab-90db-8cc62818dccf"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{POS}]]></textFieldExpression> </textField> <textField> <reportElement x="71" y="148" width="71" height="22" uuid="e79516b4-2df8-4ee9-9e09-2ebf29dbd971"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{Sodexo}]]></textFieldExpression> </textField> <textField> <reportElement x="150" y="148" width="55" height="22" uuid="0a97dea2-00af-4d59-949a-889e90803326"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{MUltinet}]]></textFieldExpression> </textField> <textField> <reportElement x="215" y="148" width="71" height="22" uuid="da05f995-ff17-48a9-9c07-46830d787d2b"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{Setcard}]]></textFieldExpression> </textField> <frame> <reportElement mode="Opaque" x="-20" y="129" width="595" height="20" backcolor="#370CF7" uuid="d5c8da2c-cce2-4afe-8218-025977d84489"/> <staticText> <reportElement x="0" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="2ddc1fbd-1110-4196-b69d-24c70447c790"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Pos]]></text> </staticText> <staticText> <reportElement x="82" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="f8d4bdc4-84a1-4332-9105-93ee9088e33f"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[sodexo]]></text> </staticText> <staticText> <reportElement x="161" y="0" width="59" height="20" forecolor="#FFFFFF" uuid="80973c42-5d9a-40fc-bdd0-e471f455423a"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Multinet]]></text> </staticText> <staticText> <reportElement x="220" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="b6234219-ea1f-4b63-b3e3-8630b2adaf05"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[setKart]]></text> </staticText> <staticText> <reportElement x="290" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="594fa738-56ba-4adc-bb61-c55857b779ac"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Yemek Çeki]]></text> </staticText> <staticText> <reportElement x="370" y="0" width="81" height="20" forecolor="#FFFFFF" uuid="d3feb192-3c20-472f-80b8-8eff621f6a26"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Yemek Sepeti]]></text> </staticText> </frame> <textField> <reportElement x="286" y="149" width="63" height="22" uuid="02459b71-9669-48c3-90e7-aa9feca1cacd"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{Yemek_ceki}]]></textFieldExpression> </textField> <textField> <reportElement x="365" y="149" width="63" height="22" uuid="8f32e280-56a7-4ef5-bdcb-34c12c00fec4"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{Yemeksepeti}]]></textFieldExpression> </textField> <textField> <reportElement x="-13" y="196" width="71" height="22" uuid="c73b45fb-165c-4583-9320-b43cc3c52066"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{EKmek}]]></textFieldExpression> </textField> <textField> <reportElement x="71" y="196" width="71" height="22" uuid="0738a24f-47fe-4774-aa41-62b91fd8752a"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{Ayran}]]></textFieldExpression> </textField> <textField> <reportElement x="150" y="196" width="55" height="22" uuid="ccfb9f49-8357-4aac-841e-600772d48ae4"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{cola}]]></textFieldExpression> </textField> <textField> <reportElement x="215" y="196" width="71" height="22" uuid="a671bf8b-7ba1-4214-86ab-6e7c6e8f82bc"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{Tavuk}]]></textFieldExpression> </textField> <frame> <reportElement mode="Opaque" x="-20" y="177" width="595" height="20" backcolor="#F70C30" uuid="2d9e7d64-8ce6-4859-8e73-513506f9adee"/> <staticText> <reportElement x="2" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="c046ae9f-561f-428b-98df-5ee04140c1a0"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Ekmek]]></text> </staticText> <staticText> <reportElement x="84" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="74cbaee7-8d2f-4ab5-884e-d4fc3fe3bd6e"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Ayran]]></text> </staticText> <staticText> <reportElement x="163" y="0" width="59" height="20" forecolor="#FFFFFF" uuid="e48aeb78-2b0f-43b0-b369-cead9389acee"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Kola]]></text> </staticText> <staticText> <reportElement x="222" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="573e3914-2442-4cf4-b119-8c137ba5a256"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Tavuk]]></text> </staticText> <staticText> <reportElement x="292" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="3024258d-9794-4aa6-8220-44c45ecd2bca"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Et]]></text> </staticText> </frame> <textField> <reportElement x="286" y="197" width="63" height="22" uuid="0bc14029-27dc-455e-ab5f-26ec07bef4d7"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font fontName="SansSerif" pdfFontName="Helvetica" pdfEncoding="Cp1254"/> </textElement> <textFieldExpression><![CDATA[$F{Et}]]></textFieldExpression> </textField> <staticText> <reportElement x="478" y="-11" width="73" height="15" forecolor="#000000" uuid="5f4987c6-14cb-437f-a241-c40ad6d706b7"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="10" pdfEncoding="Cp1254" isPdfEmbedded="false"/> </textElement> <text><![CDATA[Tarih]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="dd.MM.yyy"> <reportElement x="478" y="4" width="73" height="15" uuid="55337b23-d2e2-4904-bb3d-3485ae280f12"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <box> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="10" isBold="true" pdfEncoding="Cp1254" isPdfEmbedded="false"/> </textElement> <textFieldExpression><![CDATA[$F{tarih}]]></textFieldExpression> </textField> <textField> <reportElement x="80" y="10" width="451" height="48" uuid="c1dbb7b5-adf6-4c97-9b67-0f434c3f9b2e"/> <textElement> <font size="26" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{subeadi}]]></textFieldExpression> </textField> </band> </columnHeader> <detail> <band height="245" splitType="Immediate"> <line> <reportElement x="-20" y="-12" width="595" height="1" forecolor="#F70C30" uuid="a32bad7c-fcc3-4f00-8bc5-cd8666b8bcd2"/> </line> <subreport> <reportElement positionType="Float" x="-15" y="-6" width="245" height="16" isRemoveLineWhenBlank="true" uuid="f6b913d9-bc8c-4e04-a6ce-29182674a795"/> <subreportParameter name="tarihp"> <subreportParameterExpression><![CDATA[$P{tarihp}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="sube"> <subreportParameterExpression><![CDATA[$P{sube}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["personelgunluk.jasper"]]></subreportExpression> </subreport> <subreport> <reportElement key="" x="244" y="-10" width="300" height="20" isRemoveLineWhenBlank="true" uuid="810c1b7d-1ff2-400c-a0e7-10a4dcad0747"/> <subreportParameter name="tarihp"> <subreportParameterExpression><![CDATA[$P{tarihp}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="sube"> <subreportParameterExpression><![CDATA[$P{sube}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["gunluk_harcama.jasper"]]></subreportExpression> </subreport> <subreport> <reportElement positionType="Float" x="244" y="10" width="200" height="20" isRemoveLineWhenBlank="true" uuid="7edb4396-b83a-45e3-849b-cb078abab63c"/> <subreportParameter name="tarihp"> <subreportParameterExpression><![CDATA[$P{tarihp}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="sube"> <subreportParameterExpression><![CDATA[$P{sube}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["harcama_gunluk_dahil_degil.jasper"]]></subreportExpression> </subreport> <subreport> <reportElement positionType="Float" x="-13" y="10" width="200" height="22" isRemoveLineWhenBlank="true" uuid="be94c289-b218-4f37-9073-7e0b13949c0e"/> <subreportParameter name="tarihp"> <subreportParameterExpression><![CDATA[$P{tarihp}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="sube"> <subreportParameterExpression><![CDATA[$P{sube}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["personeltoplamcari.jasper"]]></subreportExpression> </subreport> <subreport> <reportElement positionType="Float" x="250" y="30" width="200" height="20" isRemoveLineWhenBlank="true" uuid="77bfbbb8-3a19-4f49-908b-c45b9a17c7a2"/> <subreportParameter name="tarihp"> <subreportParameterExpression><![CDATA[$P{tarihp}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="sube"> <subreportParameterExpression><![CDATA[$P{sube}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["firmatoplamcari.jasper"]]></subreportExpression> </subreport> </band> </detail></jasperReport> one of subreport <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.4.0.final using JasperReports Library version 6.4.1 --><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="personel_gunluk" pageWidth="212" pageHeight="936" columnWidth="172" leftMargin="20" rightMargin="20" topMargin="0" bottomMargin="0" uuid="b0ccb68f-7282-47cc-b296-07620d558b4b"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="vt"/> <style name="Row" mode="Transparent"> <conditionalStyle> <conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression> <style backcolor="#F5F5DC"/> </conditionalStyle> </style> <parameter name="sube" class="java.lang.Integer" isForPrompting="false"/> <parameter name="tarihp" class="java.sql.Date" isForPrompting="false"/> <queryString language="SQL"> <![CDATA[sELECT vt.spersonel_odenen_gun.unvan, vt.spersonel_odenen_gun.`Yevmiye`, vt.spersonel_odenen_gun.tarih, vt.spersonel_odenen_gun.subeFROM vt.spersonel_odenen_gunWHERE vt.spersonel_odenen_gun.tarih = $P{tarihp} AND vt.spersonel_odenen_gun.sube = $P{sube} ORDER BY vt.spersonel_odenen_gun.`Yevmiye` DESC]]> </queryString> <field name="unvan" class="java.lang.String"/> <field name="Yevmiye" class="java.lang.Double"/> <field name="tarih" class="java.sql.Date"/> <field name="sube" class="java.lang.Integer"/> <variable name="toplam" class="java.lang.Float" calculation="Sum"> <variableExpression><![CDATA[$F{Yevmiye}]]></variableExpression> </variable> <background> <band splitType="Stretch"/> </background> <columnHeader> <band height="47" splitType="Stretch"> <staticText> <reportElement x="-12" y="0" width="204" height="20" uuid="c4c8a2b1-bc41-4085-bf11-c6ad1f17566a"/> <textElement> <font size="14" isBold="true"/> </textElement> <text><![CDATA[PersoneleGünlük Ödeme]]></text> </staticText> <frame> <reportElement mode="Opaque" x="-15" y="27" width="203" height="20" backcolor="#65D446" uuid="009dbc58-d6f7-4c86-a428-5b70c484daeb"/> <staticText> <reportElement x="0" y="0" width="100" height="20" forecolor="#FFFFFF" uuid="2aaf33a2-6e71-4d05-9037-187356e2b569"/> <textElement> <font size="14"/> </textElement> <text><![CDATA[Personel Ünvanı]]></text> </staticText> <staticText> <reportElement x="129" y="0" width="71" height="20" forecolor="#FFFFFF" uuid="f532c0fe-1a74-4454-a3a0-eedce34cf59b"/> <textElement> <font size="14"/> </textElement> <text><![CDATA[Tutarı]]></text> </staticText> </frame> </band> </columnHeader> <detail> <band height="15" splitType="Stretch"> <frame> <reportElement style="Row" mode="Opaque" x="-1" y="0" width="189" height="14" forecolor="#FFFFFF" backcolor="#FFFFFF" uuid="66162e82-8cfd-4800-bafb-5121bb3b5ef8"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <frame> <reportElement key="" style="Row" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="1" width="189" height="13" uuid="1e712e2d-ce41-4afa-aa99-14abb1584339"/> <box> <pen lineWidth="0.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid"/> <leftPen lineWidth="0.0" lineStyle="Solid"/> <bottomPen lineWidth="0.0" lineStyle="Solid"/> <rightPen lineWidth="0.0" lineStyle="Solid"/> </box> <textField> <reportElement x="-10" y="1" width="110" height="13" uuid="8b05e30e-620f-4fd5-84a0-9251da9041ba"/> <textFieldExpression><![CDATA[$F{unvan}]]></textFieldExpression> </textField> <textField pattern="#,##0.##;¤-#,##0.## ¤"> <reportElement isPrintRepeatedValues="false" x="105" y="0" width="70" height="13" uuid="f5cbb056-3a7e-4805-b05e-f84ec790c141"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$F{Yevmiye}]]></textFieldExpression> </textField> </frame> </frame> </band> </detail> <columnFooter> <band height="3" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="2" splitType="Stretch"/> </pageFooter> <summary> <band height="24" splitType="Stretch"> <frame> <reportElement mode="Opaque" x="-12" y="0" width="200" height="20" backcolor="#65D446" uuid="ba534fe3-316e-4a9b-bab6-9459e2c881b9"/> <staticText> <reportElement x="0" y="0" width="100" height="20" forecolor="#FFFFFF" uuid="86857f47-679c-442c-b4bd-68cd909bd0b6"/> <textElement> <font size="14"/> </textElement> <text><![CDATA[Toplam]]></text> </staticText> <textField> <reportElement x="90" y="2" width="100" height="20" forecolor="#FFFFFF" uuid="dee4b2d1-be2c-4503-bbe1-f386054cc282"/> <textElement textAlignment="Right"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$V{toplam}]]></textFieldExpression> </textField> </frame> </band> </summary></jasperReport> Link to comment Share on other sites More sharing options...
vchiem Posted August 14, 2017 Share Posted August 14, 2017 If its any help, there is a subreport sample in Studio project "JasperReports Sample" that you can look at and compare.. In Studio, you can create the JasperReports Sample project by doing a File -> New and following the wizard. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now