Reports..Help needed

[Anna]

Hi,

I have a field for "job location" which is drop down. So here I can create a
report based on the criteria. Like when user click report for the job
location..pop-up window will appear so that user can enter job location
keyword and it will create its own report for that location. So..this is
possible with the drop down field.

Can we do the same thing..(based on query/criteria) for check boxes field.
Because I have check boxes for education and want to create same kind of
report so that user has flexibility create as per his/her own requirement.
I tried doing the same thing for check boxes but its not working for check
boxes. The check boxes I have in the table are Yes/No type. So in the table
data is
stored as check mark or blank. So when the criteria window pop-ups for one
check box what should be entered to get the query run. I tried entering Yes
or True..its not working.

Please help me. I would appreciate your help.

Thanks

 

[Kurt Monroe]

Anna,

I think the check box values are stored as either a "-1"(check) or a "0"
(not checked), not a check mark or a blank.

Hope this helps,

 

[Anna]

Hi Kurt,

Yeah you are right it takes -1 or 0. Can we change '-1' to 'Yes' and '0' to
'No' so that its easier for the user to enter 'Yes' or 'No' for that field in
the dialog box.

please let me know. Thanks