How to Add New Dataset in Existing Report

If User wants to add some column in iVend existing report, then follow below step:

Export the report and open the Report in Report Designer.

Add new dataset as per required column, E.g. in this tutorial I have added Vendor table and use vendor name in “SalesByItem” report.

Go to iVend Connection-> Add New DataSource-> Add table. See Screen1

Now make relation in between 2 DataSource and use the columns on report.

Select first data source and go to New Item-> New Relation-> Select new Data source from “Parent DataSource” & mapped all key values with each other. See screen 2

Now after click on Ok see the relation will be shown in first DataSource which is already exist in report.

Now add the required column from the relation.