Hi Friends
Can u pls help me out in the report customization as follows:
I Have a Subjects Table with fields as
SubjectId SubjectName
1 Maths
2 Science
3 Social
4 G.K
5 Hindi
and i have StudentTable as follows
StudentId Subject Marks
1A Maths 20
1A G.K 30
2A Maths 50
2A Hindi 40
the Report Format is
StudentId Maths Science Social G.K Hindi
1A 20 0 0 30 0
2A 50 0 0 0 40
Please help me out in Quering the Data to get in the report as shown above.
Thank You
Regards
Chinna