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><?xml version="1.0" encoding="utf-16"?><cCustomReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><sReportName>C:\BEpoz\Web\ProductTable.CSV</sReportName><sSQL>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'
</sSQL><oColumnDefs><dictionary /></oColumnDefs></cCustomReport></sViewXML>
</cViews>