Custom Reports
      Back to home
      1. INTERNAL - Bepoz Help Guides
      2. End-User | Reporting, Data Analysis & Security
      3. Custom Reports

      72 | WEBXPORT (Custom Report)

      This article demonstrates an example of a Custom WEBXPORT Report. Disclaimer: This report may need modifications or alterations base on each system setup and configuration.

      This article demonstrates an example of a Custom WEBXPORT Report.
       

      Disclaimer:

      This report may need modifications or alterations base on each system setup and configuration.

      Report Query:

       

      <?xml version="1.0" encoding="utf-8"?>

      <cViews xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

        <iListType>25</iListType>

        <dtDateUpdated>2013-01-24T16:29:18</dtDateUpdated>

        <iOperatorID>0</iOperatorID>

        <sName>WEBXPORT</sName>

        <sViewXML>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cCustomReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sReportName&gt;C:\BEpoz\Web\ProductTable.CSV&lt;/sReportName&gt;&lt;sSQL&gt;SELECT     CONVERT(VARCHAR(10), GETDATE(), 101) AS Date, Venue.ExportCode_1 AS VenueID, Store.ExportCode_1 AS OutletID, Product_1.ProductID AS ProductID, 

                            Product_1.Name AS ProductName, Comment.Comment, ProdStore.Price1EachSize_1 AS Price, Prodstore.QtyonHand, Product_1.ExportCode_1 AS Type, Product_1.ProdSort AS Category, 

                            Condiment.CondimentProdID, Product.Name AS Condiment, Condiment.SequenceNum - 1 AS CondSequence

      FROM         Condiment RIGHT OUTER JOIN

                            Product ON Condiment.CondimentProdID = Product.ProductID RIGHT OUTER JOIN

                            Product AS Product_1 ON Condiment.BaseProductID = Product_1.ProductID LEFT OUTER JOIN

                            ProdStore ON Product_1.ProductID = ProdStore.ProductID LEFT OUTER JOIN

                            Store ON ProdStore.StoreID = Store.StoreID LEFT OUTER JOIN

                            Venue ON Store.VenueID = Venue.VenueID LEFT OUTER JOIN

                            Comment ON Product_1.CommentId = Comment.CommentID

                            where product_1.exportcode_1 = 'Order' or product_1.ExportCode_1 = 'Catering'

       

      &lt;/sSQL&gt;&lt;oColumnDefs&gt;&lt;dictionary /&gt;&lt;/oColumnDefs&gt;&lt;/cCustomReport&gt;</sViewXML>

      </cViews>

       

       

       

       

      Other Parameter Settings:

      This file needs to be saved as a *.REP file using a document editor