Hi, if I have a stored procedure that could return either a number or rows or no rows for a given report parameter, but if the stored proc returns no rows can I update the textbox to show either "No rows found" or with the data returned from the stored procedure.
I don't think I can use the IsNull because there are no rows returned for this particular report parameter. When in the textbox I have =Fields.ColumnName I get an error saying "index is out of range" when no rows are returned, otherwise if data is returned it shows the field ok. Is there a solution for this ?
Thanks a lot,
Pete.
I don't think I can use the IsNull because there are no rows returned for this particular report parameter. When in the textbox I have =Fields.ColumnName I get an error saying "index is out of range" when no rows are returned, otherwise if data is returned it shows the field ok. Is there a solution for this ?
Thanks a lot,
Pete.