sql server 2008 - Sql reports with BI Studio (BIDS) , I want one Entry per Page -

imagine have 10 categories. each categories have many products.
category
categoryid(pk)
categoryname
categorydescription

product
productid(pk)
categoryid(fk)
productname
productprice
productdescription
productnumber

i have 1 page per category.
on each page, want category name, category descripton. , in table, want product list.

how can perform ?.

thanks lot.

first need query gives information want. saved dataset within report. simple

select c.categoryname,    c.categorydescription,    p.productname,    p.productprice,    p.productdescription,    p.productnumber category c join product p on --insert join criteria here... c.categoryid = p.categoryid 

name dataset products.

next, drag table onto report. define dataset table dataset created above.

create group within table, based on category primary key (categoryname? categoryid?). order group categoryname (if want alphabetical order).

now in table can put category name & category description in group header of table. product information go in table detail rows.

this started. can options @ group level start new page @ beginning of each group. can put in running totals (sums, averages, etc) reset @ change in group.