#Error problem in Print Documents

(0) Share

Report

Posted on by manish.yadav

1,893

Hello Experts all,

I am trying to add the total qty in rdlc..but in output always showing the # Error. My expression is below with print layout. please suggest me to resolve it.

8712.uu.png

*This post is locked for comments

All responses (5)

Answers (2)

Suggested answer

asouiak 97 on at

Like (0)

Report

RE: #Error problem in Print Documents

hi

i have the same of this problem but in fields value not SUM function excatlley am working into report ID 38 ( Blance By period ) the canit be as decimal or integer when export to excel #error code is preview i tested a lots of function and no working can help me

thank you
manish.yadav 1,893 on at

Like (0)

Report

RE: #Error problem in Print Documents

Through this, query resolved. Actually, I have added the unit of measurement and qty in same data fields.

FORMAT("Transfer Shipment Line".Quantity)+' '+"Transfer Shipment Line"."Unit of Measure"

That's a reason, the error was coming.

thank you very much for your support.

Now query is resolved.
manish.yadav 1,893 on at

Like (0)

Report

RE: #Error problem in Print Documents

Still getting the no result, showing all 0
Verified answer

Suresh Kulla 47,789 on at

Like (1)

Report

RE: #Error problem in Print Documents

Hello,

Please convert your Qty_Nos to integer. Try like this Sum(CInt(Fields!Qty_Nos.Value)
Verified answer

Binesh 7,885 on at

Like (0)

Report

RE: #Error problem in Print Documents

Hello,

write something like:

=SUM(IIF(IsNumeric(Fields!Qty_Nos.Value), Fields!Qty_Nos.Value, 0))

Note: This error mostly came, if value is not in correct format that are acceptable by field or divide by zero.