Hello,
I have a electronic report that has initially worked fine.
After a customer request I am now trying to implement an ID as a page header on all pages but the first and Table column headers everywhere where lines are printed.
To achieve that I am following this guide:
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-paginate-excel-reports
My Format looks currently like this:
Mapping:
Validation returns now error or warnings.
But when I try to print a report I now always receive the following errors and the printing fails (Black spots contain customer name so I hid them):
I assume it has to do with the fact, that Area_PageHeader has NoReplication, but pops up on several Excel pages.
I am unsure why that happens, since the walkthrough (link above) explicitly says to turn replication off.
Hope somebody knows the issue and can help me fix it.
Best regards
T. Findeisen
Hello Alireza,
the Node "Area_PageHeader" is a Region, that contains 2 Cells. The region itself doesn't have a binding, since the content is bound to the 2 cells.
In the first cell we have 1 of 2 labels depending on if the field NumberSequence is empty or not.
The second cell is always filled with the ID which is always filled as far as I know.
So neither bound cell should return an empty value and I am not sure what content I should bind to the region itself.
In the walkthrough I mentioned above the region is not bound either.
Hi Thimo,
It seems correct on your mapping model.
Please check the format designer and node "Area_PageHeader", please try to add a binding for this node in a case that it returns an empty value.
Hello,
This is the model mapping that I am using. I marked the two fields that I am using for the pagination. I assume I don't need to do further model mapping?
But also as mentioned, even If I remove them from the format mapping, the error persists.
Hi,
That can be the root cause, since error message directed to a field that has not binding on your model mapping.
It means t have you have binded a field to your component in format designer that it has not binding in model mapping:
Example: Following screenshot clarifies about the binding:
Format designer:
Model mapping:
If your model mapping Fields does not have binding, you will get an error message if you binded them to your designer format.
Hello,
I haven't made any changes in model mapping when I added the pagination and the same logic works in the Cell Report TItle.
I also don't understand why the mapping is the issue when the mention field 'Area_PageHeader' doesn't have any bindings.
But I tested it again after removing the format mapping for ReportPageHeader and PageHeaderLabel Cells/Range.
Still receiving the same error.
I also debugged a run to check the Format Mapping content:
NumberSequence is an empty string -> Logic should pick second label
ID has also a string associated
Hi Thimo,
Then please check if you use recent model mapping format on your format designer.
You need to ensure that the format designer uses the format version of model mapping that has mapping/binding.
Hello Alireza,
the Number Sequence has been mapped in the Model mapping already and has thrown no issues in the cell "ReportTitle" before adding the Page changes.
Wouldn't also throw a validation warning when binding an unmapped field?
Hi Thimo,
The error message means that there is not binding on your data model mapping for .Agreement.NumberSequence.
Please check your mapping model and ensure that the mapping that use on your format designer has binding in model mapping.
André Arnaud de Cal...
292,074
Super User 2025 Season 1
Martin Dráb
230,900
Most Valuable Professional
nmaenpaa
101,156