<html> <head> <META http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Data Preparation</title> <link rel="stylesheet" type="text/css" href="../../../../style.css"> </head> <body> <div class="CommonContent"> <div class="CommonContentArea"> <h1>Data Preparation</h1><script> //We attach this function to a browser object as a variable so that if multiple of these blocks are //present on the same page, then they will simply over-write eachother with the same function instead //of generating a naming collision. window.WikiCodeFormattingCopyToClipboard = function copyToClipboard(sID){ var sContent = document.getElementById(sID).innerText; if( window.clipboardData && clipboardData.setData ) { clipboardData.setData("Text", sContent); } else { alert("You must enable javascript access to your clipboard for this feature to work. Please referr to your browser documentation or Google search for instructions."); } } </script><p>First of all we will need to prepare some data for the report. Let's use a simple Pilot class:</p> <div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">Pilot.java</span></div><div class="fscCode"><pre ID="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44"><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="color: #008080;">01</span><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_19_249_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_19_249_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_19_249_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_19_249_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_19_249_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_19_249_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_19_249_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_19_249_Open_Text').style.display='inline';"/><span style="color: #0000FF;">public</span><span style="color: #000000;"> </span><span style="color: #0000FF;">class</span><span style="color: #000000;"> Pilot </span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_19_249_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_19_249_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">02</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">private</span><span style="color: #000000;"> String name; </span><span style="color: #008080;">03</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">private</span><span style="color: #000000;"> </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> points; </span><span style="color: #008080;">04</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #008080;">05</span><span style="color: #000000;"><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_104_152_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_104_152_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_104_152_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_104_152_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_104_152_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_104_152_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_104_152_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_104_152_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">public</span><span style="color: #000000;"> Pilot(String name, </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> points)</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_104_152_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_104_152_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">06</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">this</span><span style="color: #000000;">.name </span><span style="color: #000000;">=</span><span style="color: #000000;"> name; </span><span style="color: #008080;">07</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">this</span><span style="color: #000000;">.points </span><span style="color: #000000;">=</span><span style="color: #000000;"> points; </span><span style="color: #008080;">08</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">09</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #008080;">10</span><span style="color: #000000;"><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_179_198_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_179_198_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_179_198_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_179_198_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_179_198_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_179_198_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_179_198_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_179_198_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">public</span><span style="color: #000000;"> String getName()</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_179_198_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_179_198_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">11</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> name; </span><span style="color: #008080;">12</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">13</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #008080;">14</span><span style="color: #000000;"><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_224_245_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_224_245_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_224_245_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_224_245_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_224_245_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_224_245_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_224_245_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_224_245_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">public</span><span style="color: #000000;"> </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> getPoints()</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_224_245_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcPilot.Java_SrcPilot.Java_106_44_224_245_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">15</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> points; </span><span style="color: #008080;">16</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">17</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #008080;">18</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/>}</span></span></div></pre></div></div> <p>The following method should be called to fill up the database with some sample data:</p> <div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">Db4oModule.java: <span class="fscMemberName">storeData</span></span></div><div class="fscCode"><pre ID="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59"><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="color: #008080;">01</span><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_24_383_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_24_383_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_24_383_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_24_383_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_24_383_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_24_383_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_24_383_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_24_383_Open_Text').style.display='inline';"/><span style="color: #0000FF;">public</span><span style="color: #000000;"> </span><span style="color: #0000FF;">void</span><span style="color: #000000;"> storeData() </span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_24_383_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_24_383_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">02</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> File(DB_FILE).delete(); </span><span style="color: #008080;">03</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> ObjectContainer container </span><span style="color: #000000;">=</span><span style="color: #000000;"> Db4o.openFile(DB_FILE); </span><span style="color: #008080;">04</span><span style="color: #000000;"><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_116_344_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_116_344_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_116_344_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_116_344_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_116_344_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_116_344_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_116_344_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_116_344_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">try</span><span style="color: #000000;"> </span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_116_344_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_116_344_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">05</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> Pilot pilot </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> Pilot(</span><span style="color: #000000;">"</span><span style="color: #000000;">Michael Schumacher</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #000000;">100</span><span style="color: #000000;">); </span><span style="color: #008080;">06</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> container.set(pilot); </span><span style="color: #008080;">07</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> pilot </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> Pilot(</span><span style="color: #000000;">"</span><span style="color: #000000;">Rubens Barrichello</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #000000;">99</span><span style="color: #000000;">); </span><span style="color: #008080;">08</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> container.set(pilot); </span><span style="color: #008080;">09</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> pilot </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> Pilot(</span><span style="color: #000000;">"</span><span style="color: #000000;">Kimi Raikonnen</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #000000;">100</span><span style="color: #000000;">); </span><span style="color: #008080;">10</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> container.set(pilot); </span><span style="color: #008080;">11</span><span style="color: #000000;"><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_353_380_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_353_380_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_353_380_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_353_380_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_353_380_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_353_380_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_353_380_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_353_380_Open_Text').style.display='inline';"/> }</span></span><span style="color: #000000;"> </span><span style="color: #0000FF;">finally</span><span style="color: #000000;"> </span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_353_380_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_StoreData_250_59_353_380_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">12</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> container.close(); </span><span style="color: #008080;">13</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">14</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div> <p>For the table representation we will need a list of values:</p> <div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">Db4oModule.java: <span class="fscMemberName">readData</span></span></div><div class="fscCode"><pre ID="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51"><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="color: #008080;">01</span><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_23_406_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_23_406_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_23_406_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_23_406_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_23_406_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_23_406_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_23_406_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_23_406_Open_Text').style.display='inline';"/><span style="color: #0000FF;">public</span><span style="color: #000000;"> List readData() </span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_23_406_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_23_406_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">02</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> ObjectContainer container </span><span style="color: #000000;">=</span><span style="color: #000000;"> Db4o.openFile(DB_FILE); </span><span style="color: #008080;">03</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> List result </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> ArrayList(); </span><span style="color: #008080;">04</span><span style="color: #000000;"><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_118_348_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_118_348_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_118_348_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_118_348_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_118_348_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_118_348_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_118_348_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_118_348_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">try</span><span style="color: #000000;"> </span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_118_348_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_118_348_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">05</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> ObjectSet pilots </span><span style="color: #000000;">=</span><span style="color: #000000;"> container.query(Pilot.</span><span style="color: #0000FF;">class</span><span style="color: #000000;">); </span><span style="color: #008080;">06</span><span style="color: #000000;"><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_200_344_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_200_344_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_200_344_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_200_344_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_200_344_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_200_344_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_200_344_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_200_344_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">while</span><span style="color: #000000;"> (pilots.hasNext()) </span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_200_344_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_200_344_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">07</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> Pilot pilot </span><span style="color: #000000;">=</span><span style="color: #000000;"> (Pilot) pilots.next(); </span><span style="color: #008080;">08</span><span style="color: #000000;"><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_271_337_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_271_337_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_271_337_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_271_337_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_271_337_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_271_337_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_271_337_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_271_337_Open_Text').style.display='inline';"/> result.add(</span><span style="color: #0000FF;">new</span><span style="color: #000000;"> String[] </span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_271_337_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_271_337_Open_Text"><span style="color: #000000;">{ pilot.getName(), </span><span style="color: #008080;">09</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> String.format(</span><span style="color: #000000;">"</span><span style="color: #000000;">%3d</span><span style="color: #000000;">"</span><span style="color: #000000;">, pilot.getPoints()) }</span></span><span style="color: #000000;">); </span><span style="color: #008080;">10</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">11</span><span style="color: #000000;"><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_357_384_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_357_384_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_357_384_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_357_384_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_357_384_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_357_384_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_357_384_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_357_384_Open_Text').style.display='inline';"/> }</span></span><span style="color: #000000;"> </span><span style="color: #0000FF;">finally</span><span style="color: #000000;"> </span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_357_384_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceImplementation_StrategiesReportingReporting_With_BIRTReportsBIRT.ZipssrcDb4oModule.Java_SrcDb4oModule.Java_ReadData_383_51_357_384_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">12</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> container.close(); </span><span style="color: #008080;">13</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">14</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> (result); </span><span style="color: #008080;">15</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div> </div> </div> <div id="footer"> This revision (1) was last Modified 2007-02-16T18:33:16 by Tetyana. </div> </body> </html>