ReportViewer- Devexpress, when exporting to XLS the totals are lost

0

<%@ Register assembly="DevExpress.XtraReports.v17.1.Web, Version=17.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.XtraReports.Web" tagprefix="dx" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
    <script type="text/javascript">
    // <![CDATA[

        function ValidarKey(e) {
            var theEvent = e.htmlEvent || window.event;
            var key = theEvent.keyCode || theEvent.which;

            if (key != 8 && key != 9) {
                key = String.fromCharCode(key);
                var regex = /[0-9]|\./;

                if (!regex.test(key)) {
                    theEvent.returnValue = false;
                    if (theEvent.preventDefault)
                        theEvent.preventDefault();
                }
            }
        }
                
    // ]]> 
    </script>
    <asp:ObjectDataSource ID="obsDepartamento" runat="server" 
        OldValuesParameterFormatString="original_{0}" SelectMethod="TraerDepartamentos" 
        TypeName="Servicios.ProcesosMaestros">
    </asp:ObjectDataSource>
    <table>
        <tr>
            <td style="vertical-align:top">
                <dx:ASPxRoundPanel ID="ASPxRoundPanel1" HeaderText="Filtros" runat="server" Theme="BlackGlass"
                    Width="200px">
                    <PanelCollection>
                        <dx:PanelContent>
                            <dx:ASPxLabel ID="lblAnio" runat="server" Text="Año:"></dx:ASPxLabel>
                            <dx:ASPxTextBox ID="txbAnio" runat="server" ClientInstanceName="txbAnio" Width="100%">
                                <MaskSettings Mask="9999" PromptChar="Y" />
                            </dx:ASPxTextBox>
                            <dx:ASPxLabel ID="LblDepartamento" runat="server" Text="Departamento:">
                            </dx:ASPxLabel>
                            <dx:ASPxComboBox ID="cboDepartamento" runat="server" DataSourceID="obsDepartamento"
                                TextField="NombreDepartamento" IncrementalFilteringMode="StartsWith" DropDownStyle="DropDown"
                                ClientInstanceName="cboDepartamento" Theme="BlackGlass" ValueField="IdDepartamento"
                                EnableSynchronization="False">
                            </dx:ASPxComboBox>
                            <br />
                            <dx:ASPxButton ID="btnBuscar" runat="server" Text="Buscar" AutoPostBack="true">
                            </dx:ASPxButton>
                        </dx:PanelContent>
                    </PanelCollection>
                </dx:ASPxRoundPanel>
            </td>
            <td style="vertical-align:top">
                <dx:ReportToolbar ID="rtbReportePresupuestoAnualConsolidado" runat="server" 
                    ReportViewerID="rpvReportePresupuestoAnualConsolidado" ShowDefaultButtons="False" Theme="BlackGlass">
                    <Items>
                        <dx:ReportToolbarButton ItemKind="Search" />
                        <dx:ReportToolbarSeparator />
                        <dx:ReportToolbarButton ItemKind="PrintReport" />
                        <dx:ReportToolbarButton ItemKind="PrintPage" />
                        <dx:ReportToolbarSeparator />
                        <dx:ReportToolbarButton Enabled="False" ItemKind="FirstPage" />
                        <dx:ReportToolbarButton Enabled="False" ItemKind="PreviousPage" />
                        <dx:ReportToolbarLabel ItemKind="PageLabel" />
                        <dx:ReportToolbarComboBox ItemKind="PageNumber" Width="65px">
                        </dx:ReportToolbarComboBox>
                        <dx:ReportToolbarLabel ItemKind="OfLabel" />
                        <dx:ReportToolbarTextBox IsReadOnly="True" ItemKind="PageCount" />
                        <dx:ReportToolbarButton ItemKind="NextPage" />
                        <dx:ReportToolbarButton ItemKind="LastPage" />
                        <dx:ReportToolbarSeparator />
                        <dx:ReportToolbarButton ItemKind="SaveToDisk" />
                        <dx:ReportToolbarButton ItemKind="SaveToWindow" />
                        <dx:ReportToolbarComboBox ItemKind="SaveFormat" Width="70px">
                            <elements>
                                <dx:ListElement Value="pdf" />
                                <dx:ListElement Value="xls" />
                                <dx:ListElement Value="xlsx" />
                                <dx:ListElement Value="rtf" />
                                <dx:ListElement Value="mht" />
                                <dx:ListElement Value="html" />
                                <dx:ListElement Value="txt" />
                                <dx:ListElement Value="csv" />
                                <dx:ListElement Value="png" />
                            </elements>
                        </dx:ReportToolbarComboBox>
                    </Items>
                    <styles>
                        <LabelStyle>
                        <Margins MarginLeft='3px' MarginRight='3px' />
                        </LabelStyle>
                    </styles>
                </dx:ReportToolbar>
                <dx:ReportViewer ID="rpvReportePresupuestoAnualConsolidado" runat="server" Theme="Default" ReportName="ReportePresupuestoAnualConsolidado">
                </dx:ReportViewer>
            </td>
        </tr>
    </table>
</asp:Content>

Hi guys I'm new to this, and I'm solving a mystery, I happen to have a report in Devexpress which allows me to export it in different formats.

The issue is that when I export it in PDF, the totals column shows it to me correctly.

But when I export it in XLS format the totals are lost:

It should be clarified that it is the same report, only that PDF shows me the totals and in Excel not.

I thank you in advance for your kind help!

    
asked by camivalo 31.07.2017 в 23:29
source

0 answers