Finding Query from report designer

Finding Query from report designer

Problem Statement

Finding Query from report designer

Product Version

iVend 6.6

Proposed Solution

To find the query for the report, we need to import the report in report designer. We have couple of steps below so that we can fetch the query for the report.

 Steps to be Performed 

  1. Go to Report Manager and export any report .  


2. Export the report in .irt file and save it.

3. Go to Report Designer and import the report.




4. Go to Page and click in Panel.

5. Go to Panel > Properties and click on it.

 



6. Go to iVend Connection [MS SQL] and right click and edit it.

7. Copy SQL Query and use for analysis.





    • Related Articles

    • Configure the paper cut from Report Designer (.irt report)

      Product version: iVend 6.6 7989 with SAPB1. Problem statement: What is the correct process to configure the paper cut from Report Designer on an Epson TM-T88V printer Proposed Solution/Workaround: There is no cut command is not possible in .irt ...

    • iVend POS - Report with Sub-Report

      Report with Sub-Report The following are the steps to create a Report displaying the Sub-Report data: On the report Designer right clock on the iVend Connection under the Data source. Then click on New Data Source Figure 1 Report Designer Click on ...

    • iVend POS - Report with Parameters

      Report with Parameters This article provides the basic steps for creating a Report with Parameters. Create a report or open an already created one. Click on Dictionary. Figure 1 Report Designer Click on Data Sources and select New Data Source Figure ...

    • Query to verify Sales Transaction by Store report (Refund included)

      ************************************Internal to Citixsys**************************************** Problem Statement SQL Query to verify results of default iVend report "Sales Transaction by Store report (Refund included) " Solution Below query can be ...

    • iVend Retail - Report Timeout

      iVend Retail – iVend Report (Designer) Timeout Follow the steps mentioned below to set the timeout property in iVend Report Designer: 1. Open the Management Console, go to: Reports > Designer/Label > Report Designer Figure 1 Report Designer 2. Open ...