Wednesday, January 1, 2014

Two report parameter with or condition /either should be selected

It depends on how you've written logic in backend code


based on your explanation i think what you're looking is this


in the dataset filter tab use like




=Fields!YourField1.value =IIF(Len(Parameters!Parameter1.value) =0,Fields!YourField1.value,Parameters!Parameter1.value)
=Fields!YourField2.value =IIF(Len(Parameters!Parameter2.value) =0,Fields!YourField2.value,Parameters!Parameter2.value)



This will make sure the parameter will get bypassed for the case where parameter value is NULL and you'll get all values from the list back in output




Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs



No comments:

Post a Comment