0

Jet.Shared.JetReports Exception error

Jet Reports Historic Posts

October 19, 2015 07:21

None

Follow

Hi all,

I get this error message evaluating a formula: 'Exception of type 'Jet Shared.Jet Reports Exception' was thrown'.
What does it mean, and how do I fix it?
No results are shown for this formula.

Willem

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts October 23, 2015 22:24

  Hi Willem -
  
  Does this happen with every formula you attempt to enter or with a specific formula?

• 0
  
  John Kleb July 31, 2019 20:43

  I am receiving this error too.  With a nested filter statement that looks for a custom field in the G/L Account table.

  =nl(

  "Sum"

  ,"G/L Entry"

  ,"Amount"

  ,"G/L Account No.",NL("Filter","G/L Account No.","No.","G/L Report Level",$A10)

  ,"Global Dimension 1 Code","*"

  ,"Global Dimension 2 Code"

  ,TeamFilter,"Shortcut Dimension 3","*"

  ,"Posting Date",NP("DateFilter",StartDate,EndDate))

  

• 0
  
  Harry Lewis July 31, 2019 22:01

  Hi John -

  Here are a few suggestions:

  - There is no table named "G/L Account No."    You'll want to change that table name in your NL(Filter) function

  - In a Jet Report, column A is reserved for Jet Reports' usage.  You should not be using it to store anything else (or reference anything that is in that column.  You'll want to introduce a new column (probably column B) and store whatever now is in A10 in that new column.

  - I assume that "G/L Report Level" is a custom field in your database (my sample CRONUS DB does not have that field)

  Once I made adjustments for these points (and removed "Shortcut Dimension 3" which my database does not have), the function did not return an error (I'm running version 20).

  If you continue to have an issue, I would suggest submitting a support request.