Jet Reports Snippets

To create a snippet, open the Snippet tool. Highlight the range of cells containing the piece of functionality for which to make a snippet. Then, click the New Snippet button in the Snippet tool.

To use a snippet, drag and drop it from the Snippets window to any cell of your workbook. Any existing Excel formulas, text, or formatting in these cells will be overwritten.

Rename
You can rename a snippet by selecting it and pressing F2 or by right-clicking it and selecting Rename.

Delete
Delete a snippet by selecting it and then pressing the Delete button in the Snippet tool or by pressing the delete key.

Replace
You can replace the contents of the current snippet by selecting the region of the worksheet that you would like to use as the contents, selecting the snippet you wish to replace in the Snippet tool then pressing the Replace button.

Organizing Snippets
Snippets are organized in a folder structure. Snippets can be organized into folders using drag and drop or cut/copy/paste within the Snippet tool.

Snippets are stored in the Jet Reports Snippets folder located in your My Documents directory.  This location can be changed in the Application Settings.  Each snippet is stored in a *.snippet file.

To share snippets, copy the snippet files from one user's snippet directory to another's.

Close and open the Snippets window and the newly added snippets will become available.

We’ve created a handful of Snippets to get you acquainted with this feature and to demonstrate the power of Snippets.

The attached NAV Snippets can be used together to easily create a variety of Trial Balance, Balance Sheets and Income Statements with MS Dynamics NAV databases.

The attached GP Snippets can be used together to easily create a variety of report with MS Dynamics GP databases.

Download and extract the Snippets from the .zip file. Copy these Snippets into your Jet Reports Snippets folder under My Documents, to get started with them.