0.7in 0.7in 0.7in 1.1in 0.65in 0.7in 0.7in 0.9in 0.75in 0.85in 0.65in 0.85in 0.25in true true Location textbox2 9 PowderBlue Middle 2pt 2pt 2pt 2pt true true Date textbox3 8 PowderBlue Middle 2pt 2pt 2pt 2pt true true Invoice# PowderBlue Middle 2pt 2pt 2pt 2pt true true Name PowderBlue Middle 2pt 2pt 2pt 2pt true true Cost textbox6 PowderBlue Middle 2pt 2pt 2pt 2pt true true Amount textbox14 PowderBlue Middle 2pt 2pt 2pt 2pt true true Feature textbox16 PowderBlue Middle 2pt 2pt 2pt 2pt true true Comm Type textbox18 PowderBlue Middle 2pt 2pt 2pt 2pt true true Profit textbox21 PowderBlue Middle 2pt 2pt 2pt 2pt true true Revenue textbox23 PowderBlue Middle 2pt 2pt 2pt 2pt true true Comm% textbox25 PowderBlue Middle 2pt 2pt 2pt 2pt true true Emp Comm textbox27 PowderBlue Middle 2pt 2pt 2pt 2pt 0.25in true true textbox70 PowderBlue Middle 2pt 2pt 2pt 2pt true true SKU textbox71 PowderBlue Middle 2pt 2pt 2pt 2pt 2 true true Description PowderBlue Middle 2pt 2pt 2pt 2pt 3 true true textbox80 PowderBlue Middle 2pt 2pt 2pt 2pt true true textbox81 PowderBlue Middle 2pt 2pt 2pt 2pt true true textbox82 PowderBlue Middle 2pt 2pt 2pt 2pt true true Qty textbox83 PowderBlue Middle 2pt 2pt 2pt 2pt true true textbox84 PowderBlue Middle 2pt 2pt 2pt 2pt true true textbox85 PowderBlue Middle 2pt 2pt 2pt 2pt 0.2in true true =Fields!String_14.Value 4 true true true true true true true true true true true true true true true true 0.24997in true true 2 true true =Fields!String_08.Value 10 0.25in true true =Fields!String_02.Value StoreCode 4 Middle 2pt 2pt 2pt 2pt true true =Fields!Date_01.Value String_01 3 Middle 2pt 2pt 2pt 2pt true true =Fields!TrnId.Value String_02 2 Middle 2pt 2pt 2pt 2pt true true =Fields!String_01.Value textbox9 Middle 2pt 2pt 2pt 2pt true true =Fields!Num_01.Value*Fields!Num_08.Value textbox8 2pt 2pt 2pt 2pt true true =Fields!Num_02.Value*Fields!Num_08.Value textbox15 2pt 2pt 2pt 2pt true true =Fields!Num_06.Value textbox17 2pt 2pt 2pt 2pt true true =Fields!String_09.Value textbox19 2pt 2pt 2pt 2pt true true =(((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value))- (Fields!Num_01.Value*Fields!Num_08.Value) textbox22 2pt 2pt 2pt 2pt true true =(((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value)) textbox24 2pt 2pt 2pt 2pt true true true =Fields!Num_07.Value textbox26 2pt 2pt 2pt 2pt true true =switch( Fields!String_09.Value="Flat", (Fields!Num_07.Value*Fields!Num_08.Value), Fields!String_09.Value="Units", (Fields!Num_07.Value*Fields!Num_08.Value), Fields!String_09.Value="Profit", (((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value)-(Fields!Num_01.Value*Fields!Num_08.Value)) *(Fields!Num_07.Value/100), Fields!String_09.Value="Revenue Share", (((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value)) *(Fields!Num_07.Value/100), Fields!String_09.Value="Performance Points", (((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value)) *(Fields!Num_07.Value/100) ) textbox28 2pt 2pt 2pt 2pt 0.25in true true textbox10 Middle 2pt 2pt 2pt 2pt true true =Fields!String_05.Value textbox11 Middle 2pt 2pt 2pt 2pt 2 true true =Fields!String_06.Value textbox50 Middle 2pt 2pt 2pt 2pt 3 true true textbox64 2pt 2pt 2pt 2pt true true textbox65 2pt 2pt 2pt 2pt true true textbox66 2pt 2pt 2pt 2pt true true =Round(Fields!Num_08.Value,0) textbox67 2pt 2pt 2pt 2pt true true textbox68 2pt 2pt 2pt 2pt true true textbox69 2pt 2pt 2pt 2pt 0.24997in true true =Fields!String_14.Value & " / " & Fields!String_08.Value textbox54 7 true true =sum((((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value))- (Fields!Num_01.Value*Fields!Num_08.Value)) textbox62 2 true true =SUM((((Fields!Num_02.Value*Fields!Num_08.Value)-Fields!Num_04.Value))) textbox73 true true textbox32 true true =sum(switch( Fields!String_09.Value="Flat", (Fields!Num_07.Value*Fields!Num_08.Value), Fields!String_09.Value="Units", (Fields!Num_07.Value*Fields!Num_08.Value), Fields!String_09.Value="Profit", (((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value)-(Fields!Num_01.Value*Fields!Num_08.Value)) *(Fields!Num_07.Value/100), Fields!String_09.Value="Revenue Share", (((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value)) *(Fields!Num_07.Value/100), Fields!String_09.Value="Performance Points", (((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value)) *(Fields!Num_07.Value/100) )) textbox76 0.25in true true =Fields!String_14.Value & " Grand Total" 7 true true =sum((((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value))- (Fields!Num_01.Value*Fields!Num_08.Value)) 2 true true =SUM((((Fields!Num_02.Value*Fields!Num_08.Value)-Fields!Num_04.Value))) true true textbox33 true true 0.24997in true true Total Commissionable Amount textbox13 7 true true =sum((((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value))- (Fields!Num_01.Value*Fields!Num_08.Value)) textbox49 2 true true =SUM( ((Fields!Num_02.Value*Fields!Num_08.Value)-Fields!Num_04.Value)*(iif(Fields!String_15.Value is nothing ,0,1)) ) textbox53 true true textbox34 true true =sum(switch( Fields!String_09.Value="Flat", (Fields!Num_07.Value*Fields!Num_08.Value), Fields!String_09.Value="Units", (Fields!Num_07.Value*Fields!Num_08.Value), Fields!String_09.Value="Profit", (((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value)-(Fields!Num_01.Value*Fields!Num_08.Value)) *(Fields!Num_07.Value/100), Fields!String_09.Value="Revenue Share", (((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value)) *(Fields!Num_07.Value/100), Fields!String_09.Value="Performance Points", (((Fields!Num_02.Value*Fields!Num_08.Value)+Fields!Num_04.Value)) *(Fields!Num_07.Value/100) )) textbox56 After true true After true true =Fields!String_14.Value After true true =Fields!String_08.Value After true true =Fields!String_08.Value Detail Detail_Collection Output true Before true Before true Before true SpReportTemplate_01DataTable 2.19991in 9.25in 0.1in 6.65in 0.375in 2.5in true true =Parameters!StoreName.Value true true =Parameters!StartDate.Value 0.55in 7.05in 0.25in 0.9in 2 true true =Parameters!EndDate.Value 0.55in 7.75in 0.25in 1.1in 3 0.65in 8.05in 0in -0.08958in 4 1.5pt textbox72 0.05in 0.2in 1.275in true true =Globals!ExecutionTime 0.05in 7.3in 0.25in 1.875in 1 0in 9.25in 2 1.5pt 8.5in 11in 11in 8.5in 0.3in 0.3in 0.3in