I’m in the process of evaluating Aspose.Cells for Reporting Services as a replacement for a bunch of reports that are currently designed using numerous 3rd party macros. One of my requirements is offering the ability to export an SSRS to Excel and to retain the formulas. I see that the product does indicate this works by using DynamicFormulas.
Here are my questions:
1) I need to ensure SUM functions are retained in the report. I have been trying to this by modifying your “Sales Order Detail” sample report (Total Discount and Total boxes). So far, I have been unsuccessful. Is this possible and can you explain how?
2) The Dynamic Formulas are great but don’t work when viewing the report on the SSRS report site. Is there any way to have the report display one value on the site and another when rendered in Excel?
3) Is it possible to apply a data filter on a group?