Product Ideas

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

Save the Default Data Source setting in the report

I have two databases in Business Central: "Test" and "Production". Sometimes I need to run reports on my Test database to validate Code updates, application setup changes, etc.

The problem is that if I am working in my Test database at the exact moment a Scheduled report is triggered, that report will run on my Test database instead of my Production database, as desired.

The current solution is to set the DataSource and Company as filters on all NL(rows) functions, to ensure that the report runs on the correct database, regardless of which source I happen to be working in when it is triggered. This is very cumbersome, especially in large, complex reports with many NL functions.

It would be very useful to be able to set the preferred database as the Default Database for the entire report and SAVE that preference so it is automatically applied as a filter to each function when the Scheduled report is run.

  • Guest
  • Jan 4 2022
  • Attach files
  • Guest commented
    20 Jun 10:28am

    maybe you can use the filters "DataSource="