Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Submit a Request
Give Feedback

Launching Jet Professional from Dynamics NAV Classic Client

  1. Start Excel; make it visible and interactive.

  2. Open the Jet Reports Excel Add-in.

  3. Open a Workbook.

  4. Update Options.

  5. Run Jet/Report.

  6. PrintPreview the Worksheet that contains the report.

  7. Close Excel.

Name Data Type Subtype
XL Automation 'Microsoft Excel 10.0 Object Library' .Application
Workbook Automation 'Microsoft Excel 10.0 Object Library'.Workbook
Worksheet Automation 'Microsoft Excel 10.0 Object Library'.Worksheet


{To reuse existing instances of Excel, use CREATE(XL)}



{Workbooks don't necessarily start visible or interactive. Since the

user will interact with the workbook, you need to set the below values.}


XL.Interactive := TRUE;

XL.Visible := TRUE;


{Add-ins do not automatically open when using automation, so the Jet Excel add-in

must be opened below. You must also open any other add-ins that are needed.}


XL.Workbooks.Open('C:\Program Files\JetReports\JetReports.xlam'); 

{Open the report workbook.}


Workbook := XL.Workbooks.Open('C:\Program Files\JetReports\Reports\Finance Graph.xls');


{Update the report options. The option values are in single cell named ranges.}


Workbook.Names.Item('PeriodType').RefersToRange.Value := 'Week';

Workbook.Names.Item('DateFilter').RefersToRange.Value := '1/1/01..3/31/01';

{Run the jet report.


In Jet Professional 2018 (18.0) and higher, the menu option is RUN:


In earlier versions, the menu option is REPORT:



In VERY early version s of Jet Reports (prior to Jet Reports 2009), you must also run the EVENTS macro:





{In some cases all the below steps may not be desired. Perhaps the user wants to drilldown and examine the report in Excel.}

{Choose a worksheet and launch print preview. The user can cause the report to print if desired.}


Worksheet := Workbook.Worksheets.Item('Report');



{Avoid the message asking if the workbook should be saved by marking it as already saved. Be careful with this. This step assumes that the workbook does not need to be saved since it is a report template.}

Workbook.Saved := TRUE;


{Close Excel}





Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request