Srivatsa,
To do this, I would suggest you create a report with all possible columns in your database and show/hide columns dynamically. So you may have to pass parameters to the report for each column as True or False and column will be displayed only when the parameter value if True. So if you want Age and Name columns to be displayed only, pass True for these two columns and False for rest. On Suppress property of the Reports column, check if Parameter value is False then return True else return False.

Thanks for such a nice tutorial.

I have a small question.

Can we have name, age and phone no in 3 rows and the corresponding value in column i.e. I want to transpose the rows and columns and want to generate dynamic column(for every user 1 column will be added).

Can we do this?

The file is .XSD.

You need to create a typed DataSet from the database table. If it was not created using the connection wizard, you can add a new item to the project and select DataSet query. It will add a .XSD file. Now, simply drag database table from Database Explorer.

Alternatively, you can create a DataAdapter by dragging OdbcDataAdapter from the Toolbox and connect it with your database and get data from tables using the Wizard. Once OdbcDataAdapter is created, right click on it and select Generate DataSet. This will generate a typed DataSet (.XSD) file.

Tried to do getting started methodology with Web page.  However, Web page shows error message no datasource has been instantiated for datasource1_tblComments.

Then tried to follow this tutorial for Web page.  However data menu for WebForm does not show Add New datasource and there is no way to bring up Data Source Configuration Wizard. 

In addition, initially the building datasource wizard would not allow me to select the stored procedure I desired to show the data, instead reporting that it did not exist.   I had to created another datasource for the same database and the sa user in order to see the stored proc I desired to use. 

I then created a windows Forms project to test out the methodology in this article.  However, after dragging the table onto the report visual interface, I was unable to see any columns in the stored Procedure I desired to use to drag into the Report Table. 

At no point was I able to get to the point of displaying data from my stored procedure.

I then returned to my web application and created the report object using a table in the  database vice the real resultset that I need.  It was my intent to create the report then change the dataset to that I need the way it was done it the above example.  (I was not and am not sure how this change of data set is going to update the columns established in the table in the report object interface designer, but I decided that was an issue I could tackle later.)  After adding the report to the  reportviewer, I tried to change the datasource of the the objectdatasource that appeared on the page.  This was not permitted.

I then tried to create a local report object programmatically as shown in the MSDN localreport class example.  I was able to successfully add the new datasource to the localreport object instantiated, but then was not able to programmatically add the localreport thus created to the reportview as the localreport property of the viewer is readonly.

Perhaps you could redo the above step by step example as a web page using a stored procedure with parameters (all with default values) as the data source?  Thanks