Hi, I have a problem on how I would print a report in my VB 2005 project. I have tried reading some notes in the Microsoft Developer Network for Visual Studio 2005 but I don't seem to get help.
My project is using Microsoft SQL 2000 for Storing and retrieving data, and I would wish to enable the person using it to be able to print reports on the daily occurrings according to the data contained in the database.

The database table am using has the following structure...

Table1:
AdmNo StudentNames Marks
 60 Julius Brown 55
 61 Chis Hart 85
 54 Brian Adams 65

The problem is that I would like to print the report for only one student by selecting that option and also print for all students if I choose to. I would also like to print only the names of all the students by choosing a certain option.

Thanks for reading this.

asdfre

Well, Crystal Reports is the robust reporting mechanism. But, as with anything robust, it is complicated to use.

You can access the data through a dataset or a datareader, and print it to a simple text file. In doing this, your [u]code</u> would establish which data are retrieved.

You can make a better looking report by doing almost the same thing, but by opening an instance of Word, and literally "typing" the contents of the document with the code you write.

With both a text file, and a more versatile word document, you can then open Notepad or Word, and load the document you just created into either of those apps.

A lot of work...