Good Morning,
I was able to accomplish this with some settings in SSRS, but struggling with a BAQ. We have a UD field that has several different values and in some cases, that may be blank or null. We have a parameter set, but would like to have the option to return all rows. I’ve been able to remove the mandatory requirement, but now it just returns the blank values if I leave the parameter blank. Is there a way to include all and null values in a BAQ?
Thanks in advance,
Eric
Add an aditional where clause…
Where X = Param
OR
X= (null, ‘’)
Jose,
Thanks for this, but I’m still having some issues. May be because it’s using a calculated field to fill the data and a case statement pulling the UD field info from OrderDtl.udfield if Jobfirm = ‘0’ and from JobHead.udfield if not. I tried adding to the case statement when either is blank, but getting some varied results, none of which I am looking for.
If I simply add the where clause on the criteria, at most I am getting the udfield and blanks and not all. Any other thoughts? Need more info?
Eric
I’ll need a better example of what you are trying to do.
