Multiple dataset error
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?
November 12th, 2010 1:32pm

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/
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 2:01pm

The name of the dataset is translation.
November 12th, 2010 3:44pm

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
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2010 12:32am

Challen Fu, old post, but have a question, how do I get a 8 page report to repeat? Lets say you are a doing a review based on a store location and your Report Parameters are "Year" and "StoreLocationName" You have 8 pages in the report and in the first page you need to list the employees infor on the first page and complete various data stored in the backend DB. How do I get the report to repeat for each employee based on the parameters passed? =First(Fields!Title.Value, "DataSetName") <--- Only gives me the first I need this to LOOP every employee.Moojjoo MCP, MCTS MCP Virtual Business Card http://moojjoo.blogspot.com
July 19th, 2012 8:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics