I created a simple 1 table report for SSRS 2008R2, runs fine. I then added a 2nd dataset to the report for label translation. When I set the report title to =First(Fields!Title.value, "translation"), get this error: The value expression for the text box 'textbox1' refers directly to the filed 'Title' without specifying a dataset aggregate. When the report contains multiple datasets, field references outside of a data region must be contained within aggregate functions whick specify a dataset scope. Any ideas what the hangup is?

Whats you data set name Your expression should be =First(Fields!Title.Value,"DataSetName") Data Set name will the data set where this filed is coming, than it will work. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

The name of the dataset is translation.

I created a simple 1 table report for SSRS 2008R2, runs fine. I then added a 2nd dataset to the report for label translation. When I set the report title to =First(Fields!Title.value, "translation"), get this error: The value expression for the text box 'textbox1' refers directly to the filed 'Title' without specifying a dataset aggregate. When the report contains multiple datasets, field references outside of a data region must be contained within aggregate functions whick specify a dataset scope. Any ideas what the hangup is? Hi StormRider01, I test your scenario in my local environment following these steps: 1. Add a textbox to the report as the title, then drag the field of Title to the textbox, the expression in the textbox is =First(Fields!Title.Value) then it will display the same error as you gave. 2. Then I add a scope for this expression to this =First(Fields!Title.Value, "DataSetName"), then everything is fine. So here I would recommend you have a check to see whether you have some other textboxes whose expression lacks of scope name. If all the expression is correct, you could delete this textbox to make sure whether the root cause comes from it. If it does not work, please give a feedback and more detailed information, which is a big help for us to supply a further assistance. Thanks, Challen Fu