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