Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Hiding full rows with negatives value in a specific column

Posted on by 2,988

hiderows.png

Hi Experts,

I want to hide the entire row those rows which has amount negative, note i have already added an expression this column Amount to hide the -minus values in this column but hiding of -minus amount is not enough i want to hide all the row with this condition (blank column) Or all those row with will be minus amount in any row.

Best Regards,

Shabir Ahmad 

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: Hiding full rows with no value in a specific column

    HidingValues.png7573.png8836.png8535.png

    Hi Alfasith AX , Thanks

    The way you showed me was accurate but expression was not correct check this expression will work, for those who want to hide - minus values rows in Report.

    Best Regards,

    Shabir Ahmad

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: Hiding full rows with no value in a specific column

    8623.Expression.png

    Hi Alfasith AX,

    I follow your suggestion but check the error in the expression.

    Best Regards,

    Shabir Ahmad

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Hiding full rows with no value in a specific column

    Your report shows data from a temp table. You want to exclude rows of zero value.

    And your data provider class is responsible for inserting data in your temp table. 

    This means that your data provider class should insert only such records to the tamp table, that you want to see in the report.

    So, if you want to not show some rows in the report, then your data provider class should not insert them in the temp table.

  • Martin Dráb Profile Picture
    Martin Dráb 225,490 Super User on at
    RE: Hiding full rows with no value in a specific column

    You should use the "if" statement to check your conditions (whatever they're) and not call insert() if you don't want the line in the report.

    The insertion isn't shown in your screenshot, therefore I can't tell you where you're doing it and what's the best way to skip it.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: Hiding full rows with no value in a specific column

    4265.hiderows.png

    Ok, what should change or add in dp class please check the image if you have some suggestion.

    Thanks and Regards
    Shabir Ahmad

  • Verified answer
    Alfasith AX Profile Picture
    Alfasith AX 120 User Group Leader on at
    RE: Hiding full rows with no value in a specific column

    Hi Shabir,

    Please select the row you want to hide - > right click  -> Row visibility - > Show  or hide based on an expression.

    =IIF(<SomeId Field>,"DataSet1" == 0 ,False,True)

    row1.jpg

    row2.jpg

  • Martin Dráb Profile Picture
    Martin Dráb 225,490 Super User on at
    RE: Hiding full rows with no value in a specific column

    Yes, I do have a suggestion - it's in my previous reply. If it works for you, use it. If it doesn't, tell us why, so we can take your additional requirements into account.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: Hiding full rows with no value in a specific column

    Thanks for your reply Martin Dráb,

    First Requirement was to hide only vlaues with -minus as i hide it  now they want it to hide entire row values with minus.That's means values with minus will not be shown in report but in that colum some are plus values and some are minus values i just want to hide minus values if you have any suggestion?

    Best Regards,

    Shabir Ahmad

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 225,490 Super User on at
    RE: Hiding full rows with no value in a specific column

    I think the rigyht approach would be excluding it already in your RDP class.

    Why would you waste resources to insert the line and transfer it to the report, if you never want to show it? Simply check it in the RDP class and don't insert it if empty.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans