andycolman

I hadn't seem the illuminate site. That's quite useful. The YouTube link doesn't seem relevant to Styles though ??

Hi, Is there a decent tutorial on the use of Styles anywhere ? These seem to be a very powerful way of controlling the look and feel of your output but they hardly seem to get mentioned. TIA, Andy

OK, I think the problem is that you are running the chart on the main dataset. From the Jasper Studio User Guide : The Detail band will repeat for every row in the query results .. If you create a subDataset and base the chart on that you should get the result you're after . Right click at the top of the Outline, select 'Create Dataset' then follow the bouncing ball ..

Just go to your Source tab, select all, copy, paste .. I'm sure your English is much better than my Dutch !

Do you want to show us some JRXML ?

Actually, this does work. Drop the quotes around your numbers and make sure the data type of the field is set to 'Integer' .. IF($F{TRANSPORTMODE} == 8,"FreeZone",IF(($F{TRANSPORTMODE} == 7),"CARGO TERMINAL",""))

Hi, I think I have tried this before and had a similar problem. Jasper doesn't seem to cope with nested IF's. I'm just trying to find the report I had the issue in and how I worked around it.

Glad I was able to point you in the right direction. Happy New Year !

Hi 'Winnie'. I thought this would be easy so I gave it a try ! Turns out it's not so obvious. Try this : 1. Create your Text field using the appropriate database items. 2. Then go into the 'Hyperlink' tab in the Properties panel, set 'Link Type' to 'RemotePage' and populate the 'Hyperlink Reference Expression' with the field name - e.g. $F{EBAY} in my example 3. At this point your field will BE a URL but won't LOOK like one .. 4. Go into 'Appearance' and set the colour. 5. Go into 'Text Field' and set underline. There is some JRXML below that may help - you'll obviously need to add your own data adaptor/source Keep trying with Jasper - there is always a way but it often takes some finding. Let me know if this works for you. Happy Christmas ! Andy <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 7.1.0.final using JasperReports Library version 6.4.3 --> <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="WEBSITES" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="92b25204-06b5-4ca7-805c-0c7ec9d3620b"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="SITES"/> <queryString language="XLS"> <![CDATA[]]> </queryString> <field name="AMAZON" class="java.lang.String"/> <field name="EBAY" class="java.lang.String"/> <background> <band splitType="Stretch"/> </background> <detail> <band height="125" splitType="Stretch"> <textField hyperlinkType="RemotePage"> <reportElement x="167" y="36" width="100" height="30" forecolor="#221FED" uuid="f6531fbd-b60e-454b-a542-dd8a531f43ac"/> <textElement> <font isUnderline="true"/> </textElement> <textFieldExpression><![CDATA[$F{AMAZON}]]></textFieldExpression> <hyperlinkReferenceExpression><![CDATA[$F{AMAZON}]]></hyperlinkReferenceExpression> </textField> <staticText> <reportElement x="67" y="36" width="100" height="30" uuid="084face9-54dd-4293-923e-7499b9776cde"/> <text><![CDATA[AMAZON]]></text> </staticText> <textField hyperlinkType="RemotePage"> <reportElement x="167" y="66" width="100" height="30" forecolor="#221FED" uuid="0886b981-1752-4117-a147-51bff4947414"/> <textElement> <font isUnderline="true"/> </textElement> <textFieldExpression><![CDATA[$F{EBAY}]]></textFieldExpression> <hyperlinkReferenceExpression><![CDATA[$F{EBAY}]]></hyperlinkReferenceExpression> </textField> <staticText> <reportElement x="67" y="66" width="100" height="30" uuid="6b00bf6b-5931-4538-905e-5b13c6014883"/> <text><![CDATA[EBAY]]></text> </staticText> </band> </detail> </jasperReport>

@vchiem How would this work 1. using XML/XPath and 2. If the parameter is NOT for Prompting ?

James, I feel your pain. Looking at my crib notes, I always have to right click on the subdata set (i.e. ProductOrders in your case) and click 'Connect to Main dataset'. I don't think that is your exact problem but I do think it's someting to do with the data connection. If you add the 'dataSourceExpression' tag into your 'datasetRun' statement (see below) the table starts to fire (i.e. the headings start to appear). <datasetRun subDataset="ProductOrder" uuid="f5c23ded-3385-4dca-b61a-2fc9c51fa814"> <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.JREmptyDataSource() ]]></dataSourceExpression> </datasetRun> Sorry I can't be more help but hopefully nudging you in the right direction.

Following ..

Michael, I'm no expert and am fairly new to Jasper as well but I think the short answer to this would be no. That said, I did do a screen mock-up a few weeks back where I put some backdrop images into the 'Background' section and then positioned other report elements over the top in the 'Details 1' section. This worked OK for a simple screen but even then lining things up was fiddly. I think for a delivery/contract note you would be better off persevering with creating all the page elements in 'Details 1' and getting easier maintenance in the future. Just my 2c and other may have other views. All best, Andy

Michael, I'm no expert and am fairly new to Jasper as well but I think the short answer to this would be no. That said, I did do a screen mock-up a few weeks back where I put some backdrop images into the 'Background' section and then positioned other report elements over the top in the 'Details 1' section. This worked OK for a simple screen but even then lining things up was fiddly. I think for a delivery/contract note you would be better off persevering with creating all the page elements in 'Details 1' and getting easier maintenance in the future. Just my 2c and other may have other views. All best, Andy

An answer to a post from a few years back (https://community.jaspersoft.com/questions/517154/creating-subdataset-application) gave a steer that you can programatically create subdatasets by making the appropriate entries to the source JRXML. Does anyone have more recent experience of doing this ? Are there guidelines published anywhere ? Please advise .

We are currently integrating JasperReports with our existing reporting application. In the current implementation, data modelling facilities allow us to specify data types for all fields in the data model. Our current design studio is then able to interpret a schema that passes across the various field data types. This avoids repetition of a key part of the design process. Is there away to acheive the same result when using Jasper Studio ? We are using TIBCO Jaspersoft® Studio Professional 7.1.0 - Visual Designer for JasperReports 6.4.31. TIA

Can anyone explain why, sometime, when I create a new dataset from a source XML file, the field names all have '_1' appended to them ? I have a screen shot but can't find out how to attach one at the moment ..

SOURCE XML <?xml version="1.0" encoding="UTF-8"?><Root> <pack name="Alexia Thurgar" packHostCode="86083" performanceEndDate="2005-04-06" performanceStartDate="2005-04-06" shortName="Alexia Thurgar" id="1" > <address id="1" /> <address id="2" /> <portfolio id="1" /> </pack> <address ContactName="Alexia Thurgar" copies="1" country="UK" lineFive="" lineFour="D10 6WI" lineOne="81 Gills Hill" lineThree="Dorset" lineTwo="Sherborne" packHostCode="86083" performanceEndDate="2006-04-05" performanceStartDate="2005-04-06" id="1" /> <address ContactName="Alexia Thurgar" copies="2" country="UK" lineFive="" lineFour="D12 6FE" lineOne="11 House Hill" lineThree="Dorset" lineTwo="Poole" packHostCode="86083" performanceEndDate="2006-04-05" performanceStartDate="2005-04-06" id="2" /> <portfolio composite="0" currencyCode="0" name="Alexia Thurgar" packHostCode="86083" portfolioHostCode="114831" id="1" > <cashTransaction id="1" /> <cashTransaction id="2" /> <cashTransaction id="3" /> <cashTransaction id="4" /> <cashTransaction id="5" /> <cashTransaction id="6" /> <cashTransaction id="7" /> <cashTransaction id="8" /> <cashTransaction id="9" /> <cashTransaction id="10" /> <cashValuation id="1" /> <cashValuation id="2" /> <stockValuation id="1" /> <stockValuation id="2" /> <stockValuation id="3" /> <stockValuation id="4" /> <stockValuation id="5" /> <stockValuation id="6" /> <stockValuation id="7" /> <stockValuation id="8" /> <stockValuation id="9" /> <stockTransaction id="1" /> <stockTransaction id="2" /> <stockTransaction id="3" /> <stockTransaction id="4" /> <stockTransaction id="5" /> <stockTransaction id="6" /> <stockTransaction id="7" /> <stockTransaction id="8" /> <stockTransaction id="9" /> <stockTransaction id="10" /> <stockTransaction id="11" /> <stockTransaction id="12" /> <stockTransaction id="13" /> <stockTransaction id="14" /> <stockTransaction id="15" /> <stockTransaction id="16" /> <stockTransaction id="17" /> <stockTransaction id="18" /> <stockTransaction id="19" /> <stockTransaction id="20" /> <stockTransaction id="21" /> <stockTransaction id="22" /> <stockTransaction id="23" /> <stockTransaction id="24" /> <stockTransaction id="25" /> </portfolio> <cashTransaction SheetNumber="5" assetHostCode="11483110" assetName="GBP Capital" creditAmount="" debitAmount="-44.92" narrativeOne="MANAGEMENT FEE - ISA" narrativeTwo="01 OCT 2005 - 31 DEC 2005" packHostCode="86083" portfolioHostCode="114831" valueDate="2006-01-01" id="1" /> <cashTransaction SheetNumber="5" assetHostCode="11483110" assetName="GBP Capital" creditAmount="" debitAmount="-65.41" narrativeOne="MANAGEMENT FEE" narrativeTwo="01 OCT 2005 - 31 DEC 2005" packHostCode="86083" portfolioHostCode="114831" valueDate="2006-01-01" id="2" /> <cashTransaction SheetNumber="5" assetHostCode="11483110" assetName="GBP Capital" creditAmount="56.8" debitAmount="" narrativeOne="ISA WITHDRAWAL " narrativeTwo="" packHostCode="86083" portfolioHostCode="114831" valueDate="2006-01-01" id="3" /> <cashTransaction SheetNumber="5" assetHostCode="11483110" assetName="GBP Capital" creditAmount="4072.14" debitAmount="" narrativeOne="Settle SALE 200.0000 @ GBP20.69 " narrativeTwo="Bgn 1707315 THAMES RIVER TRADITIONAL FUND Japan Fund Sterling Class NAV" packHostCode="86083" portfolioHostCode="114831" valueDate="2006-03-14" id="4" /> <cashTransaction SheetNumber="5" assetHostCode="11483110" assetName="GBP Capital" creditAmount="" debitAmount="-3557.24" narrativeOne="Settle PURCHASE 3500 @ GBP1.00 " narrativeTwo="Bgn 1727867 MELCHIOR JAPAN INVESTMENT TST 10p Ordinary Shares" packHostCode="86083" portfolioHostCode="114831" valueDate="2006-04-03" id="5" /> <cashTransaction SheetNumber="4" assetHostCode="11483120" assetName="GBP Income" creditAmount="42.03" debitAmount="" narrativeOne="DIVIDEND on 6004 @ GBP.007" narrativeTwo="NEW CITY HIGH YIELD TRUST PLC 25p Ordinary Shares" packHostCode="86083" portfolioHostCode="114831" valueDate="2006-02-24" id="6" /> <cashTransaction SheetNumber="4" assetHostCode="11483120" assetName="GBP Income" creditAmount="10.32" debitAmount="" narrativeOne="DIVIDEND on 1000 @ GBP.010315" narrativeTwo="CAPITA FINANCIAL MGRS CF Midas Balanced Income Inc" packHostCode="86083" portfolioHostCode="114831" valueDate="2006-03-15" id="7" /> <cashTransaction SheetNumber="4" assetHostCode="11483120" assetName="GBP Income" creditAmount="1.14" debitAmount="" narrativeOne="INTEREST (Net)" narrativeTwo="As accrued on account 11483110" packHostCode="86083" portfolioHostCode="114831" valueDate="2006-03-28" id="8" /> <cashTransaction SheetNumber="4" assetHostCode="11483120" assetName="GBP Income" creditAmount="107.43" debitAmount="" narrativeOne="QUARTERLY BALANCE TRANSFER" narrativeTwo="FROM MAXI ISA INCOME ACCOUNT" packHostCode="86083" portfolioHostCode="114831" valueDate="2006-03-29" id="9" /> <cashTransaction SheetNumber="4" assetHostCode="11483120" assetName="GBP Income" creditAmount="" debitAmount="-160.92" narrativeOne="QUARTERLY BALANCE TO Alexia Thurgar" narrativeTwo="AT NATIONAL WESTMINSTER BANK PLC" packHostCode="86083" portfolioHostCode="114831" valueDate="2006-03-29" id="10" /> <cashValuation assetHostCode="11483110" assetName="GBP Capital" dividendYield=".9" grossIncome="4.63" packHostCode="86083" portfolioHostCode="114831" positionAmount="514.9" valuationBookCost="514.9" valuationTotalValue="514.9" id="1" /> <cashValuation assetHostCode="11483120" assetName="GBP Income" dividendYield="0" grossIncome="0" packHostCode="86083" portfolioHostCode="114831" positionAmount="0" valuationBookCost="0" valuationTotalValue="0" id="2" /> <stockValuation assetHostCode="3093234" classification="Equity Investment Trusts" dividendYield=".19" formattedPrice="GBP4.6142 NAV" grossIncome="8.7128" issue="Global Basics Sterling A Inc" issuer="M&G SECURITIES LTD" packHostCode="86083" portfolioHostCode="114831" positionAmount="1000" valuationBookCost="3211.01" valuationTotalValue="4614.2" id="1" /> <stockValuation assetHostCode="3146796" classification="Equity Investment Trusts" dividendYield="4.65" formattedPrice="GBP1.2521 NAV" grossIncome="58.2" issue="CF Midas Balanced Income Inc" issuer="CAPITA FINANCIAL MGRS" packHostCode="86083" portfolioHostCode="114831" positionAmount="1000" valuationBookCost="1136.73" valuationTotalValue="1252.1" id="2" /> <stockValuation assetHostCode="3186253" classification="Equity Investment Trusts" dividendYield="0" formattedPrice="GBP2.01085" grossIncome="0" issue="Emerging European Opps Acc" issuer="JUPITER UNIT TRUST MGRS LTD" packHostCode="86083" portfolioHostCode="114831" positionAmount="2500" valuationBookCost="3052.43" valuationTotalValue="5027.125" id="3" /> <stockValuation assetHostCode="3373260" classification="Real Estate" dividendYield="1.97" formattedPrice="GBP2.08" grossIncome="98.4" issue="10p Ordinary Shares" issuer="MEDICAL PROPERTY INV FUND LTD" packHostCode="86083" portfolioHostCode="114831" positionAmount="2400" valuationBookCost="2999.41" valuationTotalValue="4992" id="4" /> <stockValuation assetHostCode="0506241" classification="Equity Investment Trusts" dividendYield="5.21" formattedPrice="GBP0.5375" grossIncome="168.112" issue="25p Ordinary Shares" issuer="NEW CITY HIGH YIELD TRUST PLC" packHostCode="86083" portfolioHostCode="114831" positionAmount="6004" valuationBookCost="3253.32" valuationTotalValue="3227.15" id="5" /> <stockValuation assetHostCode="0796439" classification="Equity Investment Trusts" dividendYield=".24" formattedPrice="GBP2.4266" grossIncome="10.27944" issue="Far East Emerg Economies Inc" issuer="ABERDEEN UNIT TRUST MGRS LTD" packHostCode="86083" portfolioHostCode="114831" positionAmount="1800" valuationBookCost="2964.01" valuationTotalValue="4367.88" id="6" /> <stockValuation assetHostCode="B049PC9" classification="Oil & Gas Producers" dividendYield=".49" formattedPrice="GBP1.9162 NAV" grossIncome="18.77364" issue="Global Energy Instl Acc" issuer="INVESTEC FUND MANAGERS LTD" packHostCode="86083" portfolioHostCode="114831" positionAmount="2000" valuationBookCost="2973.06" valuationTotalValue="3832.4" id="7" /> <stockValuation assetHostCode="B0YC0C3" classification="Equity Investment Trusts" dividendYield="0" formattedPrice="GBP106.5" grossIncome="0" issue="Commodities Perfect 10 Note" issuer="BARCLAYS" packHostCode="86083" portfolioHostCode="114831" positionAmount="3000" valuationBookCost="3030" valuationTotalValue="3195" id="8" /> <stockValuation assetHostCode="B104VL6" classification="Equity Investment Trusts" dividendYield="0" formattedPrice="GBP1.045" grossIncome="0" issue="10p Ordinary Shares" issuer="MELCHIOR JAPAN INVESTMENT TST" packHostCode="86083" portfolioHostCode="114831" positionAmount="3500" valuationBookCost="3557.24" valuationTotalValue="3657.5" id="9" /> <stockTransaction amount="1000" assetHostCode="3093234" consideration="3180" formattedPrice="GBP3.18" interestAccrued="0" interestNarrative="" issue="Global Basics Sterling A Inc" issuer="M& SECURITIES LTD" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-04-11" transactionType="PURCHASE" id="1" /> <stockTransaction amount="" assetHostCode="3093234" consideration="0" formattedPrice="GBP0.02" interestAccrued="0" interestNarrative="" issue="Global Basics Sterling A Inc" issuer="M&G SECURITIES LTD" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-10-31" transactionType="EQUAL'N" id="2" /> <stockTransaction amount="1000" assetHostCode="3146796" consideration="1110" formattedPrice="GBP1.11" interestAccrued="0" interestNarrative="" issue="CF Midas Balanced Income Inc" issuer="CAPITA FINANCIAL MGRS" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-04-11" transactionType="PURCHASE" id="3" /> <stockTransaction amount="" assetHostCode="3146796" consideration="0" formattedPrice="GBP0.00" interestAccrued="0" interestNarrative="" issue="CF Midas Balanced Income Inc" issuer="CAPITA FINANCIAL MGRS" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-06-16" transactionType="EQUAL'N" id="4" /> <stockTransaction amount="2500" assetHostCode="3186253" consideration="3000" formattedPrice="GBP1.20" interestAccrued="0" interestNarrative="" issue="Emerging European Opps Acc" issuer="JUPITER UNIT TRUST MGRS LTD" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-04-11" transactionType="PURCHASE" id="5" /> <stockTransaction amount="4.47" assetHostCode="3186253" consideration="0" formattedPrice="GBP0.00" interestAccrued="0" interestNarrative="" issue="Emerging European Opps Acc" issuer="JUPITER UNIT TRUST MGRS LTD" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-08-31" transactionType="SCH4 TC92+" id="6" /> <stockTransaction amount="4.47" assetHostCode="3186253" consideration="0" formattedPrice="GBP0.00" interestAccrued="0" interestNarrative="" issue="Emerging European Opps Acc" issuer="JUPITER UNIT TRUST MGRS LTD" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-08-31" transactionType="C-S4 TCGA+" id="7" /> <stockTransaction amount="0" assetHostCode="3186253" consideration="0" formattedPrice="GBP0.00" interestAccrued="0" interestNarrative="" issue="Emerging European Opps Acc" issuer="JUPITER UNIT TRUST MGRS LTD" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-08-31" transactionType="SCH4 TC92+" id="8" /> <stockTransaction amount="200" assetHostCode="3232532" consideration="3114" formattedPrice="GBP15.57" interestAccrued="0" interestNarrative="" issue="Japan Fund Sterling Class NAV" issuer="THAMES RIVER TRADITIONAL FUND" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-04-11" transactionType="PURCHASE" id="9" /> <stockTransaction amount="200" assetHostCode="3232532" consideration="4138" formattedPrice="GBP20.69" interestAccrued="0" interestNarrative="" issue="Japan Fund Sterling Class NAV" issuer="THAMES RIVER TRADITIONAL FUND" packHostCode="86083" portfolioHostCode="114831" tradeDate="2006-03-08" transactionType="SALE" id="10" /> <stockTransaction amount="2400" assetHostCode="3373260" consideration="2952" formattedPrice="GBP1.23" interestAccrued="0" interestNarrative="" issue="10p Ordinary Shares" issuer="MEDICAL PROPERTY INV FUND LTD" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-04-11" transactionType="PURCHASE" id="11" /> <stockTransaction amount="3000" assetHostCode="9912062" consideration="3000" formattedPrice="GBP100.00" interestAccrued="0" interestNarrative="" issue="Commodities Perfect 10 Note" issuer="BARCLAYS" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-12-01" transactionType="PURCHASE" id="12" /> <stockTransaction amount="3000" assetHostCode="9912062" consideration="3030" formattedPrice="GBP101.00" interestAccrued="0" interestNarrative="" issue="Commodities Perfect 10 Note" issuer="BARCLAYS" packHostCode="86083" portfolioHostCode="114831" tradeDate="2006-01-23" transactionType="NM/SEDLCH-" id="13" /> <stockTransaction amount="6004" assetHostCode="0506241" consideration="3253.3202352" formattedPrice="GBP0.54" interestAccrued="0" interestNarrative="" issue="25p Ordinary Shares" issuer="NEW CITY HIGH YIELD TRUST PLC" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-11-04" transactionType="NM/SDOLCH+" id="14" /> <stockTransaction amount="400" assetHostCode="0579403" consideration="2804" formattedPrice="GBP7.01" interestAccrued="0" interestNarrative="" issue="25p Ordinary Shares" issuer="JPMF MERCANTILE INV TRUST PLC" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-04-11" transactionType="PURCHASE" id="15" /> <stockTransaction amount="400" assetHostCode="0579403" consideration="2964" formattedPrice="GBP7.41" interestAccrued="0" interestNarrative="" issue="25p Ordinary Shares" issuer="JPMF MERCANTILE INV TRUST PLC" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-10-06" transactionType="SALE" id="16" /> <stockTransaction amount="1800" assetHostCode="0796439" consideration="2934" formattedPrice="GBP1.63" interestAccrued="0" interestNarrative="" issue="Far East Emerg Economies Inc" issuer="ABERDEEN UNIT TRUST MGRS LTD" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-04-11" transactionType="PURCHASE" id="17" /> <stockTransaction amount="" assetHostCode="0796439" consideration="0" formattedPrice="GBP0.01" interestAccrued="0" interestNarrative="" issue="Far East Emerg Economies Inc" issuer="ABERDEEN UNIT TRUST MGRS LTD" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-08-31" transactionType="EQUAL'N" id="18" /> <stockTransaction amount="3000" assetHostCode="9A0J36A" consideration="3030" formattedPrice="GBP101.00" interestAccrued="0" interestNarrative="" issue="Commodities Perfect 10 Note" issuer="BARCLAYS" packHostCode="86083" portfolioHostCode="114831" tradeDate="2006-01-23" transactionType="NM/SDOLCH+" id="19" /> <stockTransaction amount="3000" assetHostCode="9A0J36A" consideration="3030" formattedPrice="GBP101.00" interestAccrued="0" interestNarrative="" issue="Commodities Perfect 10 Note" issuer="BARCLAYS" packHostCode="86083" portfolioHostCode="114831" tradeDate="2006-02-10" transactionType="NM/SEDLCH-" id="20" /> <stockTransaction amount="2000" assetHostCode="B049PC9" consideration="2920" formattedPrice="GBP1.46" interestAccrued="0" interestNarrative="" issue="Global Energy Instl Acc" issuer="INVESTEC FUND MANAGERS LTD" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-07-06" transactionType="PURCHASE" id="21" /> <stockTransaction amount="6004" assetHostCode="B0F6T16" consideration="3182.12" formattedPrice="GBP0.53" interestAccrued="0" interestNarrative="" issue="25p Ordinary Shares (Regd)" issuer="NEW CITY HIGH YIELD TRUST PLC" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-08-18" transactionType="PURCHASE" id="22" /> <stockTransaction amount="6004" assetHostCode="B0F6T16" consideration="3253.3202352" formattedPrice="GBP0.54" interestAccrued="0" interestNarrative="" issue="25p Ordinary Shares (Regd)" issuer="NEW CITY HIGH YIELD TRUST PLC" packHostCode="86083" portfolioHostCode="114831" tradeDate="2005-11-04" transactionType="NM/SEDLCH-" id="23" /> <stockTransaction amount="3000" assetHostCode="B0YC0C3" consideration="3030" formattedPrice="GBP101.00" interestAccrued="0" interestNarrative="" issue="Commodities Perfect 10 Note" issuer="BARCLAYS" packHostCode="86083" portfolioHostCode="114831" tradeDate="2006-02-10" transactionType="NM/SDOLCH+" id="24" /> <stockTransaction amount="3500" assetHostCode="B104VL6" consideration="3500" formattedPrice="GBP1.00" interestAccrued="0" interestNarrative="" issue="10p Ordinary Shares" issuer="MELCHIOR JAPAN INVESTMENT TST" packHostCode="86083" portfolioHostCode="114831" tradeDate="2006-03-29" transactionType="PURCHASE" id="25" /></Root>[/code]

SUB REPORT <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 7.1.0.final using JasperReports Library version 6.4.3 --><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="Sub_Add" pageWidth="612" pageHeight="792" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="eb04a111-b8aa-4fb1-9cb9-24924d3fef91"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="rSPackInv.XML"/> <queryString language="xPath"><![CDATA[/Root/address]]></queryString> <field name="ContactName_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@ContactName"/> <fieldDescription><![CDATA[@ContactName]]></fieldDescription> </field> <field name="copies_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@copies"/> <fieldDescription><![CDATA[@copies]]></fieldDescription> </field> <field name="country_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@country"/> <fieldDescription><![CDATA[@country]]></fieldDescription> </field> <field name="id_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@id"/> <fieldDescription><![CDATA[@id]]></fieldDescription> </field> <field name="lineFive_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@lineFive"/> <fieldDescription><![CDATA[@lineFive]]></fieldDescription> </field> <field name="lineFour_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@lineFour"/> <fieldDescription><![CDATA[@lineFour]]></fieldDescription> </field> <field name="lineOne_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@lineOne"/> <fieldDescription><![CDATA[@lineOne]]></fieldDescription> </field> <field name="lineThree_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@lineThree"/> <fieldDescription><![CDATA[@lineThree]]></fieldDescription> </field> <field name="lineTwo_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@lineTwo"/> <fieldDescription><![CDATA[@lineTwo]]></fieldDescription> </field> <field name="packHostCode_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@packHostCode"/> <fieldDescription><![CDATA[@packHostCode]]></fieldDescription> </field> <field name="performanceEndDate_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@performanceEndDate"/> <fieldDescription> <![CDATA[@performanceEndDate]]> </fieldDescription> </field> <field name="performanceStartDate_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@performanceStartDate"/> <fieldDescription> <![CDATA[@performanceStartDate]]> </fieldDescription> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="70" splitType="Stretch"> <textField> <reportElement x="234" y="38" width="100" height="30" uuid="21a07d21-b91e-4bbc-aabd-75a6c62f295f"/> <textFieldExpression> <![CDATA[$F{lineFive_1}]]> </textFieldExpression> </textField> <textField> <reportElement x="204" y="5" width="100" height="30" uuid="5b779363-a16a-45ad-978e-29889bf0839c"/> <textFieldExpression> <![CDATA[$F{lineOne_1}]]> </textFieldExpression> </textField> <textField> <reportElement x="110" y="25" width="100" height="30" uuid="011ae574-128c-4b03-b451-310b49a8056f"/> <textFieldExpression> <![CDATA[$F{lineThree_1}]]> </textFieldExpression> </textField> </band> </title></jasperReport>[/code]

MAIN REPORT <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 7.1.0.final using JasperReports Library version 6.4.3 --><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="For Review" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="107" bottomMargin="20" isTitleNewPage="true" isSummaryNewPage="true" isSummaryWithPageHeaderAndFooter="true" uuid="b904ae11-2b9e-42ff-8749-7f5d91bebb3e"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="rSPackInv.XML"/> <property name="com.jaspersoft.studio.unit." value="pixel"/> <property name="com.jaspersoft.studio.unit.topMargin" value="cm"/> <property name="com.jaspersoft.studio.report.description" value=""/> <subDataset name="Cash" uuid="c83c8eab-06c1-4480-9e44-e3665467de0f"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter "/> <parameter name="XML_DATA_DOCUMENT" class="org.w3c.dom.Document" isForPrompting="false"/> <parameter name="XML_INPUT_STREAM" class="java.io.InputStream" isForPrompting="false"/> <parameter name="XML_FILE" class="java.io.File" isForPrompting="false"/> <parameter name="net.sf.jasperreports.xml.source" class="java.lang.String" isForPrompting="false"/> <parameter name="XML_DATE_PATTERN" class="java.lang.String" isForPrompting="false"/> <parameter name="XML_NUMBER_PATTERN" class="java.lang.String" isForPrompting="false"/> <parameter name="XML_LOCALE" class="java.util.Locale" isForPrompting="false"/> <parameter name="XML_TIME_ZONE" class="java.util.TimeZone" isForPrompting="false"/> <queryString language="XPath"> <![CDATA[/Root/cashTransaction]]> </queryString> <field name="SheetNumber_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@SheetNumber"/> <fieldDescription> <![CDATA[@SheetNumber]]> </fieldDescription> </field> <field name="assetHostCode_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@assetHostCode"/> <fieldDescription> <![CDATA[@assetHostCode]]> </fieldDescription> </field> <field name="assetName_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@assetName"/> <fieldDescription><![CDATA[@assetName]]></fieldDescription> </field> <field name="creditAmount_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@creditAmount"/> <fieldDescription><![CDATA[@creditAmount]]></fieldDescription> </field> <field name="debitAmount_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@debitAmount"/> <fieldDescription><![CDATA[@debitAmount]]></fieldDescription> </field> <field name="id_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@id"/> <fieldDescription><![CDATA[@id]]></fieldDescription> </field> <field name="narrativeOne_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@narrativeOne"/> <fieldDescription><![CDATA[@narrativeOne]]></fieldDescription> </field> <field name="narrativeTwo_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@narrativeTwo"/> <fieldDescription><![CDATA[@narrativeTwo]]></fieldDescription> </field> <field name="packHostCode_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@packHostCode"/> <fieldDescription><![CDATA[@packHostCode]]></fieldDescription> </field> <field name="portfolioHostCode_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@portfolioHostCode"/> <fieldDescription><![CDATA[@portfolioHostCode]]></fieldDescription> </field> <field name="valueDate_1" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@valueDate"/> <fieldDescription><![CDATA[@valueDate]]></fieldDescription> </field> </subDataset> <subDataset name="Val with Grouping" uuid="d56c4ae3-6068-439e-8054-5ea7a6dda77c"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="rSPackInv.XML"/> <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="402"/> <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="588"/> <parameter name="XML_DATA_DOCUMENT" class="org.w3c.dom.Document" isForPrompting="false"/> <parameter name="XML_INPUT_STREAM" class="java.io.InputStream" isForPrompting="false"/> <parameter name="XML_FILE" class="java.io.File" isForPrompting="false"/> <parameter name="net.sf.jasperreports.xml.source" class="java.lang.String" isForPrompting="false"/> <parameter name="XML_DATE_PATTERN" class="java.lang.String" isForPrompting="false"/> <parameter name="XML_NUMBER_PATTERN" class="java.lang.String" isForPrompting="false"/> <parameter name="XML_LOCALE" class="java.util.Locale" isForPrompting="false"/> <parameter name="XML_TIME_ZONE" class="java.util.TimeZone" isForPrompting="false"/> <parameter name="Section" class="java.lang.String"> <defaultValueExpression> <![CDATA["Valuation"]]> </defaultValueExpression> </parameter> <queryString language="XPath"> <![CDATA[/Root/stockValuation | /Root/pack/@performanceEndDate]]> </queryString> <field name="performanceEndDate" class="java.sql.Date"> <property name="net.sf.jasperreports.xpath.field.expression" value="."/> <fieldDescription><![CDATA[.]]></fieldDescription> </field> <field name="assetHostCode" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@assetHostCode"/> <fieldDescription><![CDATA[@assetHostCode]]></fieldDescription> </field> <field name="classification" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@classification"/> <fieldDescription><![CDATA[@classification]]></fieldDescription> </field> <field name="dividendYield" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@dividendYield"/> <fieldDescription><![CDATA[@dividendYield]]></fieldDescription> </field> <field name="formattedPrice" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@formattedPrice"/> <fieldDescription><![CDATA[@formattedPrice]]></fieldDescription> </field> <field name="grossIncome" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@grossIncome"/> <fieldDescription><![CDATA[@grossIncome]]></fieldDescription> </field> <field name="id" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@id"/> <fieldDescription><![CDATA[@id]]></fieldDescription> </field> <field name="issue" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@issue"/> <fieldDescription><![CDATA[@issue]]></fieldDescription> </field> <field name="issuer" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@issuer"/> <fieldDescription><![CDATA[@issuer]]></fieldDescription> </field> <field name="packHostCode" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@packHostCode"/> <fieldDescription><![CDATA[@packHostCode]]></fieldDescription> </field> <field name="portfolioHostCode" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@portfolioHostCode"/> <fieldDescription> <![CDATA[@portfolioHostCode]]> </fieldDescription> </field> <field name="positionAmount" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@positionAmount"/> <fieldDescription> <![CDATA[@positionAmount]]> </fieldDescription> </field> <field name="valuationBookCost" class="java.lang.Float"> <property name="net.sf.jasperreports.xpath.field.expression" value="@valuationBookCost"/> <fieldDescription> <![CDATA[@valuationBookCost]]> </fieldDescription> </field> <field name="valuationTotalValue" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@valuationTotalValue"/> <fieldDescription> <![CDATA[@valuationTotalValue]]> </fieldDescription> </field> <sortField name="classification"/> <variable name="valuationBookCost1" class="java.lang.Integer" resetType="Group" resetGroup="classification" calculation="Count"> <variableExpression> <![CDATA[$F{valuationBookCost}]]> </variableExpression> </variable> <variable name="valuationBookCost2" class="java.lang.Float" resetType="Group" resetGroup="classification" calculation="Sum"> <variableExpression> <![CDATA[$F{valuationBookCost}]]> </variableExpression> </variable> <variable name="valuationBookCost3" class="java.lang.Float" resetType="Column" calculation="Sum"> <variableExpression> <![CDATA[$F{valuationBookCost}]]> </variableExpression> </variable> <variable name="valuationBookCost4" class="java.lang.Float" calculation="Sum"> <variableExpression> <![CDATA[$F{valuationBookCost}]]> </variableExpression> </variable> <group name="classification"> <groupExpression> <![CDATA[$F{classification}]]> </groupExpression> </group> </subDataset> <parameter name="XML_DATA_DOCUMENT" class="org.w3c.dom.Document" isForPrompting="false"/> <parameter name="XML_INPUT_STREAM" class="java.io.InputStream" isForPrompting="false"/> <parameter name="XML_FILE" class="java.io.File" isForPrompting="false"/> <parameter name="net.sf.jasperreports.xml.source" class="java.lang.String" isForPrompting="false"/> <parameter name="XML_DATE_PATTERN" class="java.lang.String" isForPrompting="false"/> <parameter name="XML_NUMBER_PATTERN" class="java.lang.String" isForPrompting="false"/> <parameter name="XML_LOCALE" class="java.util.Locale" isForPrompting="false"/> <parameter name="XML_TIME_ZONE" class="java.util.TimeZone" isForPrompting="false"/> <parameter name="Id" class="java.lang.String" isForPrompting="false"> <defaultValueExpression> <![CDATA[$P{Id}]]> </defaultValueExpression> </parameter> <queryString language="xPath"> <![CDATA[/Root/pack]]> </queryString> <field name="id" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@id"/> <fieldDescription><![CDATA[@id]]></fieldDescription> </field> <field name="name" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@name"/> <fieldDescription><![CDATA[@name]]></fieldDescription> </field> <field name="packHostCode" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@packHostCode"/> <fieldDescription> <![CDATA[@packHostCode]]> </fieldDescription> </field> <field name="performanceEndDate" class="java.sql.Date"> <property name="net.sf.jasperreports.xpath.field.expression" value="@performanceEndDate"/> <fieldDescription> <![CDATA[@performanceEndDate]]> </fieldDescription> </field> <field name="performanceStartDate" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@performanceStartDate"/> <fieldDescription> <![CDATA[@performanceStartDate]]> </fieldDescription> </field> <field name="shortName" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="@shortName"/> <fieldDescription><![CDATA[@shortName]]></fieldDescription> </field> <title> <band height="333" splitType="Stretch"> <textField> <reportElement mode="Opaque" x="20" y="-100" width="525" height="70" forecolor="#000000" uuid="61f034cb-74c5-4780-93c7-24c04c08b613"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement markup="html"> <font fontName="Franklin Gothic Heavy" size="12"/> </textElement> <textFieldExpression> <![CDATA["<br><br>" + $F{name} + "<br><br>" + "Your client reference : " + $F{packHostCode} + "<br><br>"]]> </textFieldExpression> </textField> <textField> <reportElement x="20" y="50" width="524" height="270" uuid="18923759-dff7-4ab6-806b-818f03c1c5d5"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement markup="html"/> <textFieldExpression> <![CDATA["<br><br>I am delighted to enclose your latest quarterly report, for the quarter ending " + "<b>" + DATEFORMAT( $F{performanceEndDate},"d MMMM yyyy") + "</b>" + "<br><br>What you are about to read is the first edition of our new style periodic reporting pack - we have made many improvements and hope that you find it informative and detailed as well as being easy to read of course. Naturally we welcome any feedback you may have and we sincerely hope you find your new report easier to read and well laid out" + "<br><br> Our new reporting packs are yet another example of 'Company Limited' continuing to deliver superior service and value to all of our customers both in the UK and overseas. We invest heavily in improving our services to you - we know that these days, the personal touch is hugely important." + "<br><br>At 'Company', each customer has his own personal private banker and adviser, and to further improve this service, over the last year we have appointed many additional senior private banking advisers to the majority of our branches. Please note that as we must continue to comply with FSA legislation specifically Know Your Client and Anti-Money Laundering, the report contains a summary of personal information that we hold on you." + "<br><br>Please take the time to read this information carefully and inform us if you should find anything incorrect." + "<br><br>If you do have any further queries, please do not hesitate to contact me."]]> </textFieldExpression> </textField> <subreport> <reportElement x="20" y="-30" width="510" height="80" uuid="d5061e37-81b2-49bb-a92a-ea3e64e0fb81"/> <connectionExpression> <![CDATA[$P{REPORT_CONNECTION}]]> </connectionExpression> <subreportExpression> <![CDATA["Sub_Add.jasper"]]> </subreportExpression> </subreport> </band> </title> <detail> <band height="100"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> </band> <band height="228" splitType="Stretch"/> </detail> <noData> <band height="50"> <staticText> <reportElement x="0" y="0" width="100" height="30" uuid="07c69c8c-4233-4520-bfe8-02ec30691198"/> <textElement> <font size="18"/> </textElement> <text><![CDATA[No data]]></text> </staticText> </band> </noData></jasperReport>[/code]

Hi, This is driving me loopy !! I have a simple main report in which I want to include a subreport. I have followed the Wizard and create a data set etc etc and the subreport previews perfectly when in the subreport itself. From the main report though I cannot get the subreport contents to appear . Please help !

Thanks for the reply. I've been working with the tutorials for some time. The text box approach seems a bit clunky so I was wondering if there was a slicker way to do things. Regards

Hi there, I am working an a requirement to generate a letter style report using Jasper Studio. So for example : Dear all, Please note that a [Field : CLAIM_TYPE] form for Plan number [Field : PLAN_NUMBER] has been received and has been referred to Compliance for review. Please contact [Field : AGENT] if you have any questions. What is the best approach to take to this ? I started with a Text field but that gets messy/complex quite quickly. Please advise. Thanks

@hozawa Thanks for your reply. You mention JasperReports Server. We are calling the Jasper report engine from our own reporting application so I presume we don't need to use JasperReports server ?

@reportdev Thanks I'll take a look at the thread. All best, Andy