</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div style="display: none"> <input type="hidden" id="userDataCache" class="userDataStyle" name="userDataCache"> <input type="hidden" id="hiddenScrollOffset" name="hiddenScrollOffset"> </div> <img id="collapseImage" style="display:none; height:0; width:0;" src="images/collapse.gif"> <img id="expandImage" style="display:none; height:0; width:0;" src="images/expand.gif"> <img id="copyImage" style="display:none; height:0; width:0;" src="images/copycode.gif"> <img id="copyHoverImage" style="display:none; height:0; width:0;" src="images/copycodeHighlight.gif"> <img id="dropDownImage" style="display:none; height:0; width:0;" src="images/drpdown.gif"> <img id="dropDownHoverImage" style="display:none; height:0; width:0;" src="images/drpdown_orange.gif"> <div id="pagetop"> <table width="100%" id="pagetoptable1"> <tr id="pagetoptable1row1"> <td align="left"> <span id="projecttitle"> ActiveReports for .NET 3 Online Help </span> </td> <td align="right"> <span id="feedbacklink"> <a href="http://www.datadynamics.com/Support/SupportRequest.aspx">Request technical support</a> </span> </td> </tr> <tr id="pagetoptable1row2"> <td align="left" colspan="2"> <span id="pagetitle"> Walkthrough: Master Detail Reports with XML Data </span> </td> </tr> <tr id="pagetoptable1row3"><td colspan="2"><a href="#seealsobookmark">See Also</a></td></tr> </table> <table width="100%" id="pagetopbreadcrumbs" cellspacing="0" cellpadding="0"><tr><td> <a href="ar3oriActiveReportsfor.NETUserGuide.html">User Guide</a> > <a href="ar3oriSamplesandWalkthroughs.html">Samples and Walkthroughs</a> > <a href="ar3oriWalkthroughs.html">Walkthroughs</a> > <a href="ar3oriStandardEditionWalkthroughs.html">Standard Edition Walkthroughs</a> > <a href="ar3wlkBasic.html">Basic</a> > <a href="ar3oriMasterDetailReportsWalkthroughs.html">Master Detail Reports Walkthroughs</a> > Walkthrough: Master Detail Reports with XML Data</td></tr></table> </div> <div class="hspopupbubble" id="hsglossaryitembox"> <p>Glossary Item Box</p> </div> <div id="pagebody"> <div id="mainbody"> <xml> <mshelp:keyword index="K" term="Walkthroughs, Master Detail Reports and XML"></mshelp:keyword> <mshelp:keyword index="K" term="Master Detail Reports, XML"></mshelp:keyword> </xml> <p>ActiveReports allows you to create Master Detail reports with data from an XML database. </p> <p>This walkthrough illustrates how to create a Master Detail report using XML data and grouping. </p> <p>This walkthrough is split up into the following activities: </p> <ul type="disc"> <li>Adding an ActiveReport to a Visual Studio project <li>Connecting the report to a XML data source <li>Adding controls to the report to contain data <li>Viewing the report </li></li></li></li></ul> <p>To complete the walkthrough, you must have access to the XML Customer database (customer.xml).</p> <p>When you have completed this walkthrough, you will have a report that looks similar to the following.</p> <p><img src="Images/ar3wlkMasterDetailXmlIMG1.gif"></p> <h2 class="dth2">Adding an ActiveReport to a Visual Studio project</h2> <p class="labelproc"><b>To add an ActiveReport to your project</b></p> <ol type="1"> <li>Open a new project in Visual Studio. <li>From the <b>Project</b> menu, select <b>Add New Item</b>. <li>Select <b>ActiveReports 3.0 File</b> and rename the file rptMD. <li>Click <b>Open</b>. </li></li></li></li></ol> <h2 class="dth2">Connecting the report to a XML data source</h2> <p class="labelproc"><b>To connect the report to a data source</b></p> <p> <ol type="1"> <li>Click the gray report DataSource icon in the Detail section to open the report DataSource dialog. <li>Select the "XML"<em> </em>tab. <li>Click the ellipsis button beside <i>File URL</i> to browse for the access path to customer.xml. (Typically C:\Program Files\Data Dynamics\ActiveReports for .NET 3.0\Samples\CSharp\XMLSample\customer.xml or C:\Program Files\Data Dynamics\ActiveReports for .NET 3.0\Samples\VB\XMLSample\customer.xml.) <li>Click <b>Open</b>. <li>In the Recordset Pattern field, type "//ITEM". <li>Click <b>OK</b> to return to the report design surface. </li></li></li></li></li></li></ol> <h2 class="dth2">Adding controls to the report to contain data</h2> <p class="labelproc"><b>To add controls to the report</b> </p> <ol type="1"> <li>Add two GroupHeader/Footer sections to your report by right-clicking on the report and selecting <strong>Insert > Group Header/Footer</strong>. <li>Make the following changes to the group header just below the page header: <ul> <li>Change the <strong>Name</strong> property to <strong>ghCustomer </strong> <li>Change the <strong>BackColor</strong> property to <strong>LightBlue</strong> <li>Change the <strong>DataField</strong> property to <strong>../../@id</strong> </li></li></li></ul> <li>Add the following controls to ghCustomer: <table class="dttable"> <tbody> <tr valign="top"> <th>Control</th> <th>DataField</th> <th>Name</th> <th>Text</th> <th>Location</th> <th>Font Style</th></tr> <tr valign="top"> <td><b>Label</b> </td> <td></td> <td><b>lblID</b> </td> <td>ID </td> <td>0, 0 </td> <td>Bold</td></tr> <tr valign="top"> <td><b>Label</b> </td> <td></td> <td><b>lblEmailAddress</b> </td> <td>E-mail Address </td> <td>2, 0 </td> <td>Bold</td></tr> <tr valign="top"> <td><b>Label</b> </td> <td></td> <td><b>lblName</b> </td> <td>Name </td> <td>4, 0 </td> <td>Bold</td></tr> <tr> <td><b>TextBox</b> </td> <td>../../@id </td> <td><b>txtID</b> </td> <td>ID </td> <td>0, 0.25 </td> <td></td></tr> <tr> <td><b>TextBox</b> </td> <td>../../@email </td> <td><b>txtEmail</b> </td> <td>E-mail </td> <td>2, 0.25 </td> <td></td></tr> <tr> <td><b>TextBox</b> </td> <td>../../NAME </td> <td><b>txtName</b> </td> <td>Name </td> <td>4, 0.25 </td> <td></td></tr></tbody></table> <li>Make the following changes to the group header just above the detail section: <ul> <li>Change the <strong>Name</strong> property to <strong>ghOrders</strong> <li>Change the <strong>BackColor</strong> property to <strong>LightCyan</strong> <li>Change the <strong>DataField</strong> property to <strong>../Number</strong> <li>Add the following controls to ghOrders:</li></li></li></li></ul> <table class="dttable"> <tbody> <tr valign="top"> <th>Control</th> <th>DataField</th> <th>Name</th> <th>Text</th> <th>Location</th></tr> <tr> <td><strong>Label</strong> </td> <td></td> <td><strong>lblNumber</strong></td> <td>Order Number:</td> <td>0.38, 0</td></tr> <tr> <td><strong>TextBox</strong> </td> <td>../NUMBER </td> <td><strong>txtNumber</strong> </td> <td>Number </td> <td>1.5, 0 </td></tr> <tr> <td><b>TextBox </b></td> <td>../DATE </td> <td><b>txtDate</b> </td> <td>Date </td> <td>4.5, 0 </td></tr> <tr> <td><b>Label</b> </td> <td></td> <td><b>lblISBN</b> </td> <td>ISBN </td> <td>0, 0.31</td></tr> <tr> <td><b>Label </b></td> <td></td> <td><b>lblBookTitle</b> </td> <td>Book Title </td> <td>1.13, 0.31 </td></tr> <tr> <td><b>Label</b> </td> <td></td> <td><b>lblPrice</b> </td> <td>Price </td> <td>5.69, 0.31 </td></tr> <tr> <td><b>Label</b> </td> <td></td> <td><b>lblAuthor</b> </td> <td>Author </td> <td>3.5, 0.31 </td></tr> <tr> <td><b>Label</b> </td> <td></td> <td><b>lblPublisher</b> </td> <td>Publisher </td> <td>4.56, 0.31 </td></tr></tbody></table> <ul></ul> <li>Make the following changes to the <a class="hsglossaryreference" title="Click to show a definition of this term" onclick="javascript:hsShowGlossaryItemBox('Detail section','The body of the report that prints once for each record in the data source. A report\'s layout can only contain one Detail section. ',event)">Detail section</a>: <ul> <li>Change the <b>BackColor</b> property to <b>WhiteSmoke</b> <li>Change the <b>CanShrink</b> property to <b>True</b> <li>Add the controls to the Detail section:</li></li></li></ul> <table class="dttable"> <tbody> <tr valign="top"> <th>Control</th> <th>DataField</th> <th>Name</th> <th>Text</th> <th>Miscellaneous</th> <th>Location</th></tr> <tr> <td><b>TextBox</b> </td> <td>@isbn </td> <td><b>txtISBN</b> </td> <td>ISBN </td> <td></td> <td>0, 0</td></tr> <tr> <td><b>TextBox</b> </td> <td>TITLE </td> <td><b>txtTitle</b> </td> <td>Title </td> <td></td> <td>1.13, 0</td></tr> <tr> <td><b>TextBox</b> </td> <td>AUTHOR </td> <td><b>txtAuthor</b> </td> <td>Author </td> <td></td> <td>3.5, 0</td></tr> <tr> <td><b>TextBox</b> </td> <td>PUBLISHER </td> <td><b>txtPublisher</b> </td> <td>Publisher </td> <td></td> <td>4.56, 0</td></tr> <tr> <td><b>TextBox</b> </td> <td>PRICE </td> <td><b>txtPrice</b> </td> <td>Price </td> <td>OutputFormat = Currency </td> <td>5.69, 0</td></tr></tbody></table> <li>Add the following controls to GroupFooter2: <p> <table class="dttable"> <tbody> <tr valign="top"> <th>Control</th> <th>DataField</th> <th>Name</th> <th>Text</th> <th>Miscellaneous</th> <th>Location</th></tr> <tr> <td><b>Label</b></td> <td></td> <td><b>lblSubtotal</b></td> <td>Subtotal</td> <td>Font Style = Bold</td> <td>4.5, 0</td></tr> <tr valign="top"> <td><b>TextBox</b></td> <td>PRICE</td> <td><b>txtSubtotal</b></td> <td>Subtotal</td> <td>OutputFormat = Currency <p><a class="hsglossaryreference" title="Click to show a definition of this term" onclick="javascript:hsShowGlossaryItemBox('SummaryType','The SummaryType determines the type of summary to be performed. There are four enumerations: SubTotal (group level; reset for each group), GrandTotal (report level; do not reset until all records are processed), PageTotal (page level; reset for each page), and PageCount (total number of pages printed).',event)">SummaryType</a> = SubTotal</p> <p><a class="hsglossaryreference" title="Click to show a definition of this term" onclick="javascript:hsShowGlossaryItemBox('SummaryGroup','SummaryGroup gets or sets the name of the group header section that is used to reset the summary value when calculating subtotals.',event)">SummaryGroup</a> = ghOrders</p></td> <td>5.69, 0</td></tr></tbody></table> <ul></ul></li></li></li></li></li></li></ol> <h2 class="dth2">Viewing the report</h2> <p class="labelproc"><b>To view the report</b></p> <ol type="1"> <li>Add the ActiveReports viewer control to a Windows Form. <li>Add the code needed to set the viewer document equal to the report document. See <a style="auto-update-caption: true" href="ar3tskUsingtheActiveReportsWinFormViewer.html">Using the ActiveReports Windows Form Viewer</a> for help. </li></li></ol> <div style="WIDTH: 100%"> <table class="hs-box"> <tbody> <tr> <td class="hs-box-icon" valign="top"><img src="images/hs-tip.gif"></td> <td class="hs-box-content" valign="top">You can quickly view your report at design time by clicking the <b>Preview</b> tab at the bottom of the designer.</td></tr></tbody></table></div> <a name="seealsobookmark"></a> <h1 class="heading"><span class="expandcollapse" tabindex="0"><img id="seealsoToggle" class="toggle" name="toggleSwitch" src="images/collapse.gif">See Also</span></h1><div id="seealsoSection" class="section" name="collapseableSection"><a href="ar3oriSamples.html">Samples</a><br><a href="ar3oriWalkthroughs.html">Walkthroughs</a><br><a href="ar3conOutputFormatStrings.html">OutputFormat Strings</a><br><a href="ar3tskAddingActiveReportsControlstotheVisualStudioToolbox.html">Adding ActiveReports Controls to the Visual Studio Toolbox</a><p></div> </div> <div id="pagefooter"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright © 2004-2007 Data Dynamics, Ltd. All rights reserved.</p> </div> </div> <div id="nonscrollingpagefooter">©2009. All Rights Reserved.</div> </body> </html>