data not showing in reportviewer

Question

Hi friends The following is my stored procedure for taking case report. Collapse | Copy Code 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 RegistrationDatecad.Case_Number as CaseNumbercad.Court_Hall as CourtHallcad.Case_Type as CaseTypecad.Client_Type as ClientTypecld.Client_Name as ClientNamecld.Client_PhoneNumber as ClientPhoneNumbercop.Opp_Name as ClientOpponentNamecop.Opp_PhoneNumber as ClientOpponentPhoneNumber ld.Lawyer_Name as LawyerNameolmd.Current_Lawyer_Name as OpponentLawyerNamefud.Current_Details as CurrentDetailsfud.Current_Status as CurrentStagefud.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 desginthat is first(fieldname.value'dateset'). In the bottom of the filedname.value place the red line is there. what is the problem?

Ravi Kumar · Answer

hi check the below procedure. ALTER procedure [dbo].[sp_casedetailsreport] (@casenumber varchar(50)) as begin declare @layweid varchar(20) declare @lawyername varchar(50) declare @clienttype varchar(50) set @layweid=Current_Lawyer_Id from CMS.dbo.Client_Lawyer_Modification_details where Case_Number=@casenumber set @lawyername=Current_Lawyer_Name from CMS.dbo.OpponentLawyer_Modification_details where Case_Number=@casenumber select cad.Date AS RegistrationDatecad.Case_Number as CaseNumber cad.Court_Hall as CourtHallcad.Case_Type as CaseTypecad.Client_Type as ClientType cld.Client_Name as ClientNamecld.Client_PhoneNumber as ClientPhoneNumbercop.Opp_Name as ClientOpponentName cop.Opp_PhoneNumber as ClientOpponentPhoneNumber ld.Lawyer_Name as LawyerName olmd.Current_Lawyer_Name as OpponentLawyerNamefud.Current_Details as CurrentDetailsfud.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