Completed
Last Updated: 25 Feb 2014 08:53 by KE
ADMIN
Kostadin
Created on: 20 Feb 2013 14:11
Category: PivotGrid
Type: Feature Request
38
ADD: RadPivotGrid export functionality

		
(Total attached files size should be smaller than 20mb. Allowed extensions: .zip, .rar, .jpg, .png, .gif)
44 comments
KE
Posted on: 25 Feb 2014 08:53
We follow the steps here:
http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/exporting/defaultcs.aspx

But the pivotgrid.exporttoexcel() is not working. We create a button to call this function but there is no file generated as shown in the demo.

Are we missing anything here?

We are using Telerik.Web.UI version 2013.3.1324.40

attach is the code.
Attached Files:
Janan
Posted on: 19 Sep 2013 00:27
When will the export to Excel functionality be available for the WinForms RadPivotGrid?
James Bonnyman
Posted on: 16 Aug 2013 10:47
I too would like to know if/when the export facility will be available in the WinForms release - it is a great addition to the controls and one I am keen to make use of but, until export is included, this is not possible ( I cannot even show its use as the 1st request I will get will be to allow users to export data from it!).
Krishna
Posted on: 06 Aug 2013 13:59
Is this functionality available for winforms in this release? If not, when will it be? Thanks
Jeff
Posted on: 07 Jun 2013 14:38
That's great news Iana, thanks!
ADMIN
Iana Tsolova
Posted on: 06 Jun 2013 11:16
@Bill, yes, it is not available in the Q2 2013 Beta but will be there with the official Q2 2013 version.
Bill
Posted on: 06 Jun 2013 11:07
@Iana 
I didnt see the feature in the beta demo site, is it still planned for release? I really need this bad!
http://demos.telerik.com/aspnet-ajax-beta/
Thanks,
~bg
Per Erik
Posted on: 06 Jun 2013 06:00
You can use this to export RadPivotGrid to excel
        public override void RenderControl(HtmlTextWriter writer)
        {
            if (Session["SendPage"] != null)
            {
                Response.Clear();
                //Response.Buffer = true;
                Response.AddHeader("content-disposition", "attachment;filename=Rapport_" + System.DateTime.Now.ToShortDateString() + "_" + System.DateTime.Now.ToShortTimeString() + "_T.xls");

                Response.Charset = "UTF8";

                Response.Cache.SetCacheability(HttpCacheability.NoCache);

                Response.ContentType = "application/vnd.xls";

                System.IO.StringWriter stringWrite = new System.IO.StringWriter();

                System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

                RadPivotGrid1.RenderControl(htmlWrite);

                Response.Write(stringWrite.ToString());

                Response.End();
            }
            else
            {
                base.RenderControl(writer);
            }
        }

        protected void BtnExportClick(object sender, EventArgs e)
        {
            Session["SendPage"] = "Export";
        }
ADMIN
Iana Tsolova
Posted on: 04 Jun 2013 11:23
We are happy to tell you that we were working on this highly requested and voted feature and it'll be included in the Q2 2013 version of RadControls for ASP.NET AJAX, due in the middle of the next week. Additionally, follow our blog (http://blogs.telerik.com/aspnet-ajax/) where we will post further information of the PivotGrid export functionality and its abilities.
Debajyoti
Posted on: 23 May 2013 15:00
Absolutely required feature.Very much needed! +1 vote
Thapanee
Posted on: 16 May 2013 08:33
We need export function.
Rajith Kannoth
Posted on: 13 May 2013 08:40
Absolutely  required feature. Please provide the export to excel option.
David
Posted on: 09 May 2013 13:28
Throwing my vote in too.  Without export the pivot grid loses a large amount of usefulness.
Imported User
Posted on: 09 May 2013 12:31
Absolutely need export to PDF and Excel.  The product really needs this to be complete.
Joe
Posted on: 08 May 2013 13:00
Agreed, print and export are very much standard business requirements in our environment. Please make it EXPORT!
Martin
Posted on: 08 May 2013 12:55
I reckon since exporting and printing is a standard feature in the grid controls, why not have it in the PivotGrid? It is imperative to have these features.
Antony
Posted on: 25 Apr 2013 13:47
Is there any progress on the export functionality, I would like to use the pivotgrid in our application but without the export/print functionality I can't as the users will see it as a half implemented solution.
ycthean
Posted on: 12 Apr 2013 05:35
Please provide an export function
rulloa
Posted on: 12 Apr 2013 04:28
Export would be beneficial
David
Posted on: 04 Apr 2013 03:53
With out at least an export and ideally a print this control is useless.  No one is going to spend time using it if they can't make it part of a report.
Eric
Posted on: 02 Apr 2013 14:05
Is there a way to access the MDX that is generated by the users selection of columns/rows/etc?  If we could get access to that we could at least build custom exports.
Mark
Posted on: 02 Apr 2013 11:20
An option to export to XLS is holding us back from using this control. It needs to be a pivotgrid not just the data
Jon
Posted on: 29 Mar 2013 16:12
We would like to have the data export to a Excel Pivot format so it can be worked offline in Excel just how the fields were arranged in the PivotGrid.  Thanks for all the great work thus far.
Brian
Posted on: 29 Mar 2013 15:58
The gird is amazing the fact that we can't export means that we can not use it yet.
Please please please make it be exportable.
Jon
Posted on: 28 Mar 2013 01:52
Excel please 
Fredrik
Posted on: 22 Mar 2013 10:27
Please do an export function to Excel
Kevin Treweek
Posted on: 21 Mar 2013 16:57
Add my support to this feature request. Its the first thing my clients will ask for if I show them the RadPivotGrid. Its not much use to me until it supports the ability to export to Excel.
David
Posted on: 15 Mar 2013 22:20
export excel pls
Jeremy
Posted on: 14 Mar 2013 03:06
We need this feature as well. Our clients will always want to export from grids.
Hector
Posted on: 12 Mar 2013 03:30
Same here...PDF and Xcel
Guy
Posted on: 10 Mar 2013 19:15
Please provide export feature to Excel as soon as possible.
Neil N
Posted on: 04 Mar 2013 16:40
The ability to export to Excel is absolutely critical for us.
o2
Posted on: 01 Mar 2013 08:09
Please provide export feature to Excel as soon as possible.
Imported User
Posted on: 25 Feb 2013 13:52
Please provide export feature to PDF and Excel as soon as possible.
comgiu
Posted on: 22 Feb 2013 11:47
please xls 
thanks
Djoni Cla Ruffin
Posted on: 22 Feb 2013 09:44
The first question my Business Inteligence Colleagues is "Can I export to Excel/Word/PDF?"
Ron
Posted on: 21 Feb 2013 20:28
Agree need to have some mechanism available to have a copy-in-hand either print or export to Excel. This should be a high priority.
Angie
Posted on: 21 Feb 2013 19:22
Ditto.  When I showed its use in a new application, the very first question I got was "Can I export it to Excel?"  If the data can't be saved off or printed, it doesn't provide them much longterm value.
Brad
Posted on: 20 Feb 2013 19:36
Yes we need this right away.
Imported User
Posted on: 20 Feb 2013 19:15
We desperately need this functionality. It's not much use without it.
James Daresta
Posted on: 20 Feb 2013 18:38
Export would be a huge asset to this control. It is because it cannot that I do not use it as much as I would like and instead use SQL Reporting.
Lane
Posted on: 20 Feb 2013 18:23
I am using the RadPivotGrid, and everywhere it's in use, users are asking for the export functionality.
Dennis
Posted on: 20 Feb 2013 17:38
I agree with William.  The new RadPivotGrid functionality looks great; however, the first question my users will ask "Can I export to Excel/Word/PDF?"
William
Posted on: 20 Feb 2013 14:59
In need of this functionality for a project.  Users love the Pivot Grid, but also need the ability to export the data for reporting to Sr. Mgmt.