Those of us who use Jet Reports are painfully aware that Jet does not have a ranking feature for replicated lists. However, there is a workaround: you can create an automatically sorted Jet report with nested Jet functions and use Excel’s rank function to give you a ranked Jet report. This blog will walk through the steps to do just that.
Tag Archives: Jet
BI Advantage (Web Based Dashboards ) Jet Reports
Web Based Dashboards Provide Insight from Anywhere
Other options for creating Report in Jet
Report Wizard An entire report can be created from a single table using the Report Wizard. The Report Wizard allows data to be grouped, filtered, sorted, subtotaled, and formated.
How to Use the Jet Report Scheduler
The Jet Scheduler is a powerful tool that allows users to schedule reports to be automatically run by the Windows Task Scheduler. The user can also control where the output file is saved to, if the report should be emailed once it has been generated, and the output format of the report.
Creating Report in Jet Using NL, NF, NP & GL & Excel Formulas
Dear friends today I will discuss report “General Ledger Budget to Actual by Period” and demonstrate the usage of NP & GL Functions.
This report will contain all the Functions, Commands we discussed till now and usage of NP & NL Functions.
Using Jet Report NF Function
The NF function is a shortcut that will return the value of a field in a record. One or more NF functions can be used with a single NL function that has the NL field parameter left blank.
Using Jet Report NL Function
Returns fields or record keys from a table based on filters. Duplicates report templates.