can we create dynamic reports in asp.net?

the specification is as follows:

we should be able to list all tthe columns from a table and the user dynamically select the columns for generating the report.

plz help me

thanks in advance
sridhar

1. Look up INFORMATION.SCHEMA in the Sql Server manual (known as books online) Assuming your database is Sql server, that will help you get a dataset of columns.

2. Use the dataset of columns as the DataSource of a ListBox WebControl, set MultiSelect property to true.

3. Concatenatet the users selections in the ListBox control into a SQL statement.

4. Use ADO.NET to execute the SQL and return a dataset, pass the the dataset to a datagrid or gridView WebControls' datasource, whos AutoGenerateColumns property is set to true

hi,

thanks for your help.

but i want to generate the reports in dynamic by selecting a set of columns in a table.

is it possible

pl help me on this

thanks in advance
sridhar