0

Jet Web Portal NullReference Exception when running a report with Excel PV-Function

Christoph Reiche

October 10, 2018 13:48

Answered

Follow

Hello,

I created a report wich contains the Excel PV-Function. If I run this report directly in Excel everything works fine. Executing this via Jet Web Portal immediately throws the following exception:

Jet.Nimbus.Web, Version=19.0.18268.1, Culture=neutral, PublicKeyToken=062caa159426bac3
System.ArgumentNullException: Der Wert darf nicht NULL sein.
Parametername: workbookBytes
 bei Jet.Nimbus.Application.NimbusApplicationArgs..ctor(Int32 cultureLcid, String defaultDataSourceName, String defaultCompanyName, DataSourceSettings[] datasources, Byte[] workbookBytes, Guid reportId, Guid[] reportOptionIds, String pipeServerMachineName, Int32 pipeServerTimeout, Guid analyticsSessionId, Boolean analyticsCeipEnabled, String serviceHost, Int32 servicePort, Boolean isBudgetingLicensed)
 bei dd.p()
 bei dd.Run()

Is this a known behavior? Is there any workaround?

Tank you.

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Harry Lewis October 11, 2018 15:00

  Hello Chistoph -

  Excel's investment functions are not currently supported with the Jet Hub.

  If you feel that having this functionality would be beneficial to the Jet community, as a whole, I would encourage you to post a feature request on the Jet Ideas Portal by clicking Give Feedback on the right side of this window.

  

• 0
  
  Johannes Herlitzius October 11, 2018 15:12

  Hello Christoph,

  as an addition: If you want to know, which function is currently supported by the Jet Hub, then please have a look here:

  https://jetsupport.jetreports.com/hc/en-us/articles/219402987

   

  Let me know, if this helps.

  Best Regards.

• 0
  
  Christoph Reiche October 12, 2018 22:10

  Hello,

  Thanks to you both for the hints and information. This helps alot. How can I mark this post as answered?

  Regards.

• 0
  
  Harry Lewis October 15, 2018 14:07

  Glad they were of assistance.

  I marked the post for you..