Hi guys,
I have a task where i have to create ssrs report that shows all customer transactions assigned to the given customer.
In header i need to have information from accounts receivable -> all customers -> general tab : account, name, customer group, address, name of description, contact number/address and type.
So the datasources for headers will be:
CustGroup for accountNum and CustGroup
DirPartyTable for Name
LogisticsLocation for Description
LogisticsPostalAddress for Address
LogisticsElecontronicAddress for Locator(contact number) and type.
In lines i need to have information from accounts receivable -> all customers -> transactions : voucher, date amount, invoice, transaction type.
So the datasource for headers will be CustTrans for Voucher, TransDate, AmountMST, Invoice, TransType.
I've created 2 Temp tables one for header field second for lines fields, but now I have problem with creating Controller and DataProvider classes, I dont know which parameter should be included in Controller Method, and how build method that contains so many related tables. Please help.
