Off Topic Question - Reporting Services

[Rain]

Hi Guys,

I know this is off topic, so please bear with me on this. The reporting
services newsgroup is not really being used, so I thought I would try this
group on the offchance somone might be able to help, if not then so be it.


I am trying to create an invoice report. Essentially, there are two datasets
in use, the invoice set itself, with the main fields such as invoice number,
invoice items etc and the dsCustomer which contains the customer addresses.

I have the invoice details fine, but I want to be able to extract the
customer address details from the dsCustomer for each invoice in the
invoiceDetaisl Data Region and I cant work out how to do this. How can I
fill/filter/lookup List 1's fields
based on the customerID in List 2. Yeah, I could make one huge Datasetwith
all the details repeated a billion times, but there has to be an intelligent
way to do this. Am I just making life difficult for myself ? A different
approach ?

Any help is appreciated ! - Thanks

[***************** List1 - dsCustomer *******************]
[ CustomerID
[ CustomerAddress
[******************************************************]

[**************** List2 - dsInvoice ************************]
[ CustomerID
[ InvoiceNumber
[ Invoice Date
[
[ *************** List 3 Invoice Details ************
[
[*******************************************************]