I am creating a report, and the data that i have is coming down in one column. I have been asked to divide the data into 2 columns to save space in the report. Below is the example of the data that i have:
| Illnesses |
|---|
| Allergies |
| Cancer |
| High Cholesterol |
| Hypertension |
| Other: Testing |
I need it to be like:
| Illnesses | Illnesses |
|---|---|
| Allergies | Cancer |
| High Cholesterol | Hypertension |
| Other: Testing |
This is the expression i found and used the data box in the report:
=iif(RunningValue(Fields!Illness.Value, CountDistinct, "MajorIllnesses") Mod 2 = 0, True, False)
=iif(RunningValue(Fields!Illness.Value, CountDistinct, "MajorIllnesses") Mod 2 = 1, True, False)
So i am getting data into 2 columns, but it is just giving me:
| Illnesses | Illnesses |
|---|---|
| True | False |
| False | True |
| True |