Hiding full rows with negatives value in a specific column

(0) Share

Report

Posted on by Shabir Ahmad

3,024

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

All responses (9)

Answers (1)

Shabir Ahmad 3,024 on at

Like (0)

Report

RE: Hiding full rows with no value in a specific column

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 3,024 on at

Like (0)

Report

RE: Hiding full rows with no value in a specific column

Hi Alfasith AX,

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

Best Regards,

Shabir Ahmad
Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

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 230,198 Most Valuable Professional on at

Like (1)

Report

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 3,024 on at

Like (0)

Report

RE: Hiding full rows with no value in a specific column

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 120 User Group Leader on at

Like (1)

Report

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)
Martin Dráb 230,198 Most Valuable Professional on at

Like (1)

Report

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 3,024 on at

Like (0)

Report

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 230,198 Most Valuable Professional on at

Like (1)

Report

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.