Hi all,

I have to create student marklist report.The report shoulb be like below..

Same report need 3 subheading  as

  1. Passed Student  List ( Passed in all subject)

  2. Resit  Student List (Failed in 3 0r less subject)

  3. Failed Student List (Failed in 4 or more Subject)

 

 

SLNo       StudentName          English        Arabic    Maths      Biology

                             

                               Passed Student List

1                 Ram                      67           80           98           56

2                 Radha                   78            75           56           75

                                Resit student List

1                 leela                     43            60            32           72

2                 Sajan                    67            24           55           69 

                                 Failed Student List

1             karan                43            12             24       14                          

 

The sql query for the above conditions I already created.But I dnt know how to design this crystal report and how to apply this sql query to it.Please help me to solve this problem..

Thanks in advance

Shamsi