MLCollins


Hello. I'm getting an error - "Object reference not set to an instance of an object" when running an SSRS report with graphs. It only happens when the returned dataset is empty (based on parameters set by the user, it is possible to return no rows). I've tried using the NoRows property (I entered "No Data" in the property box), but I still get the same error. Is there another way to account for an empty dataset in charts

Thanks,
Marianne




Re: Object reference not set...

MLCollins


Any ideas or suggestions

Thanks,

Marianne






Re: Object reference not set...

GregSQL

Have you tried using IsNothing() in the expressions for your axis values

Something like =IIF(IsNull(Fields!Xaxis.Value), 0, Fields!Xaxis.Value)







Re: Object reference not set...

MLCollins

I just tried

=iif(isnothing(Fields!BookingDateID.Value),0,Fields!BookingDateID.Value) --> X-Axis;

=iif(isnothing(Fields!TNOWSubSourceID.Value),0,Fields!TNOWSubSourceID.Value) --> Y-Axis

and got the same error :-(

Thanks,

marianne