Please correct if i am wrong. both select statements returns same number of fields and the names of the fields are also the same but the no of records would be different from both selected statemets. if this is the case i really think it is some issue with the parameter value being checked. try returning the condition output from the SP. because SSRS doesnt do anything in SP execution logic.