Dear DevExpress-Support,
we are using the ASPxGridViewExporter with an ASPxGridView. The Export works very well for the data shown in the grid i.e. 15 records per page. Is there a possibility to export all data by using the ASPxGridViewExporter, even if the ASPxGridView uses paging? Is there an event we could intercept and change to export all the data?
Any help would be appreciated.
Thank you!
Ticket
Q209893
Visible to All Users
Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Hi Stevenson,
By default, the ASPxGridViewExporter exports the entire ASPxGridView control data.
If you are experiencing any difficulty at this point, please ensure that your data binding approach in complete.
To export only selected grid rows, set the ASPxGridViewExporter.ExportedRowType property to GridViewExportedRowType.Selected.
If this doesn't help, describe the problematic scenario in greater detail, or post a sample project, showing the issue. I'll be glad to help you.
Thanks,
Alex
Dear Alex,
in our configuration the ASPxGridViewExporter does not export the entire ASPxGridView control data. We are using DataSourceForceStandardPaging="true" in the ASPxGridView bound to an ObjectDataSource. Here the SelectCountMethod="GetOpenItemsCount" and SelectMethod="GetOpenItems2" only retrieve the necessary data. Upon the export process the generated files (xls. pdf, csv, etc.) only display the data of one Grid-page e.g. 15 rows (not all rows).
Is there an attribute to the ASPxGridViewExporter / ASPxGridView to download all data, even if paging of the Grid is enabled?
Looking forward to your answer.
Thank you!
Stevenson
Hi Stevenson,
Thanks for the clarification. It appears that this misbehavior is caused by an issue reported at: ASPxGridView - The Pager's All button does not work properly if the DataSourceForceStandardPaging property is set to true.
We've already updated our methods, and the bug fix will be included into the next maintenance release of the Suite (v2009 vol 1.5).
If everything goes according to plan, we'll publish an official v2009 vol 1.5 update this week.
Thanks,
Alex
We will use the new relase then. Thank you!
Dear Alex,
unfortunately the new release 9.1.5.0 still does not solve our problem.
I attached a little example in which you will see that the ASPxGridViewExporter will only export 1 page.
To make it much clearer you should navigate to another page than page 1 and start the export with the button above the gridview. Then you will see that not only the export is restricted to 1 page, the control will also export every other data row as empty cells which are kind of formatted.
Please note that we are using an ObjectDataSource to provide correct paging and set the DataSourceForceStandardPaging property to true.
Thank you for your help.
Hello Stevenson,
Thank you for the project. We believe that it is a bug.
I've created a bug report ASPxGridViewExporter - It's impossible to export all the data from the grid, if the DataSourceForceStandardPaging property is set to True.
Please track it to see its status.
Thanks,
Vest