I 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)
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.
