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

      20 | HLM-RetailPrices (Custom Report)

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

      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-03-07T13:04:37</dtDateUpdated>

        <iOperatorID>0</iOperatorID>

        <sName>HLM</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;Retail Prices&lt;/sReportName&gt;&lt;sSQL&gt;SELECT     Product.ParentID, Product.Name, 

      CASE

      WHEN SalesSummaries.Size = 1 THEN Product.SizeName_1

      WHEN SalesSummaries.Size = 2 THEN Product.SizeName_2

      WHEN SalesSummaries.Size = 3 THEN Product.SizeName_3

      WHEN SalesSummaries.Size = 4 THEN Product.SizeName_4

      WHEN SalesSummaries.Size = 5 THEN Product.SizeName_5

      WHEN SalesSummaries.Size = 6 THEN Product.SizeName_6

      WHEN SalesSummaries.Size = 7 THEN Product.SizeName_7

      WHEN SalesSummaries.Size = 8 THEN Product.SizeName_8

      WHEN SalesSummaries.Size = 9 THEN Product.SizeName_9

      WHEN SalesSummaries.Size = 10 THEN Product.SizeName_10

       

      ELSE 'NULL' END as 'Size',

       

      CASE

      WHEN SalesSummaries.Size = 1 THEN Product.SizeQty_1 * ProdStore.CostLastEx

      WHEN SalesSummaries.Size = 2 THEN Product.SizeQty_2 * ProdStore.CostLastEx

      WHEN SalesSummaries.Size = 3 THEN Product.SizeQty_3 * ProdStore.CostLastEx

      WHEN SalesSummaries.Size = 4 THEN Product.SizeQty_4 * ProdStore.CostLastEx

      WHEN SalesSummaries.Size = 5 THEN Product.SizeQty_5 * ProdStore.CostLastEx

      WHEN SalesSummaries.Size = 6 THEN Product.SizeQty_6 * ProdStore.CostLastEx

      WHEN SalesSummaries.Size = 7 THEN Product.SizeQty_7 * ProdStore.CostLastEx

      WHEN SalesSummaries.Size = 8 THEN Product.SizeQty_8 * ProdStore.CostLastEx

      WHEN SalesSummaries.Size = 9 THEN Product.SizeQty_9 * ProdStore.CostLastEx

      WHEN SalesSummaries.Size = 10 THEN Product.SizeQty_10 * ProdStore.CostLastEx

       

      ELSE NULL END as 'Cost Ex',

       

      CASE

      WHEN SalesSummaries.Size = 1 THEN convert(decimal(10,2),ProdStore.Price1EachSize_1) /100

      WHEN SalesSummaries.Size = 2 THEN convert(decimal(10,2),ProdStore.Price1EachSize_2) /100

      WHEN SalesSummaries.Size = 3 THEN convert(decimal(10,2),ProdStore.Price1EachSize_3) /100

      WHEN SalesSummaries.Size = 4 THEN convert(decimal(10,2),ProdStore.Price1EachSize_4) /100

      WHEN SalesSummaries.Size = 5 THEN convert(decimal(10,2),ProdStore.Price1EachSize_5) /100

      WHEN SalesSummaries.Size = 6 THEN convert(decimal(10,2),ProdStore.Price1EachSize_6) /100

      WHEN SalesSummaries.Size = 7 THEN convert(decimal(10,2),ProdStore.Price1EachSize_7) /100

      WHEN SalesSummaries.Size = 8 THEN convert(decimal(10,2),ProdStore.Price1EachSize_8) /100

      WHEN SalesSummaries.Size = 9 THEN convert(decimal(10,2),ProdStore.Price1EachSize_9) /100

      WHEN SalesSummaries.Size = 10 THEN convert(decimal(10,2),ProdStore.Price1EachSize_10) /100

       

       

      ELSE NULL END as 'Retail Price Inc',

       

      CASE

       

       

      WHEN SalesSummaries.Size = 1 and Prodstore.SellTaxType = 1 THEN (((convert(decimal(10,2),(ProdStore.Price1EachSize_1) - (convert(decimal(10,2),(ProdStore.Price1EachSize_1)/11))) /100))  - (Product.SizeQty_1 * ProdStore.CostLastEx)) / NULLIF(((convert(decimal(10,2),(ProdStore.Price1EachSize_1) - (convert(decimal(10,2),(ProdStore.Price1EachSize_1)/11))) /100)),0) * 10000

      WHEN SalesSummaries.Size = 2 and Prodstore.SellTaxType = 1 THEN (((convert(decimal(10,2),(ProdStore.Price1EachSize_2) - (convert(decimal(10,2),(ProdStore.Price1EachSize_2)/11))) /100))  - (Product.SizeQty_2 * ProdStore.CostLastEx)) / NULLIF(((convert(decimal(10,2),(ProdStore.Price1EachSize_2) - (convert(decimal(10,2),(ProdStore.Price1EachSize_2)/11))) /100)),0) * 10000

      WHEN SalesSummaries.Size = 3 and Prodstore.SellTaxType = 1 THEN (((convert(decimal(10,2),(ProdStore.Price1EachSize_3) - (convert(decimal(10,2),(ProdStore.Price1EachSize_3)/11))) /100))  - (Product.SizeQty_3 * ProdStore.CostLastEx)) / NULLIF(((convert(decimal(10,2),(ProdStore.Price1EachSize_3) - (convert(decimal(10,2),(ProdStore.Price1EachSize_3)/11))) /100)),0) * 10000

      WHEN SalesSummaries.Size = 4 and Prodstore.SellTaxType = 1 THEN (((convert(decimal(10,2),(ProdStore.Price1EachSize_4) - (convert(decimal(10,2),(ProdStore.Price1EachSize_4)/11))) /100))  - (Product.SizeQty_4 * ProdStore.CostLastEx)) / NULLIF(((convert(decimal(10,2),(ProdStore.Price1EachSize_4) - (convert(decimal(10,2),(ProdStore.Price1EachSize_4)/11))) /100)),0) * 10000

      WHEN SalesSummaries.Size = 5 and Prodstore.SellTaxType = 1 THEN (((convert(decimal(10,2),(ProdStore.Price1EachSize_5) - (convert(decimal(10,2),(ProdStore.Price1EachSize_5)/11))) /100))  - (Product.SizeQty_5 * ProdStore.CostLastEx)) / NULLIF(((convert(decimal(10,2),(ProdStore.Price1EachSize_5) - (convert(decimal(10,2),(ProdStore.Price1EachSize_5)/11))) /100)),0) * 10000

      WHEN SalesSummaries.Size = 6 and Prodstore.SellTaxType = 1 THEN (((convert(decimal(10,2),(ProdStore.Price1EachSize_6) - (convert(decimal(10,2),(ProdStore.Price1EachSize_6)/11))) /100))  - (Product.SizeQty_6 * ProdStore.CostLastEx)) / NULLIF(((convert(decimal(10,2),(ProdStore.Price1EachSize_6) - (convert(decimal(10,2),(ProdStore.Price1EachSize_6)/11))) /100)),0) * 10000

      WHEN SalesSummaries.Size = 7 and Prodstore.SellTaxType = 1 THEN (((convert(decimal(10,2),(ProdStore.Price1EachSize_7) - (convert(decimal(10,2),(ProdStore.Price1EachSize_7)/11))) /100))  - (Product.SizeQty_7 * ProdStore.CostLastEx)) / NULLIF(((convert(decimal(10,2),(ProdStore.Price1EachSize_7) - (convert(decimal(10,2),(ProdStore.Price1EachSize_7)/11))) /100)),0) * 10000

      WHEN SalesSummaries.Size = 8 and Prodstore.SellTaxType = 1 THEN (((convert(decimal(10,2),(ProdStore.Price1EachSize_8) - (convert(decimal(10,2),(ProdStore.Price1EachSize_8)/11))) /100))  - (Product.SizeQty_8 * ProdStore.CostLastEx)) / NULLIF(((convert(decimal(10,2),(ProdStore.Price1EachSize_8) - (convert(decimal(10,2),(ProdStore.Price1EachSize_8)/11))) /100)),0) * 10000

      WHEN SalesSummaries.Size = 9 and Prodstore.SellTaxType = 1 THEN (((convert(decimal(10,2),(ProdStore.Price1EachSize_9) - (convert(decimal(10,2),(ProdStore.Price1EachSize_9)/11))) /100))  - (Product.SizeQty_9 * ProdStore.CostLastEx)) / NULLIF(((convert(decimal(10,2),(ProdStore.Price1EachSize_9) - (convert(decimal(10,2),(ProdStore.Price1EachSize_9)/11))) /100)),0) * 10000

      WHEN SalesSummaries.Size = 10 and Prodstore.SellTaxType = 1 THEN (((convert(decimal(10,2),(ProdStore.Price1EachSize_10) - (convert(decimal(10,2),(ProdStore.Price1EachSize_10)/11))) /100))  - (Product.SizeQty_10 * ProdStore.CostLastEx)) / NULLIF(((convert(decimal(10,2),(ProdStore.Price1EachSize_10) - (convert(decimal(10,2),(ProdStore.Price1EachSize_10)/11))) /100)),0) * 10000

      WHEN SalesSummaries.Size = 1 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_1) /100) - (Product.SizeQty_1 * ProdStore.CostLastEx)) / NULLIF(convert(decimal(10,2),ProdStore.Price1EachSize_1) /100,0)  * 10000

      WHEN SalesSummaries.Size = 2 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_2) /100) - (Product.SizeQty_2 * ProdStore.CostLastEx)) / NULLIF(convert(decimal(10,2),ProdStore.Price1EachSize_2) /100,0)  * 10000

      WHEN SalesSummaries.Size = 3 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_3) /100) - (Product.SizeQty_3 * ProdStore.CostLastEx)) / NULLIF(convert(decimal(10,2),ProdStore.Price1EachSize_3) /100,0)  * 10000

      WHEN SalesSummaries.Size = 4 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_4) /100) - (Product.SizeQty_4 * ProdStore.CostLastEx)) / NULLIF(convert(decimal(10,2),ProdStore.Price1EachSize_4) /100,0)  * 10000

      WHEN SalesSummaries.Size = 5 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_5) /100) - (Product.SizeQty_5 * ProdStore.CostLastEx)) / NULLIF(convert(decimal(10,2),ProdStore.Price1EachSize_5) /100,0)  * 10000

      WHEN SalesSummaries.Size = 6 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_6) /100) - (Product.SizeQty_6 * ProdStore.CostLastEx)) / NULLIF(convert(decimal(10,2),ProdStore.Price1EachSize_6) /100,0)  * 10000

      WHEN SalesSummaries.Size = 7 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_7) /100) - (Product.SizeQty_7 * ProdStore.CostLastEx)) / NULLIF(convert(decimal(10,2),ProdStore.Price1EachSize_7) /100,0)  * 10000

      WHEN SalesSummaries.Size = 8 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_8) /100) - (Product.SizeQty_8 * ProdStore.CostLastEx)) / NULLIF(convert(decimal(10,2),ProdStore.Price1EachSize_8) /100,0)  * 10000

      WHEN SalesSummaries.Size = 9 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_9) /100) - (Product.SizeQty_9 * ProdStore.CostLastEx)) / NULLIF(convert(decimal(10,2),ProdStore.Price1EachSize_9) /100,0)  * 10000

      WHEN SalesSummaries.Size = 10 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_10) /100) - (Product.SizeQty_10 * ProdStore.CostLastEx)) / NULLIF(convert(decimal(10,2),ProdStore.Price1EachSize_10) /100,0)  * 10000

       

      ELSE 0 END as 'RetailMargin %',

       

      CASE

      WHEN SalesSummaries.Size = 1 and Prodstore.SellTaxType = 1 THEN ((convert(decimal(10,2),(ProdStore.Price1EachSize_1) - (convert(decimal(10,2),(ProdStore.Price1EachSize_1)/11))) /100))  - (Product.SizeQty_1 * ProdStore.CostLastEx)

      WHEN SalesSummaries.Size = 2 and Prodstore.SellTaxType = 1 THEN ((convert(decimal(10,2),(ProdStore.Price1EachSize_2) - (convert(decimal(10,2),(ProdStore.Price1EachSize_2)/11))) /100)) - (Product.SizeQty_2 * ProdStore.CostLastEx)

      WHEN SalesSummaries.Size = 3 and Prodstore.SellTaxType = 1 THEN ((convert(decimal(10,2),(ProdStore.Price1EachSize_3) - (convert(decimal(10,2),(ProdStore.Price1EachSize_3)/11))) /100)) - (Product.SizeQty_3 * ProdStore.CostLastEx)

      WHEN SalesSummaries.Size = 4 and Prodstore.SellTaxType = 1 THEN ((convert(decimal(10,2),(ProdStore.Price1EachSize_4) - (convert(decimal(10,2),(ProdStore.Price1EachSize_4)/11))) /100)) - (Product.SizeQty_4 * ProdStore.CostLastEx)

      WHEN SalesSummaries.Size = 5 and Prodstore.SellTaxType = 1 THEN ((convert(decimal(10,2),(ProdStore.Price1EachSize_5) - (convert(decimal(10,2),(ProdStore.Price1EachSize_5)/11))) /100)) - (Product.SizeQty_5 * ProdStore.CostLastEx)

      WHEN SalesSummaries.Size = 6 and Prodstore.SellTaxType = 1 THEN ((convert(decimal(10,2),(ProdStore.Price1EachSize_6) - (convert(decimal(10,2),(ProdStore.Price1EachSize_6)/11))) /100)) - (Product.SizeQty_6 * ProdStore.CostLastEx)

      WHEN SalesSummaries.Size = 7 and Prodstore.SellTaxType = 1 THEN ((convert(decimal(10,2),(ProdStore.Price1EachSize_7) - (convert(decimal(10,2),(ProdStore.Price1EachSize_7)/11))) /100)) - (Product.SizeQty_7 * ProdStore.CostLastEx)

      WHEN SalesSummaries.Size = 8 and Prodstore.SellTaxType = 1 THEN ((convert(decimal(10,2),(ProdStore.Price1EachSize_8) - (convert(decimal(10,2),(ProdStore.Price1EachSize_8)/11))) /100)) - (Product.SizeQty_8 * ProdStore.CostLastEx)

      WHEN SalesSummaries.Size = 9 and Prodstore.SellTaxType = 1 THEN ((convert(decimal(10,2),(ProdStore.Price1EachSize_9) - (convert(decimal(10,2),(ProdStore.Price1EachSize_9)/11))) /100)) - (Product.SizeQty_9 * ProdStore.CostLastEx)

      WHEN SalesSummaries.Size = 10 and Prodstore.SellTaxType = 1 THEN ((convert(decimal(10,2),(ProdStore.Price1EachSize_10) - (convert(decimal(10,2),(ProdStore.Price1EachSize_10)/11))) /100)) - (Product.SizeQty_10 * ProdStore.CostLastEx)

      WHEN SalesSummaries.Size = 1 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_1) /100) - (Product.SizeQty_1 * ProdStore.CostLastEx))

      WHEN SalesSummaries.Size = 2 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_2) /100) - (Product.SizeQty_2 * ProdStore.CostLastEx))

      WHEN SalesSummaries.Size = 3 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_3) /100) - (Product.SizeQty_3 * ProdStore.CostLastEx))

      WHEN SalesSummaries.Size = 4 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_4) /100) - (Product.SizeQty_4 * ProdStore.CostLastEx))

      WHEN SalesSummaries.Size = 5 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_5) /100) - (Product.SizeQty_5 * ProdStore.CostLastEx))

      WHEN SalesSummaries.Size = 6 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_6) /100) - (Product.SizeQty_6 * ProdStore.CostLastEx))

      WHEN SalesSummaries.Size = 7 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_7) /100) - (Product.SizeQty_7 * ProdStore.CostLastEx))

      WHEN SalesSummaries.Size = 8 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_8) /100) - (Product.SizeQty_8 * ProdStore.CostLastEx))

      WHEN SalesSummaries.Size = 9 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_9) /100) - (Product.SizeQty_9 * ProdStore.CostLastEx))

      WHEN SalesSummaries.Size = 10 THEN convert(decimal(10,2),(convert(decimal(10,2),ProdStore.Price1EachSize_10) /100) - (Product.SizeQty_10 * ProdStore.CostLastEx))

       

      ELSE NULL END as 'RetailMargin $'

       

       

       

      FROM         SalesSummaries INNER JOIN

                            ProdStore ON SalesSummaries.ProductID = ProdStore.ProductID AND SalesSummaries.StoreID = ProdStore.StoreID INNER JOIN

                            Product ON ProdStore.ProductID = Product.ProductID AND SalesSummaries.ProductID = Product.ProductID

      WHERE     ProdStore.STOREID LIKE '{STOREID}' 

       and SalesSummaries.ShiftID &amp;gt;=    {ShiftFrom}   and SalesSummaries.ShiftID &amp;lt;=  {ShiftTo}  group by Product.ParentID, Product.Name, SalesSummaries.Size,  

       Product.SizeName_1,

       Product.SizeName_2,

       Product.SizeName_3,

       Product.SizeName_4,

       Product.SizeName_5,

       Product.SizeName_6,

       Product.SizeName_7,

       Product.SizeName_8,

       Product.SizeName_9,

       Product.SizeName_10,

       ProdStore.Price1EachSize_1,

       ProdStore.Price1EachSize_2,

       ProdStore.Price1EachSize_3,

       ProdStore.Price1EachSize_4,

       ProdStore.Price1EachSize_5,

       ProdStore.Price1EachSize_6,

       ProdStore.Price1EachSize_7,

       ProdStore.Price1EachSize_8,

       ProdStore.Price1EachSize_9,

       ProdStore.Price1EachSize_10,

       Product.SizeQty_1,

       Product.SizeQty_2, 

       Product.SizeQty_3, 

       Product.SizeQty_4, 

       Product.SizeQty_5, 

       Product.SizeQty_6, 

       Product.SizeQty_7, 

       Product.SizeQty_8, 

       Product.SizeQty_9, 

       Product.SizeQty_10,

       ProdStore.CostLastEx,

       ProdStore.SellTaxType

       

      order by Product.ParentID, Product.Name, SalesSummaries.Size  

      &lt;/sSQL&gt;&lt;oColumnDefs&gt;&lt;dictionary&gt;&lt;item&gt;&lt;key&gt;0&lt;/key&gt;&lt;type&gt;Xfer.cColInfo&lt;/type&gt;&lt;value&gt;&amp;lt;?xml version="1.0" encoding="utf-16"?&amp;gt;&amp;lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&amp;gt;&amp;lt;sKey&amp;gt;0&amp;lt;/sKey&amp;gt;&amp;lt;sText&amp;gt;Group Name&amp;lt;/sText&amp;gt;&amp;lt;Hidden&amp;gt;No&amp;lt;/Hidden&amp;gt;&amp;lt;Read_only&amp;gt;Yes&amp;lt;/Read_only&amp;gt;&amp;lt;Total&amp;gt;No&amp;lt;/Total&amp;gt;&amp;lt;FixedColumn&amp;gt;No&amp;lt;/FixedColumn&amp;gt;&amp;lt;ParentCol&amp;gt;No&amp;lt;/ParentCol&amp;gt;&amp;lt;eFormat&amp;gt;Text&amp;lt;/eFormat&amp;gt;&amp;lt;eList&amp;gt;Product&amp;lt;/eList&amp;gt;&amp;lt;/cColInfo&amp;gt;&lt;/value&gt;&lt;/item&gt;&lt;item&gt;&lt;key&gt;1&lt;/key&gt;&lt;type&gt;Xfer.cColInfo&lt;/type&gt;&lt;value&gt;&amp;lt;?xml version="1.0" encoding="utf-16"?&amp;gt;&amp;lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&amp;gt;&amp;lt;sKey&amp;gt;1&amp;lt;/sKey&amp;gt;&amp;lt;sText&amp;gt;Product Name&amp;lt;/sText&amp;gt;&amp;lt;Hidden&amp;gt;No&amp;lt;/Hidden&amp;gt;&amp;lt;Read_only&amp;gt;Yes&amp;lt;/Read_only&amp;gt;&amp;lt;Total&amp;gt;No&amp;lt;/Total&amp;gt;&amp;lt;FixedColumn&amp;gt;No&amp;lt;/FixedColumn&amp;gt;&amp;lt;ParentCol&amp;gt;No&amp;lt;/ParentCol&amp;gt;&amp;lt;eFormat&amp;gt;Text&amp;lt;/eFormat&amp;gt;&amp;lt;eList&amp;gt;None&amp;lt;/eList&amp;gt;&amp;lt;/cColInfo&amp;gt;&lt;/value&gt;&lt;/item&gt;&lt;item&gt;&lt;key&gt;2&lt;/key&gt;&lt;type&gt;Xfer.cColInfo&lt;/type&gt;&lt;value&gt;&amp;lt;?xml version="1.0" encoding="utf-16"?&amp;gt;&amp;lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&amp;gt;&amp;lt;sKey&amp;gt;2&amp;lt;/sKey&amp;gt;&amp;lt;sText&amp;gt;Size&amp;lt;/sText&amp;gt;&amp;lt;Hidden&amp;gt;No&amp;lt;/Hidden&amp;gt;&amp;lt;Read_only&amp;gt;Yes&amp;lt;/Read_only&amp;gt;&amp;lt;Total&amp;gt;No&amp;lt;/Total&amp;gt;&amp;lt;FixedColumn&amp;gt;No&amp;lt;/FixedColumn&amp;gt;&amp;lt;ParentCol&amp;gt;No&amp;lt;/ParentCol&amp;gt;&amp;lt;eFormat&amp;gt;Text&amp;lt;/eFormat&amp;gt;&amp;lt;eList&amp;gt;None&amp;lt;/eList&amp;gt;&amp;lt;/cColInfo&amp;gt;&lt;/value&gt;&lt;/item&gt;&lt;item&gt;&lt;key&gt;3&lt;/key&gt;&lt;type&gt;Xfer.cColInfo&lt;/type&gt;&lt;value&gt;&amp;lt;?xml version="1.0" encoding="utf-16"?&amp;gt;&amp;lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&amp;gt;&amp;lt;sKey&amp;gt;3&amp;lt;/sKey&amp;gt;&amp;lt;sText&amp;gt;Cost Ex&amp;lt;/sText&amp;gt;&amp;lt;Hidden&amp;gt;No&amp;lt;/Hidden&amp;gt;&amp;lt;Read_only&amp;gt;Yes&amp;lt;/Read_only&amp;gt;&amp;lt;Total&amp;gt;No&amp;lt;/Total&amp;gt;&amp;lt;FixedColumn&amp;gt;No&amp;lt;/FixedColumn&amp;gt;&amp;lt;ParentCol&amp;gt;No&amp;lt;/ParentCol&amp;gt;&amp;lt;eFormat&amp;gt;CurrDbl&amp;lt;/eFormat&amp;gt;&amp;lt;eList&amp;gt;None&amp;lt;/eList&amp;gt;&amp;lt;/cColInfo&amp;gt;&lt;/value&gt;&lt;/item&gt;&lt;item&gt;&lt;key&gt;4&lt;/key&gt;&lt;type&gt;Xfer.cColInfo&lt;/type&gt;&lt;value&gt;&amp;lt;?xml version="1.0" encoding="utf-16"?&amp;gt;&amp;lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&amp;gt;&amp;lt;sKey&amp;gt;4&amp;lt;/sKey&amp;gt;&amp;lt;sText&amp;gt;Retail Price Inc&amp;lt;/sText&amp;gt;&amp;lt;Hidden&amp;gt;No&amp;lt;/Hidden&amp;gt;&amp;lt;Read_only&amp;gt;Yes&amp;lt;/Read_only&amp;gt;&amp;lt;Total&amp;gt;No&amp;lt;/Total&amp;gt;&amp;lt;FixedColumn&amp;gt;No&amp;lt;/FixedColumn&amp;gt;&amp;lt;ParentCol&amp;gt;No&amp;lt;/ParentCol&amp;gt;&amp;lt;eFormat&amp;gt;CurrDbl&amp;lt;/eFormat&amp;gt;&amp;lt;eList&amp;gt;None&amp;lt;/eList&amp;gt;&amp;lt;/cColInfo&amp;gt;&lt;/value&gt;&lt;/item&gt;&lt;item&gt;&lt;key&gt;5&lt;/key&gt;&lt;type&gt;Xfer.cColInfo&lt;/type&gt;&lt;value&gt;&amp;lt;?xml version="1.0" encoding="utf-16"?&amp;gt;&amp;lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&amp;gt;&amp;lt;sKey&amp;gt;5&amp;lt;/sKey&amp;gt;&amp;lt;sText&amp;gt;Retail Margin (%)&amp;lt;/sText&amp;gt;&amp;lt;Hidden&amp;gt;No&amp;lt;/Hidden&amp;gt;&amp;lt;Read_only&amp;gt;Yes&amp;lt;/Read_only&amp;gt;&amp;lt;Total&amp;gt;No&amp;lt;/Total&amp;gt;&amp;lt;FixedColumn&amp;gt;No&amp;lt;/FixedColumn&amp;gt;&amp;lt;ParentCol&amp;gt;No&amp;lt;/ParentCol&amp;gt;&amp;lt;eFormat&amp;gt;Perc2Int&amp;lt;/eFormat&amp;gt;&amp;lt;eList&amp;gt;None&amp;lt;/eList&amp;gt;&amp;lt;/cColInfo&amp;gt;&lt;/value&gt;&lt;/item&gt;&lt;item&gt;&lt;key&gt;6&lt;/key&gt;&lt;type&gt;Xfer.cColInfo&lt;/type&gt;&lt;value&gt;&amp;lt;?xml version="1.0" encoding="utf-16"?&amp;gt;&amp;lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&amp;gt;&amp;lt;sKey&amp;gt;6&amp;lt;/sKey&amp;gt;&amp;lt;sText&amp;gt;Retail Margin ($)&amp;lt;/sText&amp;gt;&amp;lt;Hidden&amp;gt;No&amp;lt;/Hidden&amp;gt;&amp;lt;Read_only&amp;gt;Yes&amp;lt;/Read_only&amp;gt;&amp;lt;Total&amp;gt;No&amp;lt;/Total&amp;gt;&amp;lt;FixedColumn&amp;gt;No&amp;lt;/FixedColumn&amp;gt;&amp;lt;ParentCol&amp;gt;No&amp;lt;/ParentCol&amp;gt;&amp;lt;eFormat&amp;gt;CurrDbl&amp;lt;/eFormat&amp;gt;&amp;lt;eList&amp;gt;None&amp;lt;/eList&amp;gt;&amp;lt;/cColInfo&amp;gt;&lt;/value&gt;&lt;/item&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