paula_sql
SSCrazy
Points: 2665
More actions
July 30, 2009 at 12:59 am
#156039
Can someone kindly help? WHat is wrong with this expression?
=iif(Fields!PERIODID.Value=1 and Parameters!Year.Value = (@Year),Fields!Cost_Code_Actual_Cost.Value,"NULL")
Value = 1 means July
Thanks!!
Jack Corbett
SSC Guru
Points: 184394
July 30, 2009 at 7:27 am
#1032371
What is @Year? I don't know of anything in SSRS that uses "@". Do you need to have a value there?
Jack CorbettConsultant - Straight Path SolutionsCheck out these links on how to get faster and more accurate answers:Forum Etiquette: How to post data/code on a forum to get the best help Need an Answer? Actually, No ... You Need a Question
July 30, 2009 at 5:08 pm
#1032743
@Year is the Year Parameter value.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply