Page History

The OfficeWriter Designer has the ability to work with reports that are created in Report Builder and Visual Studio, but it also provides a way to develop reports from scratch within Excel using MS Query.

Enabling MS Query in the OfficeWriter Designer

By default, the OfficeWriter Designer 's Add Query, Edit Query, and Delete Query buttons are disabled. These buttons are required for creating queries using Microsoft Query with OfficeWriter. If the query buttons are not available on the OfficeWriter toolbar, reset the registry key Enable MSQuery as followsMS Query functions for adding, editing, and removing queries are disabled and will not appear in the OfficeWriter Designer toolbar.

To enable MS Query for the OfficeWriter Designer:

1. Open the Start menu and select Run.
   # Enter regedit and click Ok.
   # Open the folder HKEY_CURRENT_USER\Software\SoftArtisans\OfficeWriter\Designer.
   # Double-click Enable MSQuery. A dialog will open.
   # In the Value Data field, enter 1.

Once MS Query has been enabled, the Add DataSet button will be available. The Edit DataSet and Delete DataSet options will become available through Data Markers > DataSets once a data set has been added to the report.
\
Image Added

Working with MS Query with the OfficeWriter Designer