Show LoadingPanel when exporting PivotGrid to Excel

[Rafael]

I am trying to show the Loading Panel (implicit or explicit) when I click the export button of the RadPivotGrid, can someone help me with that, please?

I've tried two different ways yet, the first one was setting my PivotGrid in the RadAjaxManager, no success, it is not exporting, no errors, no message, no file!

The second one was showing LoadingPanel explicit. now it is exporting, but I(my application) do not know when the exporting process ended. My hope was to implement some token/cookie technique, no success, the client-side do not receive the cookie update after the export method(server-side).

 

Any help would be welcome!

Thanks.

[Daniel]

Hello Rafael,

I would recommend the following setup if you have the latest version:

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1" ShowLoadingPanelForPostBackControls="true" PostBackControls="ExportBiff, ExportXlsx">
    <asp:Button ID="ExportBiff" runat="server" Text="Biff" OnClick="Button1_Click" />
    <asp:Button ID="ExportXlsx" runat="server" Text="Xlsx" OnClick="Button2_Click" />
    <telerik:RadPivotGrid ID="RadPivotGrid1" runat="server" ...>
                    ...
    </telerik:RadPivotGrid>
</telerik:RadAjaxPanel>

Export from ajaxified grid

I hope this helps.

Regards,
Daniel
Telerik

[Rafael]

Daniel, thanks!

 

Actually I can't test the possible solution, 'cause I have the  2014Q3, so I wont mark as answered.

Is there any workaround for that version of the component(2014Q3)? Unfortunately, it's not an option to upgrade the version at this time.

 

Thank you again!

[Daniel]

Hello Rafael,

You can implement this functionality, but it may not be as straightforward as you may expect.
There is an example for RadGrid in the following code-library. You have to tweak it to work with RadPivotGrid:
Show loading panel when exporting RadGrid

I would still recommend that you consider upgrading to the latest version where this functionality is built-in and no cookies are required.

Regards,
Daniel
Telerik

[Rafael]

Hello Daniel.

 

Like I said, I've already tried the cookie/token idea, no success.

Anyway, thanks again, I'm gonna keep without loading panel, and will update the component version as soon as possible.