I get this message when I attampt to preview a report. I looked for something similar in the forum but cannot find.

Unhandled Exception:
The following error occurred when the script in procedure Detail1.OnBeforePrint:
Object reference not set to an instance of an object.
Procedure Detail1.OnBeforePrint was executed, it will not be called again.

System.Exception

Stack Trace:
   at DevExpress.XtraReports.Design.ReportTabControl.UpdatePreview()
   at DevExpress.XtraReports.Design.ReportTabControl.OnSelectedPageChanged(EventArgs e)
   at DevExpress.XtraReports.Design.XtraTabControl.SelectTabButton(TabButton tabButton)
   at DevExpress.XtraReports.Design.ReportTabControl.SelectTabButton(TabButton tabButton)
   at DevExpress.XtraReports.Design.XtraTabControl.OnButtonClick(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Label.WndProc(Message& m)
   at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
*** The following error occurred when the script in procedure Detail1.OnBeforePrint:
Object reference not set to an instance of an object.
Procedure Detail1.OnBeforePrint was executed, it will not be called again.
   at DevExpress.XtraReports.Design.ReportTabControl.UpdatePreview()
   at DevExpress.XtraReports.Design.ReportTabControl.OnSelectedPageChanged(EventArgs e)
   at DevExpress.XtraReports.Design.XtraTabControl.SelectTabButton(TabButton tabButton)
   at DevExpress.XtraReports.Design.ReportTabControl.SelectTabButton(TabButton tabButton)
   at DevExpress.XtraReports.Design.XtraTabControl.OnButtonClick(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Label.WndProc(Message& m)
   at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
*** Exception has been thrown by the target of an invocation.
   at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
   at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean verifyAccess)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
   at DevExpress.XtraReports.ScriptManager.Run(String procedureName, Object[] parameters)
   at DevExpress.XtraReports.XRControlEventsScriptManager.RunEvent(String eventName, Object[] parameters)
*** Object reference not set to an instance of an object.
   at YYYY.XXXX.Detail1OnBeforePrint(Object sender, PrintEventArgs e)

Please provide what report template from what navigation pane, grid, screen

Thank you

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

It is in the Services, Completed WorkOrder Colorful Pane

Do you mean in the Service navigation pane, viewing the Service Workorders grid, selecting the report template Completed Workorder Service Detailed - Colourful?

Are you print previewing - or do you mean you are holding down the SHIFT key while selecting the report template to access the internal report designer for this report that the error posted above occurs?

Does this error occur performing the same steps you did for the report template Completed Workorder Service Detailed - Colourful? if you select other reports - for example, does this occur selecting Detailed Complete Service Workorder with Grand Total, ?

Does this same message occur or not occur with other report templates from this grid? Please identify which do and do not

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Yes

Are you print previewing - or do you mean you are holding down the SHIFT key while selecting the report template to access the internal report designer for this report that the error posted above occurs?

Holding down shift Key

Does this error occur performing the same steps you did for the report template Completed Workorder Service Detailed - Colourful? if you select other reports - for example, does this occur selecting Detailed Complete Service Workorder with Grand Total, ?

It does not happen when I tag "Service Workorders Invoiced"

It does happen when I tag "Completed Workorder Service Detailed"

It does happen when I tag "Completed Workorder Service Detailed - Colorful"

It does happen when I tag "Detailed Completed Service Workordernwith Grand Total"

It does not with "Dispatching Report - Scheduled User and Tasks"

It does not with "Dispatching Report - Scheduled User and Tasks w WO# and Client for every printed workorder item"

It does not with "Summary Billable Per Service Workorder"

It does not with "Preview Billing"

Does this same message occur or not occur with other report templates from this grid? Please identify which do and do not

See above

From your report template list, it appears to be occurring with some detailed report templates, but not all.

Does this message occur on every computer that has the AyaNova program files local?

I understand you have the AyaNova program files on three different computers - two on local network and one via a DataPortal? Please check each and identify if occurs on all three.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

I would like to log in via your Data Portal to your live AyaNova data to determine if it occurs using the AyaNova program files I have here,  select SHIFT and one of those report templates listed that result in the same exact error for all.

If it also occurs for myself, that will help identify if it is something specific to your database.

If it doesn't occur for myself, than that would indicate something with the program files or installation used on all three computers.

I have a copy of your Data Portal connection string - can I log in?

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com