List box to check fields

[#1]

Hi All!

I need to create a list box that refers to particular fields. By making selection over there report(s) should be filtered to have only those records where particular values exist in corresponding fields.

For example,

Source data comes with separate fields for each kind of treatment A, B, C. Each treatment have many different values. Null and '0' means invalid or unknown. A user is interested to know if particular treatment was given and doesn't care what exactly was it.

Treatment
A
B
C
Fact
F1	A	B	C
ID4		4	0
ID1	0	0	1
ID3	0	56	0
ID2	1	3	6
ID5	2	1	2

So, when he chose a treatment 'A' from a list box 'Treatment' we should show (count, apply other logic) records from 'Fact' table where there are not Null and not '0' values in the field 'A'. That will be records with ID2 and ID5.  If a user chooses all three values from a list box, all records will be displayed (considered) as they all have either one or another treatment.

How it might be achieved?

I tried creating a concatenated string to refer to a particular treatment if it was performed. But now I don't know how to make a trigger (use variables) to search if any element in GetFieldSelections('Treatment', ',') exists in that field?

My new string could be [A, , ,], [, , B, C], [ , , ,]  and so on.

I greatly appreciate any help!

Thank you!

[iktrayanov · Accepted solution]

Try using crosstable.

[MK_QSL]

Like this?

[#4]

Ivan, Manish,

Thank you! Crosstable is a solution here. And simple