create dynamic reports in asp.net

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Dec 2006
Posts: 4
Reputation: sridhar_msd is an unknown quantity at this point 
Solved Threads: 0
sridhar_msd sridhar_msd is offline Offline
Newbie Poster

create dynamic reports in asp.net

 
0
  #1
Dec 4th, 2006
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
Reply With Quote Quick reply to this message  
Join Date: Feb 2005
Posts: 1,181
Reputation: hollystyles will become famous soon enough hollystyles will become famous soon enough 
Solved Threads: 67
hollystyles's Avatar
hollystyles hollystyles is offline Offline
Veteran Poster

Re: create dynamic reports in asp.net

 
0
  #2
Dec 4th, 2006
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
==========================================
Yadda yadda yadda...
Web junky, fevered monkey
Reply With Quote Quick reply to this message  
Join Date: Dec 2006
Posts: 4
Reputation: sridhar_msd is an unknown quantity at this point 
Solved Threads: 0
sridhar_msd sridhar_msd is offline Offline
Newbie Poster

Re: create dynamic reports in asp.net

 
0
  #3
Dec 5th, 2006
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
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC