Can i pull a report that shows the ship to state for an order

If you have an "Orders" table that has a "ship To" address then you should be able to pull the ship to state to display it where you'd like in the columns, or even use it as a dynamic filter on the left, so you can easily pull all the orders to that particular state.

 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