Hi, I've got a sqldataadapter that retrieves a field from a stored procedure for a given report parameter and populates a textbox with this value that works fine, but if I enter a value in the report parameter that hasn't got a row in the database and returns 0 rows in the stored procedure I get the error "An error has occured while processing textbox "Textbox1", index was out of range, must be non negative and less than the size of the collection."
Is there a way of checking for returned rows in the expression, and if empty put in a default value.
Thanks a lot.
Is there a way of checking for returned rows in the expression, and if empty put in a default value.
Thanks a lot.