Report and Query Design

Hi all - have finally got reporting services working and am wondering how I would go about designing an order form. I have 2 tables - order and orderline.

Would it be best to design a query which got all information in one retrievale (so that orderid is repeated on each record retrieved) or 2 seperate queries and therefore use a subreport - the main report having the order details and the subreport containing all the orderlines.

Thanks in advance,

Stephen.

The best way to do this by using subReport or drillthrough report where you get the main data in the first report and each row will navigate to the sub report and get the detials fro great start and sample

please read this is article it also contains great sample

http://www.gotreportviewer.com/