Ria OLAP Grid: Enhance Excel export to show all data instead of only what's visible on the screen
Currently an excel export will only move the currently visible data to an excel file.
If you have ever used reporting services and exported a drilldown report to excel, you know that excel can do drilldown by itself; that report not only contains all of a report's data, you can expand and collapse groups just like in the report itself.
It would enhance the (now hardly useful) Excel export to give it those features. I'd like the excel export contain all data (also data on another pages than the currently visible one), and preferrably it could use the same grouping as the cube data.
Just set the RiaOLAPGrid.IgnoreGridPaging to True.
1 comment
-
harikrishna.bura
commented
this is for only pagging ,i want to export all collapse cells data .