passing datasets as report source

[vishalsethia]

I have a complex query and i create a dataset which is inturn passed to Crystal report as the datasource.

But my query has some fields which are count(field name) and I'am not able to figure out how do i get those count fields on to my report
The toher fields such as product name, id are all displayed on the report

for eg.
select prod_id, Prod_name, prod_purchased, count(prod_id) as prod_sold , prod_purchased- count(prod_id) as prod_remaining from table1,table2,table3
......

i'am able to get prod_id, prod_name and the 3rd fld, but I'am not able to figure out , how do i get field 4 and 5 on the report

Any help will be greatly appreciated