11,465
Hi,
I am using "Line Amount" from the Sales Invoice Line table in a Report. I have set the Number formatting in the RDLC as Custom and specified the "Line Amount Format" which is appearing in the RDLC based on the Data Item. I changed the regional settings to appear the Negative values as (XXX). But for my dismay, on the report, the negative values are still reflected as -XXX.
How to resolve this?
Best Regards,
MMV
*This post is locked for comments
When you goto text box properties and select number there is an option called use Regional Settings try to check how that is set and for the report which is working and which is not working.
First i Checked as Fields!DescountAmountFormat.value there is no change and after i changed as thousand seperator it's also didn't work toooo......
i don't Know why it is happend for some reportsonly.But it's works fine for some Reports, when i given thousand seperator it displays + and - values.
it's a strange behaviour,
Regards,
Ramesh.
What is the format value in the properties ?
No suresh it's direct dataitem field like Cdec(Fields!DiscountAmount.value) but in this fields Values are +,- or both.
+ values prints fine but - values print likes (XXXX).
Regards,
Ramesh.
What is your source expression for the textbox? are you using Cstr(Fields!....value)
Number Format
What format are you using currently ? Number or Custom ?
Hi Rajasekhar,
i tried above too,But it didn't work
Regards,
Ramesh
Can you check using CDEC(fields!lineamt.value).
Hi Mahesh,
Can You Find Solution for this Problem.I am also Facing same problem in one report only
Can you suggest me,
Regards,
Ramesh.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
