andycolman Posted October 25, 2018 Share Posted October 25, 2018 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 ! Link to comment Share on other sites More sharing options...
dev637 Posted October 25, 2018 Share Posted October 25, 2018 Hi, I also spent several hours reading article on the internet and tried many methods. Finally, I found the solution that works for me, detail below.1. In sub report, do NOT put data on DETAIL BAND. You can use other bands e.g. title, summary.2. In the sub report, put the whenNoDataType="AllSectionsNoDetail" within the tag <jasperReport>. This tag can be found at very top of the xml source file.You may try to create a simple main report and link to sub report having static text only first. Just to see if the sub report is showing data correctly.In addition, the latest version of Jaspersoft Studio (6.6.0 now) is buggy. If some non-sense error found (e.g. duplicate parameter name error, file saving error), it's recommended to quit the Jaspersoft Studio and re-open it again. Hope this helps.Credit : https://stackoverflow.com/questions/13287302/jasperreport-ireport-subreport-shows-blank-not-displayed Link to comment Share on other sites More sharing options...
andycolman Posted October 25, 2018 Author Share Posted October 25, 2018 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] Link to comment Share on other sites More sharing options...
andycolman Posted October 25, 2018 Author Share Posted October 25, 2018 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] Link to comment Share on other sites More sharing options...
andycolman Posted October 25, 2018 Author Share Posted October 25, 2018 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] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now