|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
mssql reporting serviceshow 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 Show quote "DavidT" wrote: > 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 > > >  |
|||||||||||||||||||||||
Other interesting topics