Excel Reports

In the past if we needed a report to be in excel we simply added &dataformat=excel to the end of the URL.

Now in 9.5 if we do that here is what I get.

Orion Website Error

An error has occurred with the Orion website.

Additional Information

System.NullReferenceException: Object reference not set to an instance of an object.   at Orion_Report.SendReport(OrionReportFormatter formatter, String contentType, String fileExtension)   at Orion_Report.Page_Load(Object sender, EventArgs e)   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(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 includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Any thoughts?

Find more posts tagged with

excel

report

Accepted answers

mdriskell

I just tested and this is fixed in 9.5 SP2.

Thanks Mean Joe

All comments

Karlo.Zatylny

Hi,

I have duplicated this and will log it in our bug tracking system. Please open a support ticket and reference this thwack thread if you would like track this issue with support.

Thanks

jtimes

isn't it supposed to be this:

&dataformat=xls

mdriskell

If it is that doesn't work either. I checked my older (pre 9.5) links and I had them hardcoded to &dataformat=excel and that worked prior to the upgrade.

Karlo.Zatylny

When I was confirming the bug, I tried "excel", "xls", and "excell" - all of which do the same thing. We also support options like "csv", "text", "xml", and others that I tested. All but the default html option were broken in my testing.

Thanks

mdriskell

When I was confirming the bug, I tried "excel", "xls", and "excell" - all of which do the same thing. We also support options like "csv", "text", "xml", and others that I tested. All but the default html option were broken in my testing.
Thanks

Since you have confirmed the bug, do I need to open a case or will this most likely just be handled in a hotfix or SP?

ElisabethZakes

Does the solution in this post work for you?

mdriskell

In any version other than 9.5 yes, they were doing the same thing I reported as broken with 9.5.

Karlo.Zatylny

This change did not make it in to SP1. Sorry.

mdriskell

I just tested and this is fixed in 9.5 SP2.

Thanks Mean Joe