July 30, 2009 at 11:31 pm
Hello. Can someone please help.
In my detail row in the table I have the following expression:
=iif(Fields!PERIODID.Value=2 and Fields!Year1.Value = Parameters!Year.Value,Fields!Cost_Code_Actual_Cost.Value,"0")
In my Group row in the table I have the following expression:
=sum(iif(Fields!PERIODID.Value=2 and Fields!Year1.Value = Parameters!Year.Value,Fields!Cost_Code_Actual_Cost.Value,"0"))
When I run the report, the group row shows #Error. I am not sure why. All help would be appreciated. Thanks in advance.
July 30, 2009 at 11:39 pm
Duplicate post. Please do not cross post.
Direct all replies to this thread: http://www.sqlservercentral.com/Forums/Topic762905-149-1.aspx
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 31, 2009 at 1:53 am
Choose one:
http://www.sqlservercentral.com/Forums/Topic762902-149-1.aspx
http://www.sqlservercentral.com/Forums/Topic762910-150-1.aspx
http://www.sqlservercentral.com/Forums/Topic762907-150-1.aspx
http://www.sqlservercentral.com/Forums/Topic762905-149-1.aspx
http://www.sqlservercentral.com/Forums/Topic762899-149-1.aspx
http://www.sqlservercentral.com/Forums/Topic762894-149-1.aspx
http://www.sqlservercentral.com/Forums/Topic762892-149-1.aspx
http://www.sqlservercentral.com/Forums/Topic762890-149-1.aspx
-- Gianluca Sartori
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply