Hide/Show control on SSRS

(1) Share

Report

Posted on by SKO

468

Hello,

I have customized the Cheque report (Cheque_US) in D365 F&O. Added a new textbox to the design on the Cheque section in the bottom and wanted to show/hide based on the value of Amount field. There is an error when I open the report. Not sure what is wrong

"The Hidden expression for the text box 'Textbox39' contains an error: Input string was not in a correct format.

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @srikanthkonda

this problem is due type of Amount fields is string.

so you must to convert from string to decimal.

try this :

IIF(CDec(Fields!Amount.Value) <= 0, True, False)

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
SKO 468 on at

Like (0)

Report
Copy link

Link copied!

Thanks for throwing light, I totally missed this point and never expected amount to be string. This gives me another error but will try to fix it.

The Hidden expression for the text box 'Textbox39' contains an error: Conversion from string "992.40***" to type 'Decimal' is not valid.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,029 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You'd need to remove the extra characters to get a string that can be converted to a number. Using AmountCur field instead of Amount is better.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

As marin say i think you must use the amountCur field.

Otherwise you must remove the special characters from amount value.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No