Can i pull a report that shows the ship to state for an order
reporting
Forum Discussion
Assuming you have an address field named [Ship To ]
1.) I recommend you create another field Called Ship to State and make sure it is set to Formula - Text
2.) If you look on your address field options and scroll all the way down you will see Address Subfields. Use the field label [Ship To: State/Region]
3.) so just open up your newly created field Ship to State and simply enter
[Ship To: State/Region] and you're all set
Now for a report you can simply use the address field subfields as the columns
1.) I recommend you create another field Called Ship to State and make sure it is set to Formula - Text
2.) If you look on your address field options and scroll all the way down you will see Address Subfields. Use the field label [Ship To: State/Region]
3.) so just open up your newly created field Ship to State and simply enter
[Ship To: State/Region] and you're all set
Now for a report you can simply use the address field subfields as the columns