Hide/Show control on SSRS

(1) Share

Report

Posted on by SKO

297

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.

All responses (4)

Answers (2)

Suggested answer

Mohamed Amine Mahmoudi 9,738 Super User 2024 Season 2 on at

Like (0)

Report

Hide/Show control on SSRS

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
Verified answer

Martin Dráb 230,370 Most Valuable Professional on at

Like (1)

Report

Hide/Show control on SSRS

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.
SKO 297 on at

Like (0)

Report

Hide/Show control on SSRS

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.
Verified answer

Mohamed Amine Mahmoudi 9,738 Super User 2024 Season 2 on at

Like (2)

Report
Hide/Show control on SSRS

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