Hi @Raj ,
System.Web.Services.Protocols.SoapException: The Value expression for the text box 'Textbox5' refers directly to the field 'Property_Name' without specifying a dataset aggregate. When the report contains multiple datasets, field references outside of a data region must be contained within aggregate functions which specify a dataset scope.
at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, ItemType ItemType, CatalogItem& ItemInfo, Warning[]& Warnings)
at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings)
at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings)
Before that, let’s take a look at the following example:
- 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. - Then I add a scope for this expression to this
=First(Fields!Title.Value, "DataSetName")
, then everything is fine.
So 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.
Regards,
Joy
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.