Multi-select fields for a report

[scoobyroo]

I need to write a report that looks for any missing clinet/matter fields. They want the ability to choose to run it on many fields. They want a check box on the front end to choose the fields they want.

They want attorney information and they want to be able to choose whether a client is missing a bill address, category, class, and if any of the matters under the client are missing a work type. Each of these items sits in a separate table.

My question is what is the best approach to something like this?

 

[markros]

To me this sounds like you need a conditional stored procedure to get the data depending on passed parameters.