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
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.