Small and medium business | Business Central, N...

Rendering output for the report failed with error: Value does not fall within the expected range.

(7) Share

Report

Posted on by AK-29072244-0

I am getting the following error when applying certain filters on a third-party BC report. However, it goes away when I remove one of the existing filters and apply a filter on another field.

Does anyone know what causes this error and how to avoid it? Any suggestions would be greatly appreciated, thank you.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 99,090 Super User 2026 Season 1 on at

Like (6)

Report
Copy link

Link copied!

I suggest debugging this; it's clearly a customization issue.
Or you can directly contact the partner who customized this extension to resolve the issue.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,973 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

Hello,

Usually it’s caused by:

A bad or blank value (like invalid date or long text).

An RDLC expression or style issue.
Try to export the dataset as Excel/XML (data only)

Try another layout (Word/Excel) to confirm it’s layout-related.

If it’s a third-party report, contact the ISV or developer to adjust the RDLC expressions.

Regards,
Oussama

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,132 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

This issue typically occurs when a filter combination returns a null or empty value where the layout expects a number or date, when there is a data type mismatch in the RDLC/Word layout, or when the report dataset includes unexpected values due to applied filters.

Since this is a third-party report, it’s recommended to contact the vendor or developer of the report or extension for further assistance in identifying and resolving the issue.

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 9,112 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!
Hi,

The error message Value does not fall within the expected range is a rendering-level failure, meaning the report dataset was generated, but the layout engine (Word, Excel, or RDLC) encountered a value it couldn’t handle.

Here’s what we can do.

1. Validate Filters and Field Types

This error often occurs when a filter returns null or unexpected values that the layout control cannot render.

For example, if a textbox expects a date but receives a blank or malformed string, rendering fails.

Try applying filters incrementally and observe which combination triggers the error.

2. Export Dataset to XML or Excel

Run the report and choose Send to > XML (data only) or Microsoft Excel Document (data only).

This lets you inspect the raw dataset and confirm whether any fields contain unexpected values.

Look for blank fields, nulls, or mismatched types (e.g., text in numeric fields).

3. Check Layout Controls

In RDLC or Word layouts, ensure that controls are bound to the correct field types.

For example, a textbox bound to a decimal field should not receive a string.

If using conditional visibility, ensure expressions are valid and do not reference missing fields.

4. Review Report Limits

BC enforces limits on row count, merge volume, and execution time.

If your filters return a large dataset, the report may exceed these limits and fail.

Consider applying tighter filters or paginating the report.

5. Debug with OnAfterGetRecord

Add logging or message boxes in the OnAfterGetRecord() trigger to trace which records are processed.

This can help isolate problematic records or fields.

6. Third-Party Report Considerations

If the report is from a third-party extension, check whether it expects specific fields or dimensions.

Some reports rely on custom logic or hidden fields that break when filters exclude them.

Helpful Reference
Troubleshooting reports – Microsoft Learn
Community thread: Report rendering error – Dynamics NAV Forum

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Aman Kakkar 3,020 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi,

This might be an issue of the third-party app that you are using. If you could just click on share details -> copy error details and paste it here, we might be able to get more insights. Else you yourself may need to debug and find the error as for which field does the rendering fails.

Hope this helps.

Aman K

Was this reply helpful? Yes No