Error message returned if report produces no rows.
This is the message: An error occurred during local report processing. An error has occurred during local report processing. Cannot read the next data row for the dataset ReportQuery. Divide by zero error encountered. I would like something that looks a bit nicer, like a message that just says "no data found", for example. How would I do that?
December 27th, 2011 1:19pm

normally, this message will not be displayed if there are no records. you need to accomplish two things: 1. under the tablix properties, set the message for the property "NoRowsMessage" 2. Check your report to see if there are any divisions using a column from dataset. There, use a conditional clause like =Iif(IsNothing(Fields!MiddleInitial.Value),1,Fields!MiddleInitial.Value) replace the field MiddleInitial with your field name
Free Windows Admin Tool Kit Click here and download it now
December 27th, 2011 1:25pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics