How to print a report from an SQL database using Visual Basic?

Question

I have an SQL database with records of different library members. At the end of the month, I need to print out a sheet with all members who haven't returned their library books and their addresses. I am okay with the query, but I don't know how to print out the results on a paper in tabular form? Is there a proper way of doing this?

I was thinking of writing the results to an html document and printing that. Would that be a good idea? Thanks for your help.

score 1 · Answer 1 · answered Mar 14 '12 at 11:22

You could use Crystal Reports, an extension that shipped with VB6: http://www.vb6.us/tutorials/using-crystal-reports-vb6-tutorial

Or a very crude way would be to create an MS Excel file rather than an HTML file as it would give you much more structure control along with an excellent editor post generation.

score 1 · Accepted Answer · edited May 23 '17 at 10:24

1

Hiya hope link below help; :

[links] - with code

1) Export to excel - export from sql server to excel file using asp.net and vb.net?

2) Crystal report - http://vb.net-informations.com/crystal-report/crystal_report_from_sql_query_string.htm

hope its helps, if you want you can share what you have done, I can try and fix your code. Cheers!

edited May 23 '17 at 10:24

Community

1
1

answered Mar 14 '12 at 11:25

Tats_innit

33,991
10
71
77

score 1 · Answer 3 · answered Mar 14 '12 at 11:58

1

You can use Word mailmerge with ODBC databases to create directories ( http://support.microsoft.com/kb/294693 ). A HTML document also sounds quite useful.

answered Mar 14 '12 at 11:58

Fionnuala

90,370
7
114
152

How to print a report from an SQL database using Visual Basic?

3 Answers3