vpatelgwu.edu

I do not want to display columns heading and detail band is the main report returns 0 or no data. What Print expression should be set? I used $V{REPORT_COUNT} > 0 in print expression and it is hiding detail band but does not work for the column header

I have simple report Printing today's date if user who is running report is in list or Null user. My JSS version 6.6.0 query = SELECT sysdate FROM dual WHERE $X{IN,USER,Parameter1} DB oracle ISSUE Image How to set parameter1 to null? Some how "No Elements" get in and I do not know how to remove it. I have tried putting null , removing NO elements from text filed but no sucess. what I am doing wrong ..insert your code here..[/code]<?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0 --> <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="Blank_A4_5" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="4b40c444-8ffe-46b5-82e5-8cdfb81ecbb8"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="tstvrp@devl"/> <parameter name="Parameter1" class="java.util.List"/> <queryString language="SQL"> <![CDATA[sELECT sysdate FROM dual WHERE $X{IN,USER,Parameter1}]]> </queryString> <field name="SYSDATE" class="java.sql.Timestamp"> <property name="com.jaspersoft.studio.field.label" value="SYSDATE"/> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"/> </title> <pageHeader> <band height="35" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="61" splitType="Stretch"> <staticText> <reportElement x="209" y="0" width="80" height="20" uuid="6f0a9ec7-3d2d-444b-9326-4e21da8ed6c2"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="4c53c446-5a9e-4e10-b2a6-e760c3087529"/> </reportElement> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[Today's date]]></text> </staticText> </band> </columnHeader> <detail> <band height="125" splitType="Stretch"> <textField> <reportElement x="209" y="0" width="69" height="20" uuid="6a8dd072-867e-4121-b8dc-312630c15333"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="4c53c446-5a9e-4e10-b2a6-e760c3087529"/> </reportElement> <textFieldExpression><![CDATA[$F{SYSDATE}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary> </jasperReport>

Yeap chaning jrxml to jasper wiork for SUBREPORT. YOu can build project so that SUBreport get compiled

Did you find answer/workaround to this. I am using Dynamic report which is adding frame element in jasperprint and my csv meta data export are blanks. I am in same boat as you

How and what did you setup?

Can you please tell me how to add this csv meta data on JRDesignTextField item if I am generating template via Java Code?

JRDesignTextField textField = new JRDesignTextField(); textField.setX(xPos); textField.setY(2); textField.setWidth(columnWidth); textField.setHeight(COLUMN_HEIGHT); textField.setHorizontalAlignment(HorizontalAlignEnum.LEFT); textField.setStyle(normalStyle); JRDesignPropertyExpression propertyExpression = new JRDesignPropertyExpression(); JRDesignExpression expr = new JRDesignExpression(); expr.setValueClass(java.lang.String.class); expr.setText(COL_HEADER_EXPR_PREFIX + i); propertyExpression.setName("net.sf.jasperreports.export.xls.column.name"); propertyExpression.setValueExpression(expr); textField.addPropertyExpression(propertyExpression); [/code]I am building Jasper template on fly based on query given. I want to set below property of that Detail Section Testfiled item, "net.sf.jasperreports.export.xls.column.name" = "col1" "net.sf.jasperreports.export.csv.column.name"="col1" "net.sf.jasperreports.export.csv.repeat.value" = "true" How to do this? OR want ed to find what is happening behind the GUI of Ireport or jaspersoft when right click on filed and select csv metadata .....

Why when attached report exported using CSV meta expoerter it produce balnk CSV. when net.sf.jasperreports.export.csv.column.names is setup at report level This templete cn be run on any oracle database. <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 5.6.1.final using JasperReports Library version 5.6.1 --><!-- 2014-09-18T11:37:28 --><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="SZR2UGW_4896" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true" scriptletClass="ar.com.fdvs.dj.core.DJDefaultScriptlet" whenResourceMissingType="Key" uuid="bfcd2bb3-90ae-4a97-ac0b-1a0d067ee66f"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <property name="net.sf.jasperreports.export.xls.write.header" value="true"/> <property name="net.sf.jasperreports.export.xls.auto.fit.row" value="true"/> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> <property name="net.sf.jasperreports.export.csv.write.header" value="true"/> <property name="net.sf.jasperreports.export.xls.column.names" value="pidm,GWid,Full Name,Detail code,tier,Term code,Fee Amount,Course#,College,Tuition Amount,"/> <property name="net.sf.jasperreports.export.csv.column.names" value="pidm,GWid,Full Name,Detail code,tier,Term code,Fee Amount,Course#,College,Tuition Amount,"/> <property name="net.sf.jasperreports.export.pdf.size.page.to.content" value="true"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Banner DEVL (Baninst1)"/> <parameter name="ReportName" class="java.lang.String" isForPrompting="false"/> <parameter name="JobNumber" class="java.lang.Integer" isForPrompting="false"/> <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <parameterDescription><![CDATA[]]></parameterDescription> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <queryString language="SQL"> <![CDATA[/* Formatted on 9/18/2014 11:16:03 AM (QP5 v5.267.14150.38599) */SELECT 1 "pidm", 'XXXXXX' "GWid", 'Last, First' "Full Name", 'XPF2' "Detail code", DECODE ('XPF2', 'XPF1', 'TierI', 'XPF2', 'TierII', 'XPF3', 'TierIII', 'XPF4', 'TierIV', 'XPF5', 'TierV', 'LUNV', 'TierVI', 'None') "tier", '999999' "Term code", 999.99 "Fee Amount", '12345' "Course#", 'College Name' "College", 8888.88 "Tuition Amount" FROM DUALUNIONSELECT 2 "pidm", 'YYYYY' "GWid", 'Last2, First' "Full Name", 'XPF4' "Detail code", DECODE ('XPF4', 'XPF1', 'TierI', 'XPF2', 'TierII', 'XPF3', 'TierIII', 'XPF4', 'TierIV', 'XPF5', 'TierV', 'LUNV', 'TierVI', 'None') "tier", '000000' "Term code", 5555.55 "Fee Amount", '56789' "Course#", 'College Name2' "College", 7777.77 "Tuition Amount" FROM DUALORDER BY 2, 4]]> </queryString> <field name="pidm" class="java.math.BigDecimal"/> <field name="GWid" class="java.lang.String"/> <field name="Full Name" class="java.lang.String"/> <field name="Detail code" class="java.lang.String"/> <field name="tier" class="java.lang.String"/> <field name="Term code" class="java.lang.String"/> <field name="Fee Amount" class="java.math.BigDecimal"/> <field name="Course#" class="java.lang.String"/> <field name="College" class="java.lang.String"/> <field name="Tuition Amount" class="java.math.BigDecimal"/> <background> <band splitType="Stretch"/> </background> <title> <band height="40" splitType="Stretch"/> </title> <pageHeader> <band height="21" splitType="Stretch"> <textField> <reportElement x="473" y="0" width="80" height="20" uuid="e8b23a97-a7fe-4f85-a970-2a80c6404fc0"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> <line> <reportElement x="0" y="20" width="555" height="1" uuid="4e33ef87-b9de-4501-a30a-08e20c5d38f6"/> </line> </band> </pageHeader> <columnHeader> <band height="30"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="header_pidm" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="40" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="a4bca4a1-91e5-461a-8618-a3ec06636561"/> <textFieldExpression><![CDATA["pidm"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="header_GWid" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="40" y="0" width="45" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="ec82ec62-de29-45cc-900a-c1891bf8c3c0"/> <textFieldExpression><![CDATA["GWid"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="header_Full Name" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="85" y="0" width="85" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="6a15c889-82f1-40c5-b6e6-11b1bf78d5d4"/> <textFieldExpression><![CDATA["Full Name"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="header_Detail code" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="170" y="0" width="36" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="39b43535-b91d-49cc-bd43-9474ab41a8be"/> <textFieldExpression><![CDATA["Detail code"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="header_tier" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="206" y="0" width="35" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="24d228c7-5d68-40b3-9675-f6600ffb6be0"/> <textFieldExpression><![CDATA["tier"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="header_Term code" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="241" y="0" width="47" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="542f0231-2248-4240-99ca-1b6ff81cd09c"/> <textFieldExpression><![CDATA["Term code"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="header_Fee Amount" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="288" y="0" width="69" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="9040f0b9-e889-46d4-a54a-7032d609bf3d"/> <textFieldExpression><![CDATA["Fee Amount"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="header_Course#" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="357" y="0" width="33" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="32009470-e1a8-4177-8e1d-ce6c77369d4b"/> <textFieldExpression><![CDATA["Course#"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="header_College" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="390" y="0" width="83" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="323f582c-32ea-45fb-b816-c7a378779037"/> <textFieldExpression><![CDATA["College"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="header_Tuition Amount" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="473" y="0" width="82" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="e8de798d-2a92-404d-bf48-97d995950858"/> <textFieldExpression><![CDATA["Tuition Amount"]]></textFieldExpression> </textField> </band> </columnHeader> <detail> <band height="15" splitType="Stretch"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="40" height="15" isPrintWhenDetailOverflows="true" uuid="2bedf49a-348f-4055-9573-16b8617af51d"/> <textFieldExpression><![CDATA[$F{pidm}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="40" y="0" width="45" height="15" isPrintWhenDetailOverflows="true" uuid="affb27ee-9913-42f4-988f-c98383d92da1"/> <textFieldExpression><![CDATA[$F{GWid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="85" y="0" width="85" height="15" isPrintWhenDetailOverflows="true" uuid="8fa75214-8a2c-4cef-bff6-3d94abf13b9b"/> <textFieldExpression><![CDATA[$F{Full Name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="170" y="0" width="36" height="15" isPrintWhenDetailOverflows="true" uuid="8f1287ee-9d6d-4609-8d81-16bce0d19b30"/> <textFieldExpression><![CDATA[$F{Detail code}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="206" y="0" width="35" height="15" isPrintWhenDetailOverflows="true" uuid="c1d83694-98b8-44df-b4d3-7263a38fd163"/> <textFieldExpression><![CDATA[$F{tier}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="241" y="0" width="47" height="15" isPrintWhenDetailOverflows="true" uuid="45e233c3-e991-43a1-940a-46e5eac5fd92"/> <textFieldExpression><![CDATA[$F{Term code}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="$ 0.00" isBlankWhenNull="true"> <reportElement key="" positionType="Float" stretchType="RelativeToTallestObject" x="288" y="0" width="69" height="15" isPrintWhenDetailOverflows="true" uuid="d806d7c1-72e2-469e-ba70-28646d53a800"/> <textFieldExpression><![CDATA[$F{Fee Amount}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="357" y="0" width="33" height="15" isPrintWhenDetailOverflows="true" uuid="aa19acac-d91e-4013-9534-c2a2efec274b"/> <textFieldExpression><![CDATA[$F{Course#}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="390" y="0" width="83" height="15" isPrintWhenDetailOverflows="true" uuid="52179174-09c4-4ed3-8db0-d837d81f9272"/> <textFieldExpression><![CDATA[$F{College}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="$ 0.00" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="473" y="0" width="82" height="15" isPrintWhenDetailOverflows="true" uuid="f5ce9b98-61bd-45cc-a52f-2bd70ae2a399"/> <textFieldExpression><![CDATA[$F{Tuition Amount}]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="67" splitType="Stretch"> <staticText> <reportElement x="348" y="7" width="100" height="20" uuid="889975eb-661b-46a6-be5e-6d200a97ffca"/> <text><![CDATA[Report Count]]></text> </staticText> <textField> <reportElement x="450" y="7" width="100" height="20" uuid="affa24cb-6e3f-4a09-9b8c-2c8fa1a30750"/> <textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression> </textField> </band> </summary></jasperReport>[/code]

Did you Got your reply Yet? What are you using as of now? Did you converted any SQR to Groovy? ( If yes do you mind sharing)

Close case After couple of shutdown of application it is not Showing up.

Tried with 5.6.1. In 5.6.1 No submenu is getting displayed ( more issue than 5.6.0) Please see attahced screen shot and jrxml file