Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 8th, 2004, 08:44 PM
Authorized User
 
Join Date: Aug 2004
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Default what is the common approach for it? thanks

For database manipulation, I want to see some Queries printed.
say, after selection of "select * (or some fields) from table, my webpage shows the results in HTML, that is fine.. but how to export the HTML, like after i click a "Print" button, i would be able to print a Formatted report. (there will be problem if it is not formatted since huge number of columns may exist, and color or sth.)

wat is easy and common approach for it? thanks a lot.

 
Old September 9th, 2004, 12:07 AM
Authorized User
 
Join Date: Aug 2004
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to sinapra Send a message via MSN to sinapra Send a message via Yahoo to sinapra
Default

hi
well do you want to print only the records, ok here i want to say that if you have other contents in your page, do you want to prevent them and print only the result of table, if thats right, you cannot just do it by print option, since it will definitely read the whole web page content and print it, instead, you can provide a printable link, something like yahoo where you can put the result of data and print it. I hope I am almost there in explaining you, only one extra page would solve your problem.
Regards

sinapra
 
Old September 9th, 2004, 03:12 AM
Authorized User
 
Join Date: Aug 2004
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ya, sinapra
IE print BUtton won't work as expected. My "Print" button is not the IE thing.
Surely have to import one extra page. but my question is what is common approach of formatting Reports in the extra page. what's the common component most ppl use

 
Old September 9th, 2004, 03:57 AM
Authorized User
 
Join Date: Aug 2004
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to sinapra Send a message via MSN to sinapra Send a message via Yahoo to sinapra
Default

ok whats the exact format you are looking for, see like what normally we do is take the output in excel and use that format in printer with the headers as fieldnames. You can format it in many ways [may be a neat way is to put each row in a line and well kinda......] unless the whole data is accumulated in one page.
let me know if I am clear
regards

sinapra
 
Old September 9th, 2004, 08:30 PM
Authorized User
 
Join Date: Aug 2004
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Default

excel...it is the word i am looking for.
thanks


 
Old September 10th, 2004, 09:45 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

So, how do you port the resultset to excel?

How about writing the your asp recordset to a csv file? which can then be opened using Excel and formatted to any if needed and printed.

Cheers!

_________________________
- Vijay G
Strive for Perfection
 
Old September 11th, 2004, 04:14 AM
Authorized User
 
Join Date: Aug 2004
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Default

happygv, thanks for reminding

your several posts clearly show me how to do reporting in csv format.







Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with approach rickyc1 Classic ASP Databases 4 July 14th, 2005 10:26 AM
VS.NET MODULAR APPROACH 3Moose BOOK: ASP.NET Website Programming Problem-Design-Solution 2 January 16th, 2005 12:20 PM
Datasets - what is the best approach? Dave Stumbles VB Databases Basics 0 January 12th, 2005 05:21 PM
Common question, not so common answer? flyin ADO.NET 5 March 24th, 2004 06:50 PM
what is the benefits for each approach alyeng2000 SQL Server 2000 6 December 31st, 2003 05:48 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.