I have a field that has the first three characters of a city name with a dash and the exact location. i.e. "REG-left wing", which is the Regina office in the left wing. I have created a field that strips everything except the first three characters:
Left ({Work_Orders.Client Location ID},3 )
What I need to do now though is use this field and create a parameter so the report asks which city we want to filter on. (REG, CAL, EDM ... etc)
When I go to create a new parameter, I can't find the new field I created. I'm assuming there must be a way to find it, so I can insert it into my report for a popup dialogue.
Thanks.
Wanda
Left ({Work_Orders.Client Location ID},3 )
What I need to do now though is use this field and create a parameter so the report asks which city we want to filter on. (REG, CAL, EDM ... etc)
When I go to create a new parameter, I can't find the new field I created. I'm assuming there must be a way to find it, so I can insert it into my report for a popup dialogue.
Thanks.
Wanda