A request was made to export all data in a report, not just what is displayed on the page currently displayed. This would allow the user the ability to see and manipulate data in whatever fashion that may be prohibited by the paging mechanism. Dev to confirm if this is possible.
1. How to disable Export to Excel icon in UltraGrid until export is complete, we need to indicate the export is in progress
2. This exists in current demo version today, however only the final page should have a label of "Grand Summaries". All other prior pages should display a label of "Sub-Totals" Example • If there are 10 pages of data and the Amount and Base Amount on each page equals 1,000 and 1,500, respectively, I expect 1,000 and 1,500 be displayed at the bottom of each page with a total of 10,000 and 15,000 on the last page. • Grouping and "Selected Summaries" chosen (if applicable) should remain in tact in Excel
3. Even if the data shown on grid is of 1 page, how to export ALL the data in the dataset to excel without binding it to Ultragrid
AOps said: A request was made to export all data in a report, not just what is displayed on the page currently displayed. This would allow the user the ability to see and manipulate data in whatever fashion that may be prohibited by the paging mechanism. Dev to confirm if this is possible.
This appears to be repeat of the same question I just answered here.
AOps said: 1. How to disable Export to Excel icon in UltraGrid until export is complete, we need to indicate the export is in progress
There are events on the UltraGridExcelExporter that tell you when the operation is complete. The event was changed recently, though, so which even you use depends on what version of the controls you are using. Its either ExportEnded or EndExport.
AOps said:2. This exists in current demo version today, however only the final page should have a label of "Grand Summaries". All other prior pages should display a label of "Sub-Totals" Example • If there are 10 pages of data and the Amount and Base Amount on each page equals 1,000 and 1,500, respectively, I expect 1,000 and 1,500 be displayed at the bottom of each page with a total of 10,000 and 15,000 on the last page. • Grouping and "Selected Summaries" chosen (if applicable) should remain in tact in Excel
I'm not sure what you are asking here. The WinGrid has no paging functionality, so this is probably a result of what you are doing with your paging implementation.
AOps said:3. Even if the data shown on grid is of 1 page, how to export ALL the data in the dataset to excel without binding it to Ultragrid
Once again, I beleive this is the same question I answered here.
Thanks for the quick reply Mike,
#1. Ok I can handle the ExportEnd event but how to write code to disable the export button and the enable it on Export End, is there any property ?
#2 . Yes we are using UltraGrid but the paging is implemented on our own in such a way that only 1 page data is bound to the grid and shown to user.
summary of data is shown on UltraGrid for the rows in 1 page, if I want to summarize all the page summaries at last page, is that passible?
Could you suggest some way to do it?
#3. Yes we are using UltraGrid but the paging is implemented on our own in such a way that only 1 page data is shown to user.
We can successfully export 1 page data to excel, but in case when all the pages’ data is loaded then is it possible to export that to excel? This should happen without rendering all page data.
The link you have mentioned as reply to #1 does not open, can you give me the exact URL?
Thanks you very much Mike.
This has solved all my queries.
Hi,
AOps said:#1. Ok I can handle the ExportEnd event but how to write code to disable the export button and the enable it on Export End, is there any property ?
What button are you referring to? There's no export button built-in to the grid. So whatever button control you are using, you probably just need to set it's Enabled property.
AOps said: #2 . Yes we are using UltraGrid but the paging is implemented on our own in such a way that only 1 page data is bound to the grid and shown to user. summary of data is shown on UltraGrid for the rows in 1 page, if I want to summarize all the page summaries at last page, is that passible? Could you suggest some way to do it?
Obviously, since the grid does not have all of the data, there's no way the grid can calculate the summary for you. You could add a summary into the grid that uses an ICustomSummaryCalculator and this would allow you to calculate the value yourself.
AOps said: #3. Yes we are using UltraGrid but the paging is implemented on our own in such a way that only 1 page data is shown to user. We can successfully export 1 page data to excel, but in case when all the pages’ data is loaded then is it possible to export that to excel? This should happen without rendering all page data.
I'm not sure what you are asking here. The UltraGridExcelExporter only has access to the grid you give it. And the grid only has access to the data you give it.
The only way I can see to do this would be to create a second grid and bind it to the entire set of data.
AOps said:The link you have mentioned as reply to #1 does not open, can you give me the exact URL?
I have fixed the link.