Good afternoon,
I am trying to add a new data source to the SalesInvoice report by extending the DP. When I go to add it as a data source in the SSRS report definition, it doesn't list my new table, only the standard tables in the DP itself. Here is what I have done so far:
- Created new temp table "bbsSalesInvoiceBankAccountTmp", table type set to In Memory. Added appropriate fields. Build and full db sync.
- Created an extension of the Data Provider class (code below):
- Duplicate SSRS report, add a new data source, set to Data Source Type Report Data Provider
- In the query box, set the Data Provider to SalesInvoiceDP. It then brings up the Select Fields screen with the standard 6 tables visible.
[ExtensionOf(classstr(SalesInvoiceDP))]
final class SalesInvoiceDP_bbsOutputDocuments_Extension
{
public bbsSalesInvoiceBankAccountTmp bbsSalesInvoiceBankAccountTmp;
public void generateInvoiceRelatedInformation(CustInvoiceJour _custInvoiceJour)
{
next generateInvoiceRelatedInformation(_custInvoiceJour);
this.insertIntobbsSalesInvoiceAddressTmp();
}
protected void insertIntobbsSalesInvoiceAddressTmp(){
}
}
Is anyone able to assist please. Thanks in advance.
