APEdit SSRS Report - Add Vendor Bank table

Kinetic ERP
1

Hi all,

I am creating a new version of the AP Edit List so that it will pull values from the Vendor Bank Table.
The Report Data Definition has been done but the tricky bit is now getting the table linked in the SSRS Report. The expression is very lengthy and am not sure where to do the join and which join it should be.

2

You not kidding that is a long sql statement. T7 is the last table so you are making T8 and it needs to be at the bottom below RcvDtl.

The join will be the same relationship you made in the RDD. Even though all vendors should have a bank I would still use an left outer join.

Here is a basic guide for adding to SSRS.

SSRS add new data fields to report.docx (358.0 KB)

3

Hi Greg,

I will have a bash at that and let you know how I get on.

Thanks

Alan