Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

Do you want to play a crucial role in shaping Jet Global products?

Conditionally running sheets

We have reports with multiple sheets and in some cases it is not necessary to calculate/run all report sheets. Currently It is possible to hide sheets dynamically but in order to improve also the performance it would helpful to prevent dynamically running report function for a whole sheet. We need this for the Excel add-in and the Web Portal.

  • Michael Schuchart
  • Nov 7 2018
  • Under Consideration
Designing & Running Reports
  • Attach files
  • Guest commented
    January 30, 2019 15:55

    From a troubleshooting perspective it would be nice to ignore all Jet functions within a given sheet. This would allow one to run a single sheet at a time to better isolate issues and would save time processing unnecessary sheets. We could implement via a new keyword, maybe +IgnoreSheet,+NoCalculateSheet, etc... 

    ×

    Attachments Open full size

  • Michael Schuchart commented
    November 22, 2018 08:21

    Amendment:

    In this context if a complete sheet is not calculated the sheet should be automatically hided!

    ×

    Attachments Open full size

Related ideas