Hi,

Thanks for your response!!

Am not supposed to you two procedures for this requirement.Need to accomplish in the same itself.Also the records returned when i put cross join is around more...

Thank you !!!!!!!

It works

Karl,

Me too did the same thing for taking current year and previous year.The problem is with performance.It takes nearly 5 mints if i gave the period 2 year or 3...

Thanks for your response..

But suppose if the value is custom formatted how can we place comma separator .

for example what i gave is "=Round(Sum(Fields!CashPrev.Value),0)".The result am getting is 12000.Now if...