Report chart via sql command

hi all i need to create a chart report from sql querys but i dont have a clue in how to do it!

ex. i have a sql table were i neet to:

Code:

---

SELECT COUNT FROM LOAD.Q1 WERE Q1 = "YES"

---

and 10 more querys just like this one!
now i need to populate the report chart with tose querys

Where would you be running the query from?

i was thinking in the asp page where the report is located, and when it loads
but it could be in the report itself or in a parameter.
i dont know where is the best since im a litlle noob in this.