Print Page | Close Window

Report for student marklist

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17947
Printed Date: 14 May 2024 at 11:41pm


Topic: Report for student marklist
Posted By: shamsi
Subject: Report for student marklist
Date Posted: 07 Nov 2012 at 8:11am

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


Print Page | Close Window