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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / #Error show on RDLC la...
Small and medium business | Business Central, N...
Suggested answer

#Error show on RDLC layout report SUM of some line value, on Shopify synchronize order

(0) ShareShare
ReportReport
Posted on by INY 4
I modified from the built-in RDLC 1306 sale invoice report layout, use a SUM in expression to calculate the total of the order line discount value. It work fine on the order I created manually. but showed #Error on order sync from Shopify. 
My expression involve 3 value from Dataset. I found for "LineDiscountPercent_Line" the Sum work fine on, but "UnitPrice" & "Quantity_Line" both can not get the Sum work in Shopify order. 
Could any one kindly help me locate the Error, and how to fix it.  
 
This is the expression:
Work fine on normal order:
Show error on Shopify order:
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 19,137 Super User 2025 Season 2 on at
    #Error show on RDLC layout report SUM of some line value, on Shopify synchronize order
     
    The #Error in the "Discount Total" field in your RDLC report could be caused by data type mismatches or handling of null values. Ensure that all fields like Unit Price, Quantity, and Line Discount are numeric, not text. To avoid errors, use an IIf condition in the expression to replace null values with 0.
    For example: =SUM(IIf(IsNothing(Fields!UnitPrice.Value) Or IsNothing(Fields!Quantity.Value), 0, Fields!UnitPrice.Value * Fields!Quantity.Value * Fields!LineDiscountPercent.Value)).
    Exporting the dataset can also help confirm the data integrity
     
     
  • Suggested answer
    INY Profile Picture
    INY 4 on at
    #Error show on RDLC layout report SUM of some line value, on Shopify synchronize order
    Thank you Khushbu Rajvi,
     
    I tried the code, it still only work on normal order I created manually, but showed #Error on Shopify order.
    I wonder are Shopify orders have different dataset structure. 

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,202

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,248

#3
Sumit Singh Profile Picture

Sumit Singh 2,893

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans