Reports in Netpoint 5.9.2

[Former Member]

When trying to run any of the reports in the commerce section i get the following error:

Version 5.9.2.15986

Message Object reference not set to an instance of an object.

Source NetPoint.API

Stack at netpoint.api.reports.ReportTemplate.ExtractGraphs(ArrayList finalParameters)

at netpoint.api.reports.ReportTemplate..ctor(String body, String reportCode, String virtualPath, String connstring, ArrayList finalParameters)

at netpoint.api.reports.Report.Publish(String stylesheet, String virtualpath)

at netpoint.admin.common.reports.ReportView.Page_Load(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBefore

Our technical people have been notified.

We're sorry for the inconvenience.

I want to buil dsome new reports and wanted to use the existing ones but can't get them to work,

Regards,

Dominik

[Former Member · Accepted solution]

Hi Dominik,

There was a version that shipped with broken report data.

I am not sure if 5.9.2 was that version, but you can try running this query and see if it helps

update reportgraph

set querycode = reportquery.querycode

from report

inner join reportquery on reportquery.reportcode = report.reportcode

where reportgraph.reportcode = report.reportcode