Jump to content
We've recently updated our Privacy Statement, available here ×

swapnilppawar76

Members
  • Posts

    6
  • Joined

  • Last visited

swapnilppawar76's Achievements

Rookie

Rookie (2/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Hello Guys , I have design one page on that i print the data in table format from database but it print the repeatetive cell as well. i remove that by unchecking " Print repeatetive value checkbox" but still it print the blank cell i want to remove that also. Please help me here i have provided my code : <?xml version="1.0" encoding="UTF-8"?><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="kunal" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="a2a06436-729d-4e8a-bfde-dd017137eccf"><property name="ireport.zoom" value="1.0"/><property name="ireport.x" value="0"/><property name="ireport.y" value="0"/><style name="Crosstab Data Text" hAlign="Center"/><style name="table"><box><pen lineWidth="1.0" lineColor="#000000"/></box></style><style name="table_TH" mode="Opaque" backcolor="#F0F8FF"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><style name="table_CH" mode="Opaque" backcolor="#BFE1FF"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><style name="table_TD" mode="Opaque" backcolor="#FFFFFF"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><style name="table 1"><box><pen lineWidth="1.0" lineColor="#000000"/></box></style><style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><subDataset name="New Dataset 1" uuid="b956fd40-5892-45e7-a12e-455b69bffebc"><queryString language="SQL"><![CDATA[sELECT D34TAILR3P0RT."VNAME" AS D34TAILR3P0RT_VNAME, D34TAILR3P0RT."VURL" AS D34TAILR3P0RT_VURLFROM "ADMIN"."D34TAILR3P0RT" D34TAILR3P0RT]]></queryString><field name="D34TAILR3P0RT_VNAME" class="java.lang.String"/><field name="D34TAILR3P0RT_VURL" class="java.lang.String"/><group name="D34TAILR3P0RT_VNAME"><groupExpression><![CDATA[$F{D34TAILR3P0RT_VNAME}]]></groupExpression></group><group name="D34TAILR3P0RT_VURL"><groupExpression><![CDATA[$F{D34TAILR3P0RT_VURL}]]></groupExpression></group></subDataset><parameter name="scan_no" class="java.lang.String"/><parameter name="user_name" class="java.lang.String"/><queryString><![CDATA[select vname,vurl from D34TAILR3P0RT where scan_no=$P{scan_no} and user_name=$P{user_name} order by vname]]></queryString><field name="VNAME" class="java.lang.String"><fieldDescription><![CDATA[]]></fieldDescription></field><field name="VURL" class="java.lang.String"><fieldDescription><![CDATA[]]></fieldDescription></field><background><band splitType="Stretch"/></background><detail><band height="125" splitType="Stretch"><componentElement><reportElement key="table 1" style="table 1" x="29" y="45" width="360" height="50" uuid="cfddddfd-9b5c-4af4-a2ed-1611f8fca1c8"/><jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"><datasetRun subDataset="New Dataset 1" uuid="3e8a82cd-6e63-4ce1-8ceb-c9566b9c9bf9"><connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression></datasetRun><jr:column width="265" uuid="e23dad9a-9d25-4f3a-939c-ccec747fd577"><jr:columnHeader style="table 1_CH" height="30" rowSpan="1"><staticText><reportElement x="0" y="0" width="265" height="30" uuid="38121ef4-57ed-45cc-9385-8403d47b9501"/><text><![CDATA[D34TAILR3P0RT_VNAME]]></text></staticText></jr:columnHeader><jr:detailCell style="table 1_TD" height="20" rowSpan="1"><textField isStretchWithOverflow="true"><reportElement positionType="FixRelativeToBottom" stretchType="RelativeToTallestObject" isPrintRepeatedValues="false" x="0" y="0" width="265" height="20" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="true" isPrintWhenDetailOverflows="true" uuid="d8200f48-1e27-4204-b37b-24ac59640e4e"/><textFieldExpression><![CDATA[$F{D34TAILR3P0RT_VNAME}]]></textFieldExpression></textField></jr:detailCell></jr:column><jr:column width="448" uuid="92ba5656-9665-4b5c-90e7-31cd1913be2e"><jr:columnHeader style="table 1_CH" height="30" rowSpan="1"><staticText><reportElement x="0" y="0" width="448" height="30" uuid="212f6a24-cf71-4a99-8360-0ad143a470ad"/><text><![CDATA[D34TAILR3P0RT_VURL]]></text></staticText></jr:columnHeader><jr:detailCell style="table 1_TD" height="20" rowSpan="1"><textField><reportElement x="0" y="0" width="448" height="20" uuid="670d52a8-87d7-4d8d-9f7a-9aef58a6a4df"/><textFieldExpression><![CDATA[$F{D34TAILR3P0RT_VURL}]]></textFieldExpression></textField></jr:detailCell></jr:column></jr:table></componentElement></band></detail></jasperReport>
  2. Hello Guys , this is first time to work on jasper report i dont have any knowledge of it. i got task in my company to design report.I have use cross table where column name is vulnarability and row is related url. but when it fetch from database it print blank row also . I want to print if there is row value.... Please help me out tommorow its last date to submit.... here is my code plase if possible send me the corect code on my id swapnilppawar76@gmail.com code:- <?xml version="1.0" encoding="UTF-8"?><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="Vulnarabilityreport" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="dcbe83f4-31f5-4f7a-a587-09fea1133b7f"><property name="ireport.zoom" value="1.0"/><property name="ireport.x" value="0"/><property name="ireport.y" value="0"/><style name="table"><box><pen lineWidth="1.0" lineColor="#000000"/></box></style><style name="table_TH" mode="Opaque" backcolor="#F0F8FF"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><style name="table_CH" mode="Opaque" backcolor="#BFE1FF"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><style name="table_TD" mode="Opaque" backcolor="#FFFFFF"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><style name="Crosstab Data Text" hAlign="Center"/><subDataset name="New Dataset 1" uuid="c4eb5f4e-52e2-49e9-ac76-8e1e618a028f"><queryString language="SQL"><![CDATA[sELECT D34TAILR3P0RT."VNAME" AS D34TAILR3P0RT_VNAME, D34TAILR3P0RT."VURL" AS D34TAILR3P0RT_VURLFROM "ADMIN"."D34TAILR3P0RT" D34TAILR3P0RT]]></queryString><field name="D34TAILR3P0RT_VNAME" class="java.lang.String"/><field name="D34TAILR3P0RT_VURL" class="java.lang.String"/><group name="D34TAILR3P0RT_VNAME"><groupExpression><![CDATA[$F{D34TAILR3P0RT_VNAME}]]></groupExpression></group></subDataset><parameter name="user_name" class="java.lang.String"/><parameter name="scan_no" class="java.lang.String"/><queryString><![CDATA[select vname,vurl from D34TAILR3P0RT where scan_no=$P{scan_no} and user_name=$P{user_name} ]]></queryString><field name="VNAME" class="java.lang.String"><fieldDescription><![CDATA[]]></fieldDescription></field><field name="VURL" class="java.lang.String"><fieldDescription><![CDATA[]]></fieldDescription></field><background><band splitType="Stretch"/></background><summary><band height="42" splitType="Stretch"><crosstab><reportElement x="0" y="0" width="555" height="42" uuid="0cc1fbec-965f-422e-b9d1-aba70341f3ac"/><crosstabDataset><dataset><datasetRun subDataset="New Dataset 1" uuid="52436639-9a78-431f-a4b5-844fc5cc6510"><connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression></datasetRun></dataset></crosstabDataset><rowGroup name="D34TAILR3P0RT_VNAME_COUNT" width="0"><bucket class="java.lang.Integer"><bucketExpression><![CDATA[$V{D34TAILR3P0RT_VNAME_COUNT}]]></bucketExpression></bucket><crosstabRowHeader><cellContents backcolor="#F0F8FF" mode="Opaque"><box><pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/></box></cellContents></crosstabRowHeader><crosstabTotalRowHeader><cellContents/></crosstabTotalRowHeader></rowGroup><columnGroup name="D34TAILR3P0RT_VNAME" height="30"><bucket class="java.lang.String"><bucketExpression><![CDATA[$F{D34TAILR3P0RT_VNAME}]]></bucketExpression></bucket><crosstabColumnHeader><cellContents backcolor="#F0F8FF" mode="Opaque"><box><pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/></box><textField><reportElement style="Crosstab Data Text" x="0" y="0" width="483" height="30" uuid="aadf66df-edb6-416c-95de-c06dd4634b75"/><textFieldExpression><![CDATA[$V{D34TAILR3P0RT_VNAME}]]></textFieldExpression></textField></cellContents></crosstabColumnHeader><crosstabTotalColumnHeader><cellContents/></crosstabTotalColumnHeader></columnGroup><measure name="D34TAILR3P0RT_VURLMeasure" class="java.lang.String" calculation="First"><measureExpression><![CDATA[$F{D34TAILR3P0RT_VURL}]]></measureExpression></measure><crosstabCell width="483" height="17"><cellContents><box><pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/></box><textField isBlankWhenNull="true"><reportElement style="Crosstab Data Text" x="0" y="0" width="483" height="17" isRemoveLineWhenBlank="true" uuid="6e26e0a1-6562-43d1-82cb-ac12ae0e219b"/><textFieldExpression><![CDATA[$V{D34TAILR3P0RT_VURLMeasure}]]></textFieldExpression></textField></cellContents></crosstabCell><crosstabCell height="25" rowTotalGroup="D34TAILR3P0RT_VNAME_COUNT"><cellContents backcolor="#BFE1FF" mode="Opaque"><box><pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/></box><textField><reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25" uuid="540318c7-273e-4900-a3a3-f2c048ad70dc"/><textFieldExpression><![CDATA[$V{D34TAILR3P0RT_VURLMeasure}]]></textFieldExpression></textField></cellContents></crosstabCell><crosstabCell width="50" columnTotalGroup="D34TAILR3P0RT_VNAME"><cellContents backcolor="#BFE1FF" mode="Opaque"><box><pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/></box><textField><reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25" uuid="e5ccf22d-05bb-402b-9a00-9cf93d5697d2"/><textFieldExpression><![CDATA[$V{D34TAILR3P0RT_VURLMeasure}]]></textFieldExpression></textField></cellContents></crosstabCell><crosstabCell rowTotalGroup="D34TAILR3P0RT_VNAME_COUNT" columnTotalGroup="D34TAILR3P0RT_VNAME"><cellContents backcolor="#BFE1FF" mode="Opaque"><box><pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/></box><textField><reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25" uuid="ea184640-706b-46fa-a07c-b4eb703673e2"/><textFieldExpression><![CDATA[$V{D34TAILR3P0RT_VURLMeasure}]]></textFieldExpression></textField></cellContents></crosstabCell></crosstab></band></summary></jasperReport>
  3. Hello Guys , I am trying to retrive data from database and display in table. but table start from second page first page is complete blank only header part is there. I am tring for all possibilities . I dont want to use ignore pagination.....
  4. here is my code can you solve this and revert to me <?xml version="1.0" encoding="UTF-8"?> <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="Demotable" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="fc8d9908-8849-47e4-96fd-c1052fd63a08"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <style name="table"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Table Dataset 1" uuid="4d04fade-64a1-4418-9c7f-2db1eb1d16a6"> <parameter name="scan_no" class="java.lang.Integer" isForPrompting="false"/> <parameter name="user_name" class="java.lang.String" isForPrompting="false"/> <queryString> <![CDATA[select vname,vurl from D34TAILR3P0RT where scan_no=$P{scan_no} and user_name=$P{user_name}]]> </queryString> <field name="VNAME" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="VURL" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <filterExpression><![CDATA[$F{VNAME}!=null]]></filterExpression> </subDataset> <parameter name="scan_no" class="java.lang.Integer"/> <parameter name="user_name" class="java.lang.String"/> <queryString> <![CDATA[select vname,vurl from D34TAILR3P0RT where scan_no=$P{scan_no} and user_name=$P{user_name}]]> </queryString> <field name="VNAME" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="VURL" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <group name="vcount"> <groupExpression><![CDATA[$F{VNAME}]]></groupExpression> </group> <group name="VNAME"> <groupExpression><![CDATA[$F{VNAME}]]></groupExpression> </group> <group name="check"> <groupExpression><![CDATA[$F{VNAME}.equals( "1" )]]></groupExpression> </group> <group name="kp"> <groupExpression><![CDATA[$F{VNAME}]]></groupExpression> </group> <group name="column1"> <groupExpression><![CDATA[$F{VNAME}]]></groupExpression> </group> <background> <band splitType="Stretch"/> </background> <pageHeader> <band height="35" splitType="Stretch"> <staticText> <reportElement x="234" y="4" width="100" height="20" forecolor="#FF00FF" uuid="a6c8ba50-5010-436b-8f87-fa64ee0354c7"/> <textElement> <font size="14" isBold="true" isItalic="true"/> </textElement> <text><![CDATA[Demo Praject]]></text> </staticText> </band> </pageHeader> <detail> <band height="158"> <printWhenExpression><![CDATA[$V{REPORT_COUNT}==1]]></printWhenExpression> <componentElement> <reportElement key="table 1" style="table 1_TD" positionType="Float" stretchType="RelativeToTallestObject" mode="Transparent" x="120" y="32" width="360" height="89" isPrintWhenDetailOverflows="true" uuid="039391c0-59f6-45a2-80d5-ad3ab29a4f4f"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="Table Dataset 1" uuid="eb9830a3-2df8-4322-b6f0-3ed534c72fea"> <datasetParameter name="scan_no"> <datasetParameterExpression><![CDATA[$P{scan_no}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="user_name"> <datasetParameterExpression><![CDATA[$P{user_name}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="90" uuid="2db11c41-48f7-4a05-b58d-bccf619409b8"> <jr:columnHeader style="table 1_CH" height="60" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="90" height="30" uuid="22b6db66-bafc-4f07-9d05-a95d64091a07"/> <text><![CDATA[VNAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 1_TD" height="40" rowSpan="1"> <textField isStretchWithOverflow="true" pattern=""> <reportElement style="table 1" positionType="Float" stretchType="RelativeToTallestObject" isPrintRepeatedValues="false" x="0" y="0" width="90" height="40" isPrintWhenDetailOverflows="true" forecolor="#CC0000" uuid="0f3e8a62-1446-4c7d-861f-f399c0a80b66"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{VNAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="268" uuid="fac4df48-8d3c-4d64-84f2-869d083edf05"> <jr:columnHeader style="table 1_CH" height="60" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="268" height="30" uuid="f4a1e7a0-3d8a-4c6d-9263-26b79d01c04f"/> <text><![CDATA[VURL]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 1_TD" height="40" rowSpan="1"> <textField> <reportElement positionType="FixRelativeToBottom" stretchType="RelativeToTallestObject" x="0" y="0" width="268" height="20" uuid="8e807bc5-1438-4302-a2be-53e725bd7677"/> <textFieldExpression><![CDATA[$F{VURL}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> </detail> </jasperReport>
  5. please here is my code.. <?xml version="1.0" encoding="UTF-8"?> <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="Demotable" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="fc8d9908-8849-47e4-96fd-c1052fd63a08"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <style name="table"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Table Dataset 1" uuid="4d04fade-64a1-4418-9c7f-2db1eb1d16a6"> <parameter name="scan_no" class="java.lang.Integer" isForPrompting="false"/> <parameter name="user_name" class="java.lang.String" isForPrompting="false"/> <queryString> <![CDATA[select vname,vurl from D34TAILR3P0RT where scan_no=$P{scan_no} and user_name=$P{user_name}]]> </queryString> <field name="VNAME" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="VURL" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <filterExpression><![CDATA[$F{VNAME}!=null]]></filterExpression> </subDataset> <parameter name="scan_no" class="java.lang.Integer"/> <parameter name="user_name" class="java.lang.String"/> <queryString> <![CDATA[select vname,vurl from D34TAILR3P0RT where scan_no=$P{scan_no} and user_name=$P{user_name}]]> </queryString> <field name="VNAME" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="VURL" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <group name="vcount"> <groupExpression><![CDATA[$F{VNAME}]]></groupExpression> </group> <group name="VNAME"> <groupExpression><![CDATA[$F{VNAME}]]></groupExpression> </group> <group name="check"> <groupExpression><![CDATA[$F{VNAME}.equals( "1" )]]></groupExpression> </group> <group name="kp"> <groupExpression><![CDATA[$F{VNAME}]]></groupExpression> </group> <group name="column1"> <groupExpression><![CDATA[$F{VNAME}]]></groupExpression> </group> <background> <band splitType="Stretch"/> </background> <pageHeader> <band height="35" splitType="Stretch"> <staticText> <reportElement x="234" y="4" width="100" height="20" forecolor="#FF00FF" uuid="a6c8ba50-5010-436b-8f87-fa64ee0354c7"/> <textElement> <font size="14" isBold="true" isItalic="true"/> </textElement> <text><![CDATA[Demo Praject]]></text> </staticText> </band> </pageHeader> <detail> <band height="158"> <printWhenExpression><![CDATA[$V{REPORT_COUNT}==1]]></printWhenExpression> <componentElement> <reportElement key="table 1" style="table 1_TD" positionType="Float" stretchType="RelativeToTallestObject" mode="Transparent" x="120" y="32" width="360" height="89" isPrintWhenDetailOverflows="true" uuid="039391c0-59f6-45a2-80d5-ad3ab29a4f4f"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="Table Dataset 1" uuid="eb9830a3-2df8-4322-b6f0-3ed534c72fea"> <datasetParameter name="scan_no"> <datasetParameterExpression><![CDATA[$P{scan_no}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="user_name"> <datasetParameterExpression><![CDATA[$P{user_name}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="90" uuid="2db11c41-48f7-4a05-b58d-bccf619409b8"> <jr:columnHeader style="table 1_CH" height="60" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="90" height="30" uuid="22b6db66-bafc-4f07-9d05-a95d64091a07"/> <text><![CDATA[VNAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 1_TD" height="40" rowSpan="1"> <textField isStretchWithOverflow="true" pattern=""> <reportElement style="table 1" positionType="Float" stretchType="RelativeToTallestObject" isPrintRepeatedValues="false" x="0" y="0" width="90" height="40" isPrintWhenDetailOverflows="true" forecolor="#CC0000" uuid="0f3e8a62-1446-4c7d-861f-f399c0a80b66"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{VNAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="268" uuid="fac4df48-8d3c-4d64-84f2-869d083edf05"> <jr:columnHeader style="table 1_CH" height="60" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="268" height="30" uuid="f4a1e7a0-3d8a-4c6d-9263-26b79d01c04f"/> <text><![CDATA[VURL]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 1_TD" height="40" rowSpan="1"> <textField> <reportElement positionType="FixRelativeToBottom" stretchType="RelativeToTallestObject" x="0" y="0" width="268" height="20" uuid="8e807bc5-1438-4302-a2be-53e725bd7677"/> <textFieldExpression><![CDATA[$F{VURL}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> </detail> </jasperReport>
  6. Hello Guys , I am new in jasper report ,currently i have an task to print the repeated value only once in table . that i did using by checking " Print repeated value" but it show the blank cell . I want to remove it also and print the hole row up to the value gets change. please help me its very urgent...please brief it as i am new in jasper report.
×
×
  • Create New...