Share
Report
156I am attempting to add another Dataset from the same table (specifically Sales Return Order Header) so that I can add a set of fields onto a Sales Return Order custom report layout.
Unfortunately, the result was that I receive this error when I preview the Sales Return Order's print preview over on Business Central:
Rendering output for the report failed and the following error occurred: The Value expression for the text box ‘Textbox3’ 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.
I am getting the impression from Copilot and other resources saying that the syntax is not correct or I have to configure something (unclear of what, how and where exactly) to add this SalesReturnOrder to this particular RDLC report.
When I use the tool Microsoft Power Bi report builder to reinsert this field onto the custom report layout (specifically the header portion of the layout), I still receive the rendering output error mentioned above (in italics).
On my attempt of a solution, I put this into Textbox3:
=First(Fields!Sell_to_Customer_Name.Value, "SalesReturnOrder")Here is a screenshot to show how I inserted and came up the above into the RLDC report using Microsoft Power Bi report builder program: (Textbox3 is selected)
Looking back, as I recently updated the Microsoft Power Bi builder program, I was able to discover that I can right click Data Sources folder on the left and select "Get Data" to reach the Business Central data source:
(I was able to successfully add the Sales Return Order table to the Data Sources folder)
(I was able to successfully add the Sales Return Order table to the Data Sources folder)
Was someone able to achieve something similar with what I was trying to do and can assist with what I can do differently to resolve this issue?
Your help is much appreciated.
All responses (
Answers (
