Freezing Pivot grid headers on Pivot client

[Brett Macpherson]

Hi,

     we've implemented the Pivot Client control into our product and appears to work fine. Reading the documentation (https://help.syncfusion.com/aspnet/pivotclient/olap-client-elements) it says once your configure your data with axis element builder it will then render the grid/chart with the pivot grid and pivot chart controls. The pivot grid control allows you to freeze the row/collumn headers in place when scrolling. I'm trying to get this affect with the pivot client but cannot seem to be able to do it. The pivot grid documentation (https://help.syncfusion.com/aspnet/pivotgrid/frozenheader) i've been following doesn't seem to work in the PivotClient. how can i achieve this affect with the PivotClient?

Regards,

Brett

[Manikandan Murugesan]

Hi Breet, 

You can enable “Frozen Headers” in the pivot grid by using the “renderSuccess” event. Please refer the following code snippet. 

Code Snippet: 

<ej:PivotClient ID="PivotClient1" runat="server" Locale="en-US" Url="../api/OlapClient" Title="OLAP Browser" ClientIDMode="Static" OnServerExporting="PivotClient1_ServerExporting"> 

        <ClientSideEvents  RenderSuccess="setChartProperties" /> 

    </ej:PivotClient> 

    <script type="text/javascript"> 

        function setChartProperties(args) { 

            this._pivotGrid.model.frozenHeaderSettings.enableFrozenHeaders = true; 

        } 

   </script> 

Meanwhile, we have prepared sample for your reference. 

Sample: https://www.syncfusion.com/downloads/support/forum/164440/ze/PivotClientWebForms1617008616 

Please let us know if you need further assistance on this. 

Thanks, 

Manikandan. 

[Brett Macpherson]

thanks Manikandan, appears to do the trick

[Manikandan Murugesan]

Hi Breet, 

 

Please let us know if you have any other queries. We are always happy to assist you. 

 

Thanks, 

Manikandan.