Off Topic Post - Reporting Services Question

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 ************
[
[*******************************************************]

sloan
Mon Jul 14 10:52:05 CDT 2008

I'll have to go with a more generic example.

Let's say you have :

Employee
Department

and a rule that says each employee can be in more than 1 department. Most
times an employee is only in 1 deparment., but he/she could be in more than
1.

To minimize the dataset size, I would have this.

Employee
Department
EmployeeToDepartment


Then I would populate the employee table. I'd populate the Department
table. I'd populate the relationship table.


Dont' forget about the DataSet.Merge method. It is good for
N tables into 1 dataset.
Different rows into 1 table.

It is NOT good at different columns going into the same row.





"Rain" <me@myplace.com> wrote in message
news:e2HPTdM5IHA.3420@TK2MSFTNGP05.phx.gbl...
> 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 ************
> [
> [*******************************************************]
>
>
>