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

Christoph Reiche

October 10, 2018 13:48

Answered

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.

Date Votes

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.

Permalink
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.

Permalink
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.

Permalink
0

Harry Lewis October 15, 2018 14:07

Glad they were of assistance.

I marked the post for you..

Permalink

Please sign in to leave a comment.