Printing Statistics

Question

Conceptually what is the best way to create a report with a bunch of SQL statistics. I have 12-20 different counts I will pull from SQL all individual Count statements and I want to put the numbers on a report. Each count is for different tables and different where statements. Is it best to create a DataSet with 20 DataTables in it each returning a single result?. If I was doing a form I would probably do a bunch of executescalar commands. Thanks.

evan liewer · Answer

in a windows form i did a bunch of execute scalar commands and stored them each as intergers. Then i manually created a dgv and placed the values in them and then printed the dgv. In the end I am very happy with the result.