generate crystal report columns directly

[er.lokeshsharma]

Hi everybody,

My name is Lokesh and i am a newbie to crystal reports. Off late, I am facing tough time in implementing a requirement in my project using crystal reports. My requirement is to display columns in crystal report based on user's choice. For example,

Lets say there is a table in sql which is like this:-

Country Population Revenue Rank
india 1800000000 1.2 7
china 2000000000 1.9 3
usa 1000000000 2.0 2

Now i want user to select any of these 4 columns (country, population, revenue, rank) and these columns would be displayed in the crystal reports. Crystal report is bound to dataset. Please provide me appropriate answer.