December 1, 2021 at 10:05 pm
I have a parameter in my report labeled as PaySource. PaySource has 3 values associated to it, a Value of 0 = "Total", 1 = "Patient" and 2 = "Insurance".
In my report, I have 3 columns - Patient, Insurance, and Total. I need help with my Column Visibility Expression on each of these columns.
If selecting "Patient" in the PaySource Parameter, I need to hide the Insurance and Total Columns and only display Patient.
If selecting "Insurance" in the PaySource Parameter, I need to hide the Patient and Total Columns and only display Insurance.
If selecting "Total" in need all 3 columns to display.
December 2, 2021 at 10:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 2, 2021 at 11:24 pm
I recommend creating a matrix (e.g., in a spreadsheet) for yourself when working with such problems so that you can visualize the options that result in true:
PARAMETER VISIBLE?
PaySource Patient Insurance Total
0 (Total) TRUE TRUE TRUE
1 (Patient) TRUE FALSE FALSE
2 (Insurance) FALSE TRUE FALSE
So, expressions would be something like:
Patient:
Patient: =(Parameters!PaySource.Value=0) OR (Parameters!PaySource.Value=1)
Insurance:
=(Parameters!PaySource.Value=0) OR (Parameters!PaySource.Value=2)
Total:
=Parameters!PaySource.Value=0
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply