Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

Jet Web Portal - Feature Support


Overview

The Jet Web Portal supports the vast majority of all features present in the Jet Excel add-in.

 

Data Sources

The following data sources are supported in the Jet Web Portal:

  • Dynamics NAV 2013 and higher
  • Dynamics GP (On Premises)
  • Dynamics NAV (Remote Data Service)
  • Dynamics GP (Remote Data Service)
  • Jet Enterprise Data Warehouse
  • Jet Enterprise Cubes
  • Universal

 

Supported Excel Functions

The following Excel functions are supported.  Those not in this list will fail to calculate if they are either dependent upon or a dependency of a Jet function:

A-C D-H I-L M-R S-Z
  • ABS
  • ACOS
  • ACOSH
  • ADDRESS
  • AND
  • ASIN
  • ASINH
  • ATAN
  • ATAN2
  • ATANH
  • AVERAGE
  • AVERAGEA
  • AVERAGEIF
  • AVERAGEIFS
  • CEILING
  • CHAR
  • CHOOSE
  • COLUMNS
  • CONCATENATE
  • COS
  • COSH
  • COUNT
  • COUNTA
  • COUNTBLANK
  • COUNTIF
  • COUNTIFS

 

  • DATE
  • DATEVALUE*
  • DAVERAGE
  • DAY
  • DAYS360
  • DCOUNT
  • DCOUNTA
  • DEGREES
  • DGET
  • DMAX
  • DMIN
  • DSUM
  • DVAR
  • DVARP
  • EDATE
  • EOMONTH
  • ERROR.TYPE
  • EXACT
  • EXP
  • FACT
  • FALSE
  • FIND
  • FIXED
  • FLOOR
  • GETPIVOTDATA*
  • HLOOKUP
  • HOUR
  • HYPERLINK
  • IF
  • IFERROR
  • IFNA
  • INDEX
  • INDIRECT
  • INT
  • ISBLANK
  • ISERR
  • ISERROR
  • ISEVEN
  • ISLOGICAL
  • ISNA
  • ISNONTEXT
  • ISNUMBER
  • ISODD
  • ISOWEEKNUM
  • ISTEXT
  • LARGE
  • LEFT
  • LEN
  • LN
  • LOG
  • LOG10
  • LOOKUP
  • LOWER
  • MATCH
  • MAX
  • MAXA
  • MEDIAN
  • MID
  • MIN
  • MINA
  • MINUTE
  • MOD
  • MONTH
  • N
  • NA
  • NETWORKDAYS*
  • NOT
  • NOW
  • OFFSET
  • OR
  • PI
  • POWER
  • PRODUCT
  • PROPER
  • QUOTIENT
  • RAND
  • RANDBETWEEN
  • REPLACE
  • REPT
  • RIGHT
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • ROWS
  • SECOND
  • SIGN
  • SIN
  • SINH
  • SMALL
  • SQRT
  • SQRTPI
  • STDEV
  • STDEV.P
  • STDEV.S
  • STDEVP
  • SUBSTITUTE
  • SUBTOTAL
  • SUM
  • SUMIF
  • SUMIFS
  • SUMPRODUCT
  • SUMSQ
  • T
  • TAN
  • TANH
  • TEXT
  • TIME
  • TODAY
  • TRUE
  • TRUNC
  • UPPER
  • VAR
  • VARP
  • VLOOKUP
  • WEEKDAY
  • WEEKNUM
  • WORKDAY
  • YEAR
  • YEARFRAC

 * Supported in version 2017 R2 and newer

Function and Report Limitations

Currently, there are some features that are not available for use with the Jet Web Portal.

 

The following data sources are not supported in the Jet Web Portal:

  • Dynamics NAV 2009 and earlier (C/Front)

 

Some function arguments are required to be constant.  This means that they must be either hard-coded in the formula or be absolute cell references to cells that are not a Report Options.  These include:

Function Arguments that must be constant:
NL
  • What
  • FilterField
NF
  • Field
  • FlowFilterField
NP
  • What
  • Formula (must be a text string in the function)
GL (Dynamics NAV)
  • What
  • View
  • Exclude Close
GL (Dynamics GP)
  • Where
  • What
  • Include Unposted

 

Supported Examples:

  
{constant - supported}


{hard-coded cell reference - supported}

 

Unsupported Example:


{cell references to report Options - not supported}

 

The following functions and report features are not currently supported in the Jet Web Portal:

  • NL(Picture)
  • NP(Slicer)
  • Dashboard Mode (i.e., Auto+Hide+Values+Dashboard)
  • ShowQuery=
  • Stored Viewer Data
  • Drilldown
  • External workbook connections (e.g. OLAP Pivot Tables) cannot be refreshed from Excel online.
  • Use of the VALID keyword with the Report Options feature
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments