TaxGroups State,System.String TaxGroup,System.String Printed,System.String Category,System.String Tax,System.String Rate,System.Decimal 30 TaxGroups POSitive Retail Manager SELECT RIGHT(RTRIM(TXR_TAXDESCRIPT),2) as State, TXR_TAXDESCRIPT as TaxGroup, TAX_TAXD1 as Printed, TXG_TAXDESCRIPT as Category, STX_TAXDESCRIPT as Tax, STX_TAXRATE as Rate FROM TaxDet,TaxRate,TAXRATES,SALESTAX,TaxCats WHERE TXD_RateID=TXR_RateID and TXR_RateID=TAX_TAXID and TXD_GroupID = STX_GroupID and TXD_CatID = TXG_TAXID Order By State ASC,TaxGroup ASC,TXG_TAXID ASC,Rate DESC PRM_x0020_Variables,SiteID,SiteID,System.String,M001,True,False PRM_x0020_Variables,TransactionNumber,TransactionNumber,System.Int32,_x0031_234321,True,False PRM_x0020_Variables,TransactionType,TransactionType,System.String,I,True,False PRM_x0020_Variables,StartDate,StartDate,System.Int32,_x0030_,True,False PRM_x0020_Variables,StartTime,StartTime,System.Int32,_x0030_,True,False PRM_x0020_Variables,EndDate,EndDate,System.Int32,_x0030_,True,False PRM_x0020_Variables,EndTime,EndTime,System.Int32,_x0035_38976288,True,False PRM_x0020_Variables,CompanyID,CompanyID,System.Int32,_x0036_,True,False PRM_x0020_Variables,SalesID,SalesID,System.String,POS,True,False PRM_x0020_Variables,SalesName,SalesName,System.String,Manager_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_,True,False PRM_x0020_Variables,CustomerID,CustomerID,System.Int32,_x0035_38976288,True,False PRM_x0020_Variables,VendorID,VendorID,System.Int32,_x0035_38976288,True,False PRM_x0020_Variables,InventoryID,InventoryID,System.Int32,_x0035_38976288,True,False PRM_x0020_Variables,QueryAnd,QueryAnd,System.String,,True,False PRM_x0020_Variables,QueryOr,QueryOr,System.String,,True,False PRM_x0020_Variables,QueryWhere,QueryWhere,System.String,,True,False PRM_x0020_Variables,TransactionGUID,TransactionGUID,System.String,,True,False PRM_x0020_Variables,TaxInclusive,TaxInclusive,System.Int32,_x0030_,True,False PRM_x0020_Variables,StationNumber,StationNumber,System.Int32,_x0031_6,True,False PRM_x0020_Variables,OpenBatch,OpenBatch,System.Int32,_x0030_,True,False EngineV2 Name,Tax_x0020_Groups Description,Displays_x0020_information_x0020_regarding_x0020_tax_x0020_groups_x0020_organized_x0020_by_x0020_State._x0020__x0020_Includes_x0020__x0020_For_x0020_eachTax_x0020_Group_x002C__x0020_the_x0020_Group_x0020_Identifier_x0020_is_x0020_listed_x002C__x0020_followed_x0020_by_x0020_the_x0020_tax_x0020_Categories_x0020_for_x0020_the_x0020_group_x0020_and_x0020_the_x0020_indivisual_x0020_tax_x0020_rates_x0020_associated_x0020_with_x0020_each_x0020_category. CategoryCode,M CreatorCode, ReportPromptsCode,_x0030_000000 None;Black;2;Solid;False;4;Black Transparent 0.5 2 4 Transparent 0,0.2,7.72,0.96 True White 1.74,0.22,4.8,0.5 Arial,24 Center 0,0,0,0 Text7 Sales Tax Groups Black Center PageHeader1 Transparent 0,9.92,7.72,0.3 White 6.48,0.05,1.11,0.2 Arial,12 Right 0,0,0,0 Text6 {PageNofM} Black Center PageFooter1 Transparent True True 0,1.56,4,0.3 White True True 0,0,0.6,0.3 Arial,16,Bold 0,0,0,0 Text1 {TaxGroups.State} Black Center {TaxGroups.State} GroupHeader1 True None Transparent 0,2.26,4,0.23 White 0,0.01,1.98,0.2 Arial,10,Bold 0,0,0,0 Text2 {TaxGroups.TaxGroup} Black {TaxGroups.TaxGroup} True GroupHeader2 None Transparent 0,2.89,4,0.21 White 0.1,0.01,1.2,0.2 Arial,8 0,0,0,0 Text3 {TaxGroups.Category} Black Center {TaxGroups.Category} GroupHeader3 None Transparent 0,3.5,4,0.21 White 0.54,0.02,1.5,0.17 Arial,8 0,0,0,0 Text4 {TaxGroups.Tax} Black Center White 2.48,0.01,0.6,0.17 Arial,8 0,0,0,0 Text5 {Format("{0:P2}",TaxGroups.Rate)} Black Center TaxGroups Data1 Transparent 0,4.11,4,0 GroupFooter3 Transparent 0,4.51,4,0 GroupFooter2 Transparent 0,4.91,4,0.18 GroupFooter1 f6636e30dbdc400eafa37c8ec2616db6 0.39,0.39,0.39,0.39 Page1 11 8.5 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Tax Groups Mike Simpkins 1/13/2011 9:14:59 AM 12/29/2010 12:19:49 PM Displays information regarding tax groups organized by State. Includes For eachTax Group, the Group Identifier is listed, followed by the tax Categories for the group and the indivisual tax rates associated with each category. TaxGroups 8ce9fe3efe4c4ad58448ff586ef1ced1 Tax Groups Inches 2010.1.700 CSharp