Custom report with custom field

[joevplan]

Hi,

 

I'm making a custom report. This is what I need to have in this report:

 

- Client First Name, Last Name, Company, and value of custom field that he has.

 

- Display only clients that are Active and have Custom Field.

 

Is there anyone who can help me write the right query to retrieve this values from DB or tell me where I can look at something familiar that already been made?

 

Thank you.