sirius.cybernetics

Just to be clear, I don't want ANY of the fields to appear from my CSV anywhere in the report, I'm only interested in showing the comparisons between the data in the CSV on the report (pie charts, etc.)

That worked, but now where am I supposed to place my report data? :/

Ok, so I had to go back and make my Field an Integer instead of a String, then changed the variable to be Integer type as well with Sum. Now it adds the values, but it keeps making a break and ONLY adding the next number in the sequence. Basically, I want ONE result, instead it's making pages like: lets say my values are 20, 30, 10, 30 in my CSV, it makes a bunch of numbers down the page like this: 20 50 60 90

Here is my page so far: ..insert your code here..<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version last--><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="BR_Sample" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="51a3c8c7-d06f-42a4-8483-f4ded8182f42"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="CSV Data"/> <queryString> <![CDATA[]]> </queryString> <field name="File Size" class="java.lang.Integer"/> <field name="Duplicate" class="java.lang.Integer"/> <variable name="Total DB Size" class="java.lang.Integer" resetType="None" calculation="Sum"> <variableExpression><![CDATA[$F{File Size}]]></variableExpression> </variable> <background> <band splitType="Stretch"/> </background> <title> <band height="80" splitType="Stretch"> <staticText> <reportElement key="" x="0" y="0" width="554" height="50" uuid="9437da8d-5530-423d-b03f-9f138414ad55"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="26" isBold="true"/> </textElement> <text><![CDATA[My Company]]></text> </staticText> <staticText> <reportElement x="0" y="50" width="554" height="29" uuid="3c59cfb8-2cc2-4cd7-9dc6-f9a2331402e8"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="16"/> </textElement> <text><![CDATA[Aggregated File Summary]]></text> </staticText> <image> <reportElement x="90" y="0" width="50" height="50" uuid="84b61705-aed8-4f21-b344-8aa3cd5871c8"/> <imageExpression><![CDATA["C:/Users/Admin/Google Drive/BIS/MyLogo.jpg"]]></imageExpression> </image> </band> </title> <pageHeader> <band height="20" splitType="Stretch"> <rectangle> <reportElement x="0" y="0" width="554" height="20" uuid="9fb9330f-45be-495b-9b4e-12397ff0ae5a"/> </rectangle> </band> </pageHeader> <columnHeader> <band splitType="Stretch"/> </columnHeader> <detail> <band height="169" splitType="Stretch"/> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"> <textField evaluationTime="Report"> <reportElement x="480" y="24" width="70" height="30" uuid="da64e3b2-efd4-4c21-9b2f-c120c4569b90"/> <textElement textAlignment="Left"/> <textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> <textField> <reportElement x="410" y="24" width="70" height="30" uuid="ad4241fe-95dc-4a3a-8495-e8052e5e2504"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="17" splitType="Stretch"/> </summary></jasperReport>[/code]

I have a CSV for a data source, the fields show in the left hand side (JasperSoft Studio), but I have nothing in my report at all, it's blank except for a static text string and a rectangle. If I press preview it generates thousands of pages (I have a lot of entries in my csv)... but WHY?! It's driving me nuts!

I have a CSV with a column (lets just called it "Checksums") that contains the file hash for around a million different files. I want to have Jaspersoft Studio 5.5.0 compare all the values and come out with a numerical value for the number of duplicates. I don't want it to display the actual duplicate checksums, I just want a numerical value of "how many values matched eachother". My end goal is to take that number and compare it to the total number of entries in my CSV and be able to show in a chart "Original Files" and "Duplicated Files".

Hello everyone, I just started with Jaspersoft Studio Pro 5.5.0 and I have a very simple question, but most of the results I can find are for the old iReport. Anyway; I'm trying to create a variable or text field that strictly shows the sum of all the "file sizes" (in bytes) in my csv (there is a column that contains the data). I created a variable with calculation "Sum" and expression "$F{File Size (in bytes)}" with an initial value of 0. The problem is, when I preview the report, it makes a couple thousand pages of the file sizes but one at a time for each file instead of adding them ALL together and just showing me 1 result. For bonus points, I would also like to have it move the decimal so it's a human readable value (instead of 1,232,654,123,534 bytes, show the result in Megabytes).