I am using CR XI r2.

I have created an SQL database for my users into which they enter chemical MSDS data.  There are various governmental reporting requirements that may or may not be required for each chemical.  I have set up an entry screen in MS Access to allow them to enter the chemical details and select which reporting requirements apply to that chemical.  The reporting requirements are check boxes which result in a 'True' entry in that specific column in the database if the box is checked; otherwise the default is 'False'.  Some chemicals may have more than one reporting requirement checked.  There are currently 16 different reporting requirements which may increase or decrease as government regulations change from year to year.

I now need to write a report to pull the chemicals based on which reporting requirement is checked.  I want a drop-down parameter of the 16 reporting requirements from which my users can select so that the report pulls only the chemicals which have 'True' for the selected reporting requirement.

How can I go about achieving this?

DBlank,

I want one drop-down list parameter from which the user can select one reporting requirement.  The report will then extract all chemicals from the database which have 'True' set for that single reporting requirement regardless of the T/F state of any of the other 15 requirements.

For example:

Chemical A requires reporting for FDA, OSHA, and CA Prop 65.
Chemical B requires reporting for CA Prop 65, Tier II and the Dudd-Skank Act.
Chemical C requires reporting for OSHA, and CA Prop 65.

The user wants to run the report to select ONLY the chemicals that require CA Prop 65 reporting.

Since the db has True/False for the values in the table for the individual reporting requirements, I am unsure how to give the users a drop-down list with the requirements and have CR know which column to look in for 'True' instances.

DBlank,

That did the trick!  Thank you so much!