Need a static straight table. ie. columns should not disappear in case data is not available
I am working on a straight table and couple of list boxes. I have couple of requirements
I have created a straight table with 2 columns City and population. Also I have 2 list boxes - Year and Area.
If there is no data for particular city then that City disappears from table.
If I select particular year from Year list box then City disappears from table
I need to show all the Cities and plot '0' in case population data is unavailable against particular City.
This is more on the similar ground of requirement -1. I need to show fixed (100) set of cities in list box all the time. Even if I received data for only 10 cities, I need to display static list of all the 100 cities. On selection of rest of 90 cities in list box - it should display- data not available.