This works but some Problems in count.. the count values for alll months is displayed in any one month....

Am not able to modify SP...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [pr_PatientDetails]

AS

BEGin

SELECT PatientDetails.PatientID, PatientDetails.MRN, PatientDetails.Code, PatientDetails.Chart#, PatientDetails.FullName, PatientDetails.FirstName, PatientDetails.Mi,

PatientDetails.LastName, PatientDetails.Suffix, PatientDetails.DOB, PatientDetails.Age, PatientDetails.SSN, PatientDetails.[Marital-Status],

PatientDetails.[Driver-Licence], PatientDetails.[Driver-Licence-State], PatientDetails.RefProvider, PatientDetails.Provider, PatientDetails.Employer,

PatientDetails.[Employer-Status], PatientDetails.School, PatientDetails.[ConInfo1-Address-1], PatientDetails.[ConInfo1-Address-2], PatientDetails.[ConInfo1-City],...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [pr_PatientDetails]

AS

BEGin

SELECT PatientDetails.PatientID, PatientDetails.MRN, PatientDetails.Code, PatientDetails.Chart#, PatientDetails.FullName, PatientDetails.FirstName, PatientDetails.Mi,

...

am not able to changa stored procedure ya i want to write code in rdlc expression only

thanks ya

DECLARE @StartYear INT

,@EndYear INT;

SET @StartYear = 2010

SET @EndYear = 2011

DECLARE @StartDate...

It's Also Works

Hi thanks ya its working good thank u so much

Thanks Ya... The join query works only if we are not using any filters like

grouping by some fields or getting results of particular years....

AM not Able To modify the storeed procedure.. i want to change that in designing because the same stored procedure is used for some other reporting... is it possible to...

2002 2003

Jan ...

Thanks For Your Reply......

Thanks For Your Reply......

Thanks For you reply.......

Thanks For your Reply.....