SSRS 2008 Report Upgrade Issue 1. We are having an upgrade issue on a report that was converted to from a table to a tablix control. The report will not run unless we remove the expression noted below. The expression is used to determine if the Fund value has a border or note. 2. Error Message [rsInvalidAggregateScope] The BorderColor expression for the text box ‘textbox60’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset. [rsInvalidAggregateScope] The BorderStyle expression for the text box ‘textbox60’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset. Build complete -- 2 errors, 0 warnings 3. Code that is causing the error on a textbox within a grouping a. Property – BorderColor Expression iif(Fields!FundCode.Value=previous(Fields!FundCode.Value),"White","Silver") b. Property – BorderStyle Expression iif(Fields!FundCode.Value=previous(Fields!FundCode.Value),"None","Solid") 4. Is this a conversion issue or will this code not work within the Tablix control? Has the syntax changed to allow this to work, if so what should the syntax be changed to? We have samples available to show if you want to see the before and after. Thanks in advance for any info.Steve Froehlich

Hi Steve,These expressions should be right in syntax, and also work well in SSRS 2008. I have a doubt that there is no scope parameter in the expressions in nature but the error indicates the issue associated with scope parameter. To verify it, please delete the expressions from BorderColor and BorderStyle and check that what any thing will happen when previewing. Please provide these information here if the issue still is not solved.thanks,Jerry

When we delete the expression, it will run fine. It seems to not like the "previous" function.Steve Froehlich

Jerry I have bee working with Steve on this issue and have not found a resolution other than to remove the previous function.I also tried adding another text box to see if I could just get the previous FundCode to display. The expression I used is below. =previous(Fields!FundCode.Value, "dsGetRevAndExp")The Expression window highlights the code above saying "Wrong number of arguments"The report runs with the expression above, but no values are displayed for FundCode.In 2005 MSDN noted that you cannote use the Previous function within a Matrix. Can you use the Previous function with a Tablix?

Hello Jerry, I did notice that the upgraded report looks like it did not convert the detail line correctly.The report prior to upgrade had a Table Details Row. After the report was upgraded it looks more like the "One outer group with a footer row for totals and one inner group" as noted on the link below.http://msdn.microsoft.com/en-us/library/cc627578.aspxIf it would help I could send you the rdl file before the upgrade and after.Larry

For people trawling this post up, the problem is that there's a Group wrapped around one or more detail rows. See the URL http://www.ssrstips.com/duh-moments-previous-and-cross-apply for more description. For those without patience, use: Previous(First(Fields!FOO.Value, "GroupName"))