Need help on printing. Im doing a Grade Slip System for a school.

[macmoy]

I am currently making a Grade Slip System for my School.

I am using VB.NET 2005 Standard Edition , SQL SERVER 2005 Express Edition.

I need help on printing the grade slips of students.

How am I gonna approach this?

I used RDLC files. (Add New Item>Report)
to view the file, I used ReportViewer.

I think this is the wrong way of doing it. isn't it?

My tables are:
---------------------------------------------------------
* [B]tblStudents[/B]
        includes:
                StudID,Fname,Lname,MI
---------------------------------------------------------
* [B]tblGrades[/B]
        includes:
                StudID,SubjectCode,Grade

In RDLC, The Textboxes is fixed on one datasource.

i.e.
Text1 always displays Fname.

I can't stick to that because in every StudID, it has one Fname and many Grades. And in 1(one) RDLC, It uses 2 tables.(although I can do it) But The Dataset in which the RDLC is bound, is fixed. I cant manipulate the dataset used. Kindly please point me to other approach. I am having difficulties using this method.

i.e.

---------------------------------------------------------
--GradeSlip--
StudID: 3052
Fname: Eric
Lname: Gonzales

SubjectCode: ENG111-1      Grade: 2.50
SubjectCode: HU111-1      Grade: 2.25
SubjectCode: GE213-1      Grade: 3.00
SubjectCode: ST109-1      Grade: 1.25
SubjectCode: PE1-1      Grade: 2.00
----------------------------------------------------------

How am I gonna approach this?
I also tried hardcoding.

i.e.

inside PrintDocument_Printpage:

e.Graphics.DrawString(etc.,etc.,etc.)


But is there any options that I can use to make it easier?

Any reply would be much Appreciated!
Thank you!

 

[macmoy]

Any Reply??????

Can Anyone Help Me With This???

Please.....................

 

[GameDudeGK]

Sorry I am new to reporting and even SQL so this may not be much help or at all, but its an idea at least:

Can't you make a stored procedure or a another table with both tables joined together based on your search criteria? Put that in the dataset and pull? the report designer has alot of stuff given to you so most could be drag and dropped, even the dataset.



also you can change the scope with something like

=(Fields!GPA.Value, "Second_DataSource")

Also not to bad a reference: http://marifegarcia.net/files/ReportViewer Compilation from MSDN.doc


George