Click here to Skip to main content
15,903,388 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi friends,

The following is my stored procedure for taking case report.
SQL
ALTER procedure [dbo].[sp_casedetailsreport](@casenumber varchar(50))
as
begin
declare @layweid varchar(20)
declare @lawyername varchar(50)
declare @clienttype varchar(50)
select @layweid=Current_Lawyer_Id from CMS.dbo.Client_Lawyer_Modification_details where Case_Number=@casenumber
select @lawyername=Current_Lawyer_Name from CMS.dbo.OpponentLawyer_Modification_details where Case_Number=@casenumber
select cad.Date AS RegistrationDate,cad.Case_Number as CaseNumber,cad.Court_Hall as CourtHall,cad.Case_Type as CaseType,cad.Client_Type as ClientType,cld.Client_Name as ClientName,cld.Client_PhoneNumber as ClientPhoneNumber,cop.Opp_Name as ClientOpponentName,cop.Opp_PhoneNumber as ClientOpponentPhoneNumber
,ld.Lawyer_Name as LawyerName,olmd.Current_Lawyer_Name as OpponentLawyerName,fud.Current_Details as CurrentDetails,fud.Current_Status as CurrentStage,fud.Next_Hearing_Date as NextHearingDate  from CMS.dbo.Case_details cad inner join CMS.dbo.Client_details cld on cld.Case_Number=cad.Case_Number and cld.Client_Number='P1'
inner join cms.dbo.Client_Opponent_details cop on cop.Case_Number=cad.Case_Number and cop.Opp_Number='O1'
inner join CMS.dbo.Client_Lawyer_Modification_details clmd on clmd.Case_Number=cad.Case_Number and clmd.Current_Lawyer_Id=@layweid
inner join CMS.dbo.OpponentLawyer_Modification_details olmd on olmd.Case_Number=cad.Case_Number and olmd.Current_Lawyer_Name=@lawyername
inner join CMS.dbo.Lawyer_Details ld on ld.Lawyer_Id=clmd.Current_Lawyer_Id
inner join CMS.dbo.Follow_up_details fud on fud.Case_Number=cad.Case_Number and fud.Date=(select MAX(Date) from CMS.dbo.Follow_up_details)  where cad.Case_Number=@casenumber
end


This actually give the output in the normal way. but i choose this stored procedure for getting report in rdlc report.I could not get this data in reportviewer but i can able to get the design what i designed in the rdlc form. i checked the dataset field expression in rdlc desgin,that is
first(fieldname.value,'dateset'). In the bottom of the filedname.value place the red line is there. what is the problem?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900