I have a report that groups sales by zip codes. However, many of my zip codes have the four digit extension. Does someone know the command I can put in the zip field to truncate the zip code for the main 5 digits, allowing the group total for the main zip code?
custom report - truncate in sql
Mar 13, 2009
2 Replies
you will have to edit the report in notepad to change the formula:
Begin Column FieldName = "ZipCode" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Zip" VBDataType = vbString Formula = "left(Customer.zip,5)" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 630 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftTop End Column
"Gene @ Treads" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required