NAV - Report options with Dimension, Company, Dates & Period

Share snippets that you have created in Jet Reports 2010 and see what others have done.
PaulJet
Posts: 24
Joined: Thu Feb 07, 2008 9:22 pm

NAV - Report options with Dimension, Company, Dates & Period

Postby PaulJet » Mon Jun 20, 2011 1:03 pm

Hi Everyone,

This Snippet is for an options sheet which includes the following:

-Start Date
-End Date
-Date Range (Combines the start date & end date to form a full date filter)
-Dimension 1 (Code & Name displayed)
-Company Name
-Period Type (allows you to select year, qtr, month, week)

Be sure when using the Snippet to place the upper left hard corner in cell A1 for it to work properly. This Snippet works best for financial reporting. Try combining it with the column generator Snippet and don't forget to use F3 as a short cut for the Excel named ranges look up.

I hope you enjoy and happy reporting....
Attachments
Options - Start Date, End Date, Dimension code, Company filter. Place in A1.snippet
(89.34 KiB) Downloaded 1250 times

Andrio
Posts: 1
Joined: Tue Dec 23, 2014 10:49 pm

Re: NAV - Report options with Dimension, Company, Dates & Period

Postby Andrio » Tue Dec 23, 2014 11:00 pm

ONLY FOR GB database as period localisations exist since V3.01
FSL:


Return to “Shared Snippets”

Who is online

Users browsing this forum: No registered users and 1 guest