SSRS
-
Hi, I have created a report with three input parameters(OrdNum,InvoiceNum,PO), and i checked AllowBlankValue to allow blank input values. Any One of the input parameter must be given to get the order details. When i give the input for PO, i need to have a combination of one more input parameter(either OrderNum,InvoiceNum) along with PO. So i want to give a message like (Give one more input along with PO) when i give the value for PO alone, i mean i need to validate this input in the report itself. Is it possible? ex: IF (PO<>'' AND InvoiceNum='' AND OrdNum='') THEN "MSG: Give one more input along with PO" As of now i have given the above condition in the Stored procedure. It ll return Null rows. I have given the message in the NoRows property of table. I dont want let it go to the stored procedure and check that condition. I want to do it in the report itself. Please help me!