I achieved this through the report viewer by selecting the server report in the report viewer properties in visual studi 2005 and giving reportserver URL and report path in the...

I need that to be in datetime only

and change the format

=Iif(DateDiff(

"m",CDate(Fields!ActsDate.Value),CDate(Fields!ItemDate.Value)

)>=6,"Red","Black")

getting error in this...

Fields!ActsDate.Value and Fields!ItemDate.value are coming varchar format

I have the dates coming in varchar format.how can use the above expression in color..

Thanks

It doesnt work

The query has 12 joins in that 2 views are there...

i can not use indexed view..help me out..

yes,snap shot..a read only copy for the table