Hiding full rows with negatives value in a specific column

(0) Share

Report

Posted on by Shabir Ahmad

3,110

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 have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Martin Dráb 237,866 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Martin Dráb 237,866 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

Alfasith AX 120 User Group Leader on at

Like (1)

Report

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)

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

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

Thanks and Regards
Shabir Ahmad

Was this reply helpful? Yes No
Martin Dráb 237,866 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

Hi Alfasith AX,

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

Best Regards,

Shabir Ahmad

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

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

Was this reply helpful? Yes No