How to Add New Dataset in Existing Report

How to Add New Dataset in Existing Report

How to Add New Dataset in Existing Report

 

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

  1. Export the report and open the Report in Report Designer.

 

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

 

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



    • Related Articles

    • How to Add Bookmark in Report

      How to Add Bookmark in Report. Bookmarks are shortcut that redirect to specific group using in report. To use bookmark in iVend report follow the below steps: Open a new report and create a data-source, and create a relation in between 2 tables. ...

    • Steps to add a new warehouse in Magento

      ******************** Internal to CitiXsys************************** Requirement Sometime customer may ask to add a new Warehouse (which is already present in ERP and iVend) in Magento to see the stock. Steps Below are the steps to add a new warehouse ...

    • How to Add Mouse over Line Selection in Report

      How to Add Mouse over Line Selection in Report. If report have multiple lines then user have face problem to point the selected line. If reporting tool have option to point the selection that is very good way to highlight the selected line. To use ...

    • iVend POS - Report with Groups

      Report with Groups This article explains the steps required for creating a Report with Groups. 1. Create a report or open an existing one. For example, we can take a simple list report that was created in the separate article called, "Simple List ...

    • MC - Customize existing MC screen

      Introduction iVend Add-on Framework is used for writing Custom Business Logic independently by a programmer. iVend Addon allows to extend business logic either in Management Console or at the Terminal POS.The addon framework allows deployment of ...