Category
Report Builder
Product Version
7.2
Filtering on Boolean Values
Answered
Hi,
I want to filter a report on a boolean value but have the choice of true, false, or both. I have a column in a sales table that is called "primary admission" and a sale either includes "primary admission" or not. I'm doing summary numbers and I want the user to be able to choose to have "primary admission", "not primary admission", or both. What's the best way to do this?
Thanks,
The same question
Hi Dwayne,
It seems that the best way to do this will be to create a view level calculated field that converts this boolean to a string so that you can use an "IN LIST" filter type.
Does this sound like it will work in this case?
Regards,
Nathan
Hi Dwayne,
It seems that the best way to do this will be to create a view level calculated field that converts this boolean to a string so that you can use an "IN LIST" filter type.
Does this sound like it will work in this case?
Regards,
Nathan
Hi,
I tried Nathan's patch for a similar problem and it worked for me.
Thank you!
Lorenza
Hi,
I tried Nathan's patch for a similar problem and it worked for me.
Thank you!
Lorenza
Hi Lorenza,
Glad to hear it!
Dwayne,
I am going to close this case for now, but let me know if you have any questions or problems.
Regards,
Nathan
Hi Lorenza,
Glad to hear it!
Dwayne,
I am going to close this case for now, but let me know if you have any questions or problems.
Regards,
Nathan
Replies have been locked on this page!