Show entire text list with checkboxes for each item 1

[Genepoz]

Two tables--EmployeeAttributes has codes for Attributes by Employee, Attributes has the list of Attributes:

Tables: EmployeeAttributes Attributes
Fields: AttributeCode---------AttributeCode
Employee AttributeName

Each page of the report is for 1 Employee, and I want to show ALL the possible choices from the Attributes table, then put a checkmark by those Attributes that match EmployeeAttributes.

So I created a textbox with a list of all the attributes, then put 2 checkboxes next to each one. The format goes like this:

Group 1 Employee [Firstname] [Lastname]
Detail a
[CheckedBox: If Attribute not= 'Blackberry' then suppress] [UncheckedBox: If Attribute='Blackberry' then suppress] [Textbox: Blackberry]
Detail b
[CheckedBox: If Attribute not= 'Cell Phone' then suppress] [UncheckedBox: If Attribute='Cell Phone' then suppress] [Textbox: 'Cell Phone']

This produces:

Checkedbox 'Blackberry'
Uncheckedbox 'Cell Phone'
Uncheckedbox 'Blackberry'
Checkedbox 'Cell Phone'

It should say:

Checkedbox 'Blackberry'
Checkedbox 'Cell Phone'

I've tried Suppress if Attribute=Previous(Attribute) but that doesn't work.

Thanks

 

[lbass]

The issue is that when the attribute is cell phone, it is not blackberry, and vice versa. I think you should add your text box in the group footer, and then set up formulas for each condition:

//{@blackberry}:
if attribute = blackberry then
1

Then in the group footer, use formulas like this (formatted to font = Wingdings) next to the appropriate item in the text list:

if maximum({@blackberry},{table.employee}) = 1 then
chr(254) else
chr(168)

-LB

 

[Genepoz]

Thanks, LBass. That worked great!

-Gene