Off Topic Post - Reporting Services Question

  • Thread starter Thread starter Rain
  • Start date Start date
R

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 ************
[
[*******************************************************]
 
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.
 
Back
Top