Declare @DateInput as Date

Select

Case when @DateInput between '2012-06-06'and '2013-06-10'

Then

AnniversaryStartDate

when @DateInput between '2012-06-06'and '2013-06-10'

Then

AnniversaryEndDate

Else

Null

End as AnniversaryStartDate,AnniversaryEndDate

from dbo.AnniversaryData

where DateInput = @DateInput

This resolves the issue...

Thanks.

convert(varchar,columname) helped in SSRS.

But Can I use All for two parameters?

I was about to post everything. But what you sent actually helped.

Thanks so much

Are you writing a store procedure for it?

Yes, So, I changed the format in SQL and then just bought the field to SSRS.

That worked.

Wow, That surely helped.

But my data should start from June,2013 going backword. ( Thats how the Query is written and executes in SMS).

In the matrix it starts with 012013

Any Idea...

That sure helps.

Yes , Prod year is int.

select ProdMonth ,ProdYear from Production

where ProdYear >= DATEADD(yyyy,-1,getdate())

returns no data... However , there is data present. DOn't know whats wrong...

Worked!

Great. Thank you.

For Quick reference of queries

Great.

Any clue how that will work in crystal?

That sure helps.

Thank you.

Oh Yes. ...

Thanks again.