mssql reporting services

  • Thread starter Thread starter DavidT
  • Start date Start date
D

DavidT

how can I create a order list for a company in reporting services. It is
straight forward how to create the dataset and create the items on the order
but how do I get the companies address details from another table to appear
in the header. that is to say the company details appear once in the top
header ( not the table header) and the many line items appear in the body.

many thanks
davidT
 
DavidT,

If you do a join in the query, so each row contains the company details, as
well as the order details, you can add a group to the table, so the group
header displays the company details, and the grouping details section
displays all the orders associated with that company.

Mark
 
Back
Top