</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle"></div> <div id="PageTitle"><div id="PageTitleText">Configuring an OLAP Data Source</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="WelcmPg.html">Welcome to LightSwitch Desktop Edition</a> > <a href="ComponentOneOLAPforLightSwitchOverview.html">OLAP for LightSwitch Overview</a> > <a href="ProgrammingOLAPforLightSwitch.html">Programming OLAP for LightSwitch</a> > <a href="BuildingaCustomUserInterface.html">Building a Custom User Interface</a> > Configuring an OLAP Data Source</td></tr></table></div> <div id="BodyContent"> <p>When configuring a LightSwitch collection view, paging is turned off by default. Select the data source (Invoices) in the Properties window and clear the check boxes for sorting, and search, but keep the box named Auto Execute Query checked.</p> <p><img border="0" alt="" src="images/LightSwitch_OLAPDataSource.png"></p> <p>Please note that if you have a have a large data set, you should enable paging.</p> <p>To turn it on, select the Support paging check box and enter 1000 in the No. of items to display per page field. Experiment with this value to get the best results for your data set.</p> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a href="http://our.componentone.com/groups/" target="_blank">Product Support Forum</a> | <a href="http://feedback.componentone.com/forums/255782-winforms-documentation" target="_blank">Documentation Feedback</a> </div> </body> </html>