Export to excel disables all controls in the current page

[Uttam Dhakal]

i have the export to excel funcionality in my current page with a radgrid.
if i click on the export to excel it exports to excel but until i do a page reload none of the other controls works in my page .
neither sorting, nor filtering or any other controls in the current page works properly once i have this export to excel clicked.
the only way is to reload the page.
how can i get rid of this behaviour of the page.

[Daniel]

Hello Uttam,

May I ask you to help me recreate this scenario on my end? I would appreciate it, if you could post a simple self-contained demo here so I can debug the problem locally.

Thanks in advance,
Daniel
the Telerik team

[Uttam Dhakal]

thanks,
i found the solution

[Heidar]

Hi,

I have the same problem, if I export the report to excel or any other output, all controls in the current page get disabled unless I reload the same page back

If you have found the solution, would you please help me to understand it

Regards

[Daniel]

Hello Heidar,

I have to ask you the same question - can you isolate the problem in a simple demo? This will help me pinpoint the problem.

Regards,
Daniel
Telerik

[Heidar]

Hi,

Thanks for replying back,

This is what I am doing:

I Have a telerik report already designed called "ProjectReport"

Then I have a webform called: ProjectReports
in the aspx of the webform I have the following code:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ProjectReports
.aspx.cs" Inherits="MyProject.Modules.Project.UI.Webpages.ProjectReports"
  MasterPageFile="~/Modules/MyProject.Master"%>

<%@ Register assembly="Telerik.ReportViewer.WebForms, Version=6.2.13.123, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>


<asp:Content ID="Content2" ContentPlaceHolderID="PageHeadContentPlaceHolder" runat="server">
</asp:Content>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <div id="ProjectDiv" class="projectDiv">
        <div id="FormsReportsSelectionDiv" class="formsReportsSelectionDiv">
           
            <asp:DropDownList ID="ProjectYearDropdownList" class="formDropdownList" runat="server">
            </asp:DropDownList>

            <asp:Button ID="SubmitButton" runat="server" text="Show" onclick="SubmitButton_Click"/>

        </div>
            
        <div id="ReportViewerContent" class="mediumBorder reportViewerContent" runat="server" visible="false">
            <telerik:ReportViewer ID="ProjectReportViewer" runat="server" Height="660px" Width="100%" Visible="false"/>
        </div>
    </div>
</asp:Content>

then in the method on .cs file of the webform I have the following:

   ReportViewerContent.Visible = false;
            
            yearStart = int.Parse(ProjectYearDropdownList.Text.ToString());
            yearEnd = yearStart + 1;

            DateTime currentYear = new DateTime(yearStart, 4, 1);
            DateTime finishYear = new DateTime(yearEnd, 3, 31);

            reportManager = new ProjectReportManager(_repository);

            DataTable dataTable = reportManager.GetStaffDetailsForProjectYear(Year1, Year2);

            var instanceReportSource = new Telerik.Reporting.InstanceReportSource();
            ProjectReport projectYears = new ProjectReport();
            instanceReportSource.ReportDocument = timeSheetHolidays;
            ProjectReportViewer.ReportSource = instanceReportSource;
            projectYears.DataSource = dataTable;
            ReportViewerContent.Visible = true;
            ProjectReportViewer.Visible = true;

In My user interface, I get a button and a combo box, choosing a year and then hit the button it will then bring the datatable and pass it to the telerik report which was designed with textboxes as exact name as the database output (offcourse with =Fields.)

That is all I do, and when I hit the export to: Any Format (e.g. Excel) I will get all the controls in the webform disabled unless I refresh the page once more then will get them all enabled,

Hope that explains everything

Regards

[Kostadin]

Hello Heidar,

I am afraid that I was not able to replicate the issue on my side. I noticed that you are using an old version of Telerik Reporting, so could you please try with a newer one and check whether the issue remains? Additionally it would be best if you could provide us with a small runnable sample in order to investigate the issue further.

Regards,
Kostadin
Telerik