Announcements
No record found.
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
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.
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?
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.
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)
Ok, what should change or add in dp class please check the image if you have some suggestion.
Thanks and RegardsShabir Ahmad
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.
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.
Hi Alfasith AX,
I follow your suggestion but check the error in the expression.
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.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 689
André Arnaud de Cal... 455 Super User 2026 Season 1
Syed Haris Shah 308 Super User 2026 Season 1
