SQLTeam.com | Weblogs | Forums

RDLC in C# with multiple datasets


#1

Hi all. Sorry if this is the wrong place to post this.

I am using RDLC reporting and the dataset is being retrieved from SQL through a webservice. I then get the data I need and put it into a POCO (Plain Old CLR Object).

Imagine the following:

a customer has invoices.
there will be many customers.

pretty simple.

So, I have a customer object and with in it a collection of Invoices.

I need a report to be able to display the customer information (I have this in DataSet1).
Then for that row, I want to display the invoices for that customer.

how can I do this in RDLC in terms of creating the layout and telling it to use the collection of "Invoices" in the current customer record for the given dataset?