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.

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

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

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

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

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

happygv, thanks for reminding

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