vpatelgwu.edu
-
Posts
12 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by vpatelgwu.edu
-
-
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 oracleHow 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?
-
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)
How to hide ( not display) if query returns no data
in Products
Posted
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