In order to allow report Designers to test that reports created with the full Jet Excel add-in will also operate as expected in Jet Basics, the Jet Reports Excel add-in is able to simulate Jet Basics.
From the Jet ribbon in Excel, select App Settings...
On the General tab, you'll see that the Simulation Mode option is set to None
This indicates that Jet add-in is operating in its normal "non-simulating" mode.
By changing this option to Jet Basics...
and selecting a Jet Basics data source of a type compatible with Jet Basics:
- Dynamics NAV 2009 R2
- Dynamics NAV 2013 and later (Web Services)
- Dynamics NAV 2013 and later (SQL Server)
- Dynamics GP
you will now be able to use the Jet Excel add-in just as if you were using Jet Basics...
Only those options that are available within Jet Basics will be accessible.
You will notice that the Data Source Type button on the Data Source Settings window is disabled while in Jet Basics mode.
If you need to change the data source while simulating Jet Basics, you can do so from the App Settings window.