Crystal Reports crystal report design and code

Message

   a sample of my table is as shown below:

Staff_Id

Course_code

semester

year

Eval_no

evaluation

2020/g

comp201

1

2002

1

very poor

2020/g

comp201

1

2002

2

poor

2020/g

comp201

1

2002

3

fair

2020/g

comp201

1

2002

4

fair

2020/g

comp201

1

2002

5

very good

2020/g

comp201

1

2002

6

very good

2020/g

comp211

1

2002

1

very poor

2020/g

comp211

1

2002

2

poor

2020/g

comp211

1

2002

3

very good

2020/g

comp211

1

2002

4

very good

2020/g

comp211

1

2002

5

very good

2020/g

comp211

1

2002

6

very good

2020/g

comp201

1

2002

1

very poor

2020/g

comp201

1

2002

2

poor

2020/g

comp201

1

2002

3

Fair

…

…

…

…

…

…

I need to have a report of the form below: 

Staff_Id: 2020/g   course_code: comp201 semester: 1 year: 2002

Eval_no

Cout_ofVery_ poor

Count_of_poor

Cout_of_fair

Count_ofgood

Count_ofVery good

average

1

6

9

4

9

3

6.2

2

2

12

6

5

8

6.6

3

3

4

8

4

7

5.2

4

8

32

12

23

6

16.2

5

7

4

11

4

14

8

…

…

…

…

…

…

…

Total

26

61

41

45

38

42.2

Total

84.4

I'm using visual studio 2005. I'want to use crystal report of this studio to design and code my report but I'm some how new to report designing and coding. I'm an undergraduate class student working practical attachment using sql 2000 server, visual webdeveloper,vb.net as scripting language. I have an aspx page with wich this report should work. I already did the other part of my coding but report designing and coding become difficult to me. please help and let me get out of this headache. I appreciate this kind of forums and will continue to be a member after my graduation.thanx...

Edited by Dereje - 13 Oct 2009 at 9:24am