Kiran Karale

Kiran Karale

  • NA
  • 390
  • 214k

crystal Report

Apr 11 2011 6:24 AM

 I have problem in Cryatal report
how to Skip/eliminate Descript values in  crystal report
 

Stored procedure
===============
ALTER PROCEDURE [dbo].[sp_GetFeePaidInfo]
(@StudentId numeric(18,0)=null,
 @PhoneNo varchar(100)=null)
AS
BEGIN
    SET NOCOUNT ON;
    SET NOCOUNT ON;
SELECT  SI.StudentID,SI.StudentFirstName  +' ' + SI.StudentLastName [Student Name] ,SI.StudentPhoneNo [Phone No],SI.StudentEmailId Email,
        TI.TechName Course,FI.FeeAmount Fees,FI.FeeId FeeID,sum(isnull (FPI.FeePaidAmount,0)) Paid ,avg(FI.FeeAmount)-sum(isnull (FPI.FeePaidAmount,0)) Balance
FROM  StudentInformation SI
INNER JOIN dbo.FeeInformation FI ON SI.StudentID=FI.FeeStudentId
left outer JOIN dbo.FeePaidInformation FPI ON FI.FeeId=FPI.FeeId
INNER JOIN dbo.TechnologyInformation TI ON FI.FeeTechnology=TI.TechId
where SI.StudentID=ISNULL(@StudentId,SI.StudentID) and SI.StudentPhoneNo=ISNULL(@PhoneNo,SI.StudentPhoneNo) group by SI.StudentID,SI.StudentFirstName , SI.StudentLastName ,SI.StudentPhoneNo ,SI.StudentEmailId ,
        TI.TechName ,FI.FeeAmount ,FI.FeeId

=========================================
i attached Source Code of Crystal Report
 

Attachment: doc.rar

Answers (1)