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