You’re offline. This is a read only version of the page.
Announcements
18
Hi All,
i have added one date filed in design and wrote below expression --
=First(Fields!GDJ_InvoiceDate.Value, "SalesInvoiceHeaderFooterDS") when deploying then got below error --
but got below error --
System.Web.Services.Protocols.SoapException: The Value expression for the text box ‘Textbox27’ refers to the field ‘GDJ_InvoiceDate’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.
at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Guid batchId, Warning[]& Warnings)
at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) C:\Program Files (x86)\MSBuild\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.Reporting.Modeling.targets 466 6 GDJ_JPN_SalesInvoice
Kindly let me know how to resolve the issue
Please give me more shed on this.
Thanks!
Hi @rp@n,
Do you reference multiple data sets in the same data region? What are your specific needs?
The simple method is that one region corresponds to one data set.
Please check this if it's helpful: https://stackoverflow.com/questions/45057360/ssrs-error-report-item-expressions-can-only-refer-to-fields-within-the-curren
Hi @rp@n,
this error indicates that the field you provided in the expression does not exist in the SalesInvoiceHeaderFooterDS dataset - so either you added it to a different temporary table and by doing so it is now in a different dataset, you used a different name for it (are you sure you used the GDJ_ prefix in the field name? and not GDJ alone or GDJ_JPN_? no spelling issue? no letter case mismatch?),... or you have not refreshed the SalesInvoiceHeaderFooterDS dataset. Could you please double check it? This field needs to be present in the fields list of the SalesInvoiceHeaderFooterDS dataset with the exact same name as used in the expression.
#1
André Arnaud de Cal...
294,099
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
