I created a custom formula field (@State) in Crystal Reports to pull the State abbreviation out of the Sales Tax District name.
In Crystal Reports-
@State = the below formula
Left ({tblTaxDistricts.SalesTaxDistrict},2)
In Tigerpaw's Reports Explorer I want to use a selection criteria for the user to enter in the 2 digit state abbreviation so the report only pulls that selected state. Like CA or MN, etc.
I tried using UserParam1 but was unsuccessful.
Does anyone know how you can either set-up a user defined selection formula that will filter on the custom formula field @State that I built in Crystal Reports or how to create a selection formula that will filter on the beginning/left characters of the tblTaxDistricts.SalesTaxDistrict field?
Example of Sales Tax District data
SC – Aiken County
TX – City of Abilene
Thank You - Lisa
In Crystal Reports-
@State = the below formula
Left ({tblTaxDistricts.SalesTaxDistrict},2)
In Tigerpaw's Reports Explorer I want to use a selection criteria for the user to enter in the 2 digit state abbreviation so the report only pulls that selected state. Like CA or MN, etc.
I tried using UserParam1 but was unsuccessful.
Does anyone know how you can either set-up a user defined selection formula that will filter on the custom formula field @State that I built in Crystal Reports or how to create a selection formula that will filter on the beginning/left characters of the tblTaxDistricts.SalesTaxDistrict field?
Example of Sales Tax District data
SC – Aiken County
TX – City of Abilene
Thank You - Lisa