We are continuing our evaluation to replace FlexMonster with the current silverlight implementation.
In exporting the data from the grid to an excel spreedsheet we have noticed a discrepancy with the output and what is in the export. There is no summary of filters and data points are missing
Is there a way to include what we want with the exported data (see attached screen shots)?
Hello Matt,
Thank you for your question. Please find the information about extending exporting functionality here: https://www.flexmonster.com/doc/export-report/. You need to set showFilters
property true
so the pivot can export the filters to Excel. Here is the example: https://jsfiddle.net/petcnwsx/5/.
Please let us know if the issue is resolved.
Regards,
Dmytro
Hi Dmytro,
Thanks. I can see how that should work. Is there a prescribed way to add that into the existing export excel button provided by the tool bar?
Thanks,
Matt
Hello, Matt,
Thanks for your quick feedback! We are happy that the suggested approach works for you.
Our recommended way to customize Toolbar functionality is to use beforetoolbarcreated event. For more details please refer to Customizing toolbar tutorial.
Please inform me in case of further questions.
Regards,
Tanya