Report chart via sql command

[Motorui]

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: 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

[Hack]

Where would you be running the query from?

[Motorui]

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.