Sales Tax Analysis - group by month and/or quarter

D

Danny 18 years ago

I'm looking for a report on Sales - Sales Tax Collected - by month and.or quarters... How do I change to group by month? Any help would be appreciated?

Danny

---------------------------------------------- //--- Report Summary --- //

Begin ReportSummary ReportType = reporttypeSales ReportTitle = "Sales Tax Collected -adj" PageOrientation = pageorientationPortrait WordWrap = False ShowDateTimePicker = False OutLineMode = True Groups = 2 GroupDescription = "" DisplayLogo = True LogoFileName = "MyLogo.bmp" ProcedureCall = "" PreQuery1 = "" PreQuery2 = "" TablesQueried = "FROM TaxTotals WITH(NOLOCK) LEFT JOIN Tax WITH(NOLOCK) ON TaxTotals.TaxID = Tax.ID LEFT JOIN Batch WITH(NOLOCK) ON TaxTotals.BatchNumber = Batch.BatchNumber LEFT JOIN Register WITH(NOLOCK) ON Batch.RegisterID = Register.ID" SelCriteria = "" GroupBy = "" SortOrder = "" End ReportSummary

//--- Title Rows ---//

Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 16 Color = "Blue" End TitleRow

Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 12 Color = "Black" End TitleRow

Begin TitleRow Text = "Generated On " Font = "Arial" FontBold = True FontSize = 10 Color = "Black" End TitleRow

//--- Filters ---//

Begin Filter FieldName = "TaxTotals.Date" FilterOp = reportfilteropBetween FilterLoLim = "01/01/2007" FilterHilim = "31/12/2007" FilterNegated = False FilterConnector = reportfilterbooleanconAND End Filter

//--- Columns ---//

Begin Column FieldName = "TaxTotals.Month" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Month" VBDataType = vbInteger Formula = "cast(DatePart(Mm,TaxTotals.Date) as int) " ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 930 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Tax.Description" DrillDownFieldName = "Tax.Description" DrillDownReportName = "" StoreIDFieldName = "" Title = "Tax Description" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1965 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Begin Column FieldName = "Tax.Percentage" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Percentage" VBDataType = vbDouble Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1080 GroupMethod = groupmethodMax ColFormat = "00.##" ColAlignment = flexAlignRightCenter End Column

Begin Column FieldName = "TaxTotals.Date" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Date" VBDataType = vbDate Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 930 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Batch.BatchNumber" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Batch #" VBDataType = vbLong Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 885 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignRightCenter End Column

Begin Column FieldName = "Register.Number" DrillDownFieldName = "Register.Number" DrillDownReportName = "" StoreIDFieldName = "" Title = "Register" VBDataType = vbLong Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 885 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Batch.OpeningTime" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Opened" VBDataType = vbDate Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1380 GroupMethod = groupmethodNone ColFormat = "ddddd hh:mm" ColAlignment = flexAlignRightCenter End Column

Begin Column FieldName = "Batch.ClosingTime" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Closed" VBDataType = vbDate Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1275 GroupMethod = groupmethodNone ColFormat = "ddddd hh:mm" ColAlignment = flexAlignRightCenter End Column

Begin Column FieldName = "TaxTotals.Total" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Total Collected" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1710 GroupMethod = groupmethodSum ColFormat = "" End Column

Vote

A

Akber Alwani 18 years ago

hi Danny,

Tell me the columns you need so I can make soemth> I'm looking for a report on Sales - Sales Tax Collected - by month and.or

Vote

J

Jen Losch 18 years ago

Hi there,

Retail Analytics, from Professional Advantage, is designed to help retailers manage their business by delivering analytical reporting on business performance. Easily identify trends, buying patterns, seasonality, and other key performance indicators for your business. If you enter it in RMS you can report on it in Retail Analytics.

If you would like to take a quick look at the product, please go to

formatting link

We also have the UCAP (Up Close and Personal) program available. UCAP - we have streamlined a process to get RMS data in house, load the product and then demonstrate the full power of the product on the data - for FREE!

Please do not hesitate to contact me if you have any questions or if there is anything that we can do for you.

Thanks,

Jen Bridgeford

701 235 2363 ext 248 snipped-for-privacy@profad.com

"Danny" wrote:

Vote

Sales Tax Analysis - group by month and/or quarter

Join the Discussion

Didn't find your answer?