My expression is :

= CASE WHEN Fields!PremuimMonth.Value >= DATEADD("mm",-3,NOW())THEN Fields!PremiumAmount.Value ELSE " " END As "AVERAGE AMOUNT"

Case is not working in SSRS...It is just showing #error

Getting errors while write the case statement...can we try same thing in switch??

I want to get the past 12months date depending on the parameters chosen from report!!!!! I need to write an expression to get it...but getting errors:

=DATEADD("MM",DATEDIFF("MM",0,Parameters!RunMonth.Value)-11,0)

tried different ways...:(

Thank you....I have another issue with datepart .I have @Year and @Month values comming from Parameter.

I need to write expression to get the 12month rolling date ,selected...

I got it...I created another Dataset for Guid which is tied to Name and passed those values to GUID.:)

No default value too!!

Nope....Null is not allowed!!!

Hey...I know how to add expressions....but did not understand your iff condition!!

Hi ...can you please be more specific....? i did not understand??

I dont want to change anything to storeproc , but add as a seperate column as average : to display average for past three months( from current month) and also...

Hey thank you....I got it by quaterly.Now I need to get average and totals of the past three months "Pamt" for each "cname" across all " LOCDESC".This is Different...

Updated the table.But still did not get how to merge the dataset (created from storeproc) with the calender table? to get as one dataset in ssrs???

On what column to join???

Hi...I see the table you sent have month names in diff language ?? Can I get the one with English please???

Or It maight not make difference???

Thanks,

komal

I am getting the parameter values from the Store proc for @runyear and also data!!!!