web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

RDLC Report Flowfield crash report

(0) ShareShare
ReportReport
Posted on by 1,165

Hi All,

I have added two flow fields to the dataset of the report through an Extension. When I add the first field which is a flow field, report works.  When I add the second flow field (which depends on the first flow field) report crash. Both flow fields in item table and works on web page. Difference is second flowfield uses first in where clause of the flow field expression in item. 

In Table something like this:

         FLowField1

         FLowfield2  calcformula = table.field (where table.field2 = field(Flowfield1))

Looks like you cannot have flowfiled on flowfield on the source table when it comes to RDLC dataset.  Other option is to create a variable on the report dataset from scratch

Thanks

  • Suggested answer
    Suresh Kulla Profile Picture
    50,280 Super User 2026 Season 1 on at

    You cannot have a flowfield based on a flowfield, the flowfield is not a real field it is a temporary field and gets calculated only when you use CALCFIELDS.

  • Anita75 Profile Picture
    1,165 on at

    This is what I thought so in this case you use a variable in the dataset with CALCFILED(flowfield)?

  • Suggested answer
    JAngle Profile Picture
    159 on at

    If it for the main data item then yes use a variable and add to it per row with +=

    If it is for a different table to the main dataitem you may want to use an additional integer dataitem (integer equaling 1) so all the calculations happen once. Might do this if your report is for sales invoices but you want to including a total of sales credit memos but so no details.

  • Verified answer
    Suresh Kulla Profile Picture
    50,280 Super User 2026 Season 1 on at

    Yes, you can create a variable to calculate the flowfield value and then use that in your dataset or in any other calculation you want.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 757 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 451 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 391 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans