By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,106 Members | 2,679 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,106 IT Pros & Developers. It's quick & easy.

Need advice on web query report control or tool

P: n/a
I would like my user to retrieve SQL data through intranet website:

1. Go to intranet link and enter parameters for report (for example Order
From and To date)
2. Click on "Run" button and the data come back in Excel screen.

The data are retrieved using SQL Select statements. The return data are all
in simple table row and column, there is no other Excel formating required.
Users used these data to do further analysis using Excel. I know I need to
create one webform to query for parameter and another webform to return the
data (will CSV format do? I am not sure how to call up Excel, still
exploring). It is ok to manual code for few reports but not if I have 20 to
30 reports.

I am wondering if there is any asp.net control or tools that would make it
easy to code such reports?

Thanks for any help.

Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi,

That might help :

http://www.aspnetpro.com/NewsletterA...09so_l/asp2003
09so_l.asp

Check the Simply "Compatible: Tab Delimited Format" paragraph.

It's not a tool but Steve shows you how to convert datatable to excel on
the client. You still need to create page with selection options and
generate the right SQL.

HTH

Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: +972-(0)58-888377
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.