crystal Report

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Crish15y ago
If you are .net person,you use other method for it.

Step 1:

you 1st choose dataset.

than drag-drop table which u need in the report from server expolor.

save->close

Step 2 :

choose crystalReportviewer from tool box.

then select option which you need.

Step 3 :

take web form

DataSet1 ds = new DataSet1();

DataSet1TableAdapters.MessagesTableAdapter a;
a = new DataSet1TableAdapters.MessagesTableAdapter();

a.Fill(ds.Messages);

CrystalReportSource1.ReportDocument.SetDataSource(ds);

try it.