Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Hide/Show control on SSRS
Finance forum
Answered

Hide/Show control on SSRS

Posted on by 259
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.

  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 9,316 Super User 2024 Season 2 on at
    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 Profile Picture
    Martin Dráb 228,501 Most Valuable Professional on at
    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.
  • srikanthkonda Profile Picture
    srikanthkonda 259 on at
    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 Profile Picture
    Mohamed Amine Mahmoudi 9,316 Super User 2024 Season 2 on at
    Hide/Show control on SSRS
     
    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

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans