<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad  -->
<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="sr" language="javascript" pageWidth="350" pageHeight="100" orientation="Landscape" columnWidth="330" leftMargin="10" rightMargin="10" topMargin="10" bottomMargin="10" uuid="ac85b8b8-1e00-4f16-bc48-a579f06e8ba1">
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="rosa"/>
	<queryString language="SQL">
		<![CDATA[SELECT
	IF(GROUPING(mes_ano),
        'TOTAL',
        mes_ano)  as MES,
   	SUM(TOTAL_bs) AS TOTAL_BS
FROM
	premios_mes
GROUP BY
mes_ano
WITH ROLLUP;]]>
	</queryString>
	<field name="MES" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="MES"/>
		<property name="com.jaspersoft.studio.field.label" value="MES"/>
	</field>
	<field name="TOTAL_BS" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="TOTAL_BS"/>
		<property name="com.jaspersoft.studio.field.label" value="TOTAL_BS"/>
	</field>
	<group name="MES">
		<groupExpression><![CDATA[$F{MES}]]></groupExpression>
	</group>
	<group name="TOTAL_BS">
		<groupExpression><![CDATA[$F{TOTAL_BS}]]></groupExpression>
	</group>
	<columnHeader>
		<band height="20" splitType="Stretch">
			<staticText>
				<reportElement x="24" y="1" width="119" height="15" uuid="328238d3-1d35-4021-849a-ab318bc476c4">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="eb6d59af-6a5f-4756-8b05-6b189cce0233"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[MES]]></text>
			</staticText>
			<staticText>
				<reportElement x="188" y="1" width="100" height="15" uuid="7e7ed46e-00f1-43fb-aa1d-1bf3271bdfe3">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="eeb0e5e8-31d7-4251-941f-410ae3499e34"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL BS]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="20" splitType="Stretch">
			<textField>
				<reportElement x="24" y="1" width="119" height="15" uuid="4746e3fb-ea1b-4233-895f-098aba8a9abe">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="eb6d59af-6a5f-4756-8b05-6b189cce0233"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{MES}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;(#,##0.00#-)">
				<reportElement x="188" y="1" width="100" height="15" uuid="81c57edc-6c66-4e95-a2bf-aaf1d6074616">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="eeb0e5e8-31d7-4251-941f-410ae3499e34"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{TOTAL_BS}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
