Member Avatar for sridhar_msd

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

  • 2 Contributors
  • 2 Replies
  • 74 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by sridhar_msd
Member Avatar for hollystyles

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

Member Avatar for sridhar_msd

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.