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.
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?