In addition to providing the ability for report Designers to simulate "Report Viewer" mode, the Jet Reports Excel add-in is able to simulate Jet Express.
This allows report Designers to test that reports created with the full Jet Excel add-in will also operate as expected in Jet Express.
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 Express...
and selecting an Express mode data source of a type compatible with Jet Express:
- 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 full Jet Excel add-in just as if you were using Jet Express...
Only those options that are available within Jet Express will be accessible.
You will notice that the Data Source Type button on the Data Source Settings window is disabled while in Jet Express mode.
If you need to change the data source while simulating Jet Express, you can do so from the App Settings window.