Parameter with Value, or Null or empty sting.
Posted on 2013-05-17
I have a question regarding parameter that could have value or Null value or empty string “” value.
For example I have report with four fields: field1,field2,field3,field4.
For every field I have parmeter Par1,Par2,Par3,Par4.
I understand that parameter is filter applied in selection criteria against a field.
Records will be selected based on value or values of the parameter or parameters for the field or fields.
Sometimes user asks for option to have specific values, multiple values or All values option for particular parameter.
I am ok with that situation and I know how to provide it and what this selection will bring back.
However I was not sure about situation when there are scenario that in the same filed could be values and could be null values too and user ask selection on this way to be done:
You have parameter e.g. Par3 for that field3. In report as I mentioned you have other fields with their parameters.
You select other fields based on their parameter values and you came to the Par3 you select value and for example there is no value-match for that filed it means complete record will not be pulled out, does not matter that other fields have value.
Lot of times customer wants and asks to pull out that record out and show empty field in our case field3 that Par3 was filtering and hit Null or empty string.
I never was sure how to provide it.