Product Ideas

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

Drilldown to Business Central with more Complex Formulas

I'd love to be able to drill down from Jet Reports into Business Central when I need more complex formulas than the single statement it is now capable of. For example, being able to see all of the entries that encompass the following formula:  

GL("Balance",5039,Amount_Start_Date,Amount_End_Date,,,"5526")+GL("Balance","5000..5009",Amount_Start_Date,Amount_End_Date,,,"5540")

  • Guest
  • Aug 16 2018
  • Under Consideration
  • Attach files
  • Diana Micu commented
    April 19, 2019 15:41

    I'm a GP user and I have a summary report for totaling data from a few departments. The drilldown shows just the details of the last one included in the formula. It is ridiculous! These reports are created for the senior management, who would like to have the details of all transactions under one drilldown click. One should not expect to have to check and drilldown in each department separately. I hope a solution will be found soon.

  • Jamie Agee commented
    August 27, 2018 18:27

    This should be the case for all connectors. When drilling in to the Jet Data Grid from a cell comprised of a compound expression, a tab should be created for each part of the expression.