Object reference error in report for some users (2009)
SYMPTOMS:
A custom report works fine for some users but errors out for other users.
ERROR/WARNING MESSAGES:
Server Error in '/' Application.
Object reference not set to an instance of an object.
Stack Trace:
[Exception: Object reference not set to an instance of an object.]
Changepoint.Enterprise.ReportExecEngine.ReportDataSrv.LoadChartData() +1564
or
Tbl:DataBind>Operand data type void type is invalid for sum operator.
REASON:
This is related to missing access rights on UDF.
RESOLUTION:
Check for custom fields in your data collection that contain access restricted UDF and which are used in a grouped table or grouped chart.
Users running the report need to have view access to these UDF.