# Displaying specific list of cities in dropdown

**URL:** <https://www.dynamicsuser.net/t/displaying-specific-list-of-cities-in-dropdown/35134>\
**Category:** Technical Forum\
**Created:** [January 19, 2012, 7:06am UTC](https://www.dynamicsuser.net/t/displaying-specific-list-of-cities-in-dropdown/35134 "2012-01-19T07:06:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rajarajeshwari](https://avatars.discourse-cdn.com/v4/letter/r/bc79bd/32.png) [@rajarajeshwari](https://www.dynamicsuser.net/u/rajarajeshwari)\
**Post date:** [January 19, 2012, 7:06am UTC](https://www.dynamicsuser.net/t/displaying-specific-list-of-cities-in-dropdown/35134/1 "2012-01-19T07:06:18Z")

</div>

Hi All,

I’m working on a report,in which i have a dropdown field listing all the ststes in the ‘AddressState’ Table.But i want to display only the states whose ‘CountryRegionId’ is ‘USA’. Is there any way to achieve this?

Please Help.

-Rajee

---

<div class="post-metadata">

**Author:** ![rajarajeshwari](https://avatars.discourse-cdn.com/v4/letter/r/bc79bd/32.png) [@rajarajeshwari](https://www.dynamicsuser.net/u/rajarajeshwari)\
**Post date:** [January 24, 2012, 11:20am UTC](https://www.dynamicsuser.net/t/displaying-specific-list-of-cities-in-dropdown/35134/2 "2012-01-24T11:20:09Z")

</div>

Hi All,

With the help of this post,i achieved my desiered result.

[http://dynamicsuser.net/forums/p/41539/211998.aspx](http://dynamicsuser.net/forums/p/41539/211998.aspx)

-Rajee

---

<div class="post-metadata">

**Author:** ![Harish](https://avatars.discourse-cdn.com/v4/letter/h/47e85d/32.png) [@Harish](https://www.dynamicsuser.net/u/Harish)\
**Post date:** [January 24, 2012, 11:35am UTC](https://www.dynamicsuser.net/t/displaying-specific-list-of-cities-in-dropdown/35134/3 "2012-01-24T11:35:44Z")

</div>

Hi,

Glad that you were able to resolve the issue by searching this forum. Well-done! [:D]

---

<div class="post-metadata">

**Author:** ![rajarajeshwari](https://avatars.discourse-cdn.com/v4/letter/r/bc79bd/32.png) [@rajarajeshwari](https://www.dynamicsuser.net/u/rajarajeshwari)\
**Post date:** [January 24, 2012, 11:42am UTC](https://www.dynamicsuser.net/t/displaying-specific-list-of-cities-in-dropdown/35134/4 "2012-01-24T11:42:04Z")

</div>

Thank you Harish 🙂 !
